March 26, 2008 at 9:23 am
We are trying to run Profiler against SQL 2000 for an extended length of time but I am concerned of the large amount of data captured if we let it run over night. I know I can stop the profiler trace and save to a file or a SQL Server table but are their any other options like to run profiler and have it DIRECTLY insert the data into a table ? Any help would be appreciated...
Is there anyway to direct the Profiler activity to another drive other than the C drive ?
March 26, 2008 at 9:40 am
you can save to a file on any drive that the process can see. You can also set a rollover so that you don't get huge files. Maybe script a process to copy those files to another server periodically.
March 27, 2008 at 7:30 am
Not quite spot-on for the topic line but I'd like some opinions on what I should be looked at within profiler. My scenario: I have a server, SQL2K, Win2K and 4Gb of RAM, running a small but much used application (time and attendance). I have roughly 300 people logging into the server to punch in and out, so twice a day, and our payroll people using the system to collect the data (2 or 3 people, sometimes during the day). Since we are trying to reduce server sprawl, this seems like a good candidate to consolidate with another application. What items make the most sense to track to determine the load that this application is having on the server? Reads, cpu, memory all come to mind. Anything else that would provide some metrics of value? Any suggestions are much appreciated. Thanks.
-- You can't be late until you show up.
March 28, 2008 at 7:44 am
These two articles gave me a good high level look at a couple of things I hadn't read about before in using performance monitor:
http://www.sql-server-performance.com/articles/per/System_Monitor_Hardware_Bottlenecks%20_p1.aspx
The first one is a good quick look at how your server's memory is doing. It's not terribly deep into the inner workings but it's a nice quick check.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply