May 18, 2011 at 10:03 am
I have a pretty heavily used SQL Server 2005 environment. I would like keep track of resource utilization along with queries. No only I want to create metrics for resource utilization but also I want to be look at what queries were running ..e.g. two days ago at 3 am that spiked that CPU and RAM.
how can I accomplish that? is that possible with SQL Server? I think in this case I will have to store both resource utilization information and query load.
I can probably store queries by running profiler but not something I want to do. As profiler puts heavy load on the server.
May 18, 2011 at 5:52 pm
You can Do that...
To get the resource utilization , start a perfmon counter Log .
To capture the SQL Queries, start a SQL Server profiler.
Then you can import perfmon data into the profiler and check the resource utilization at times when the individual queries were run...
To reduce the impact of the Profiler, run a server-side trace from a remote server.
Thank You,
Best Regards,
SQLBuddy
May 18, 2011 at 5:59 pm
Check this link ..
Thank You,
Best Regards,
SQLBuddy
May 18, 2011 at 6:36 pm
Just remember that the Profiler gui is good for browsing the data later. Don't use it to monitor the server. Capture the data with a server-side trace.
If you really want to check out the data, you might want to look into the RML Utilities from Microsoft. They really help analyze queries and they're free.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 18, 2011 at 6:44 pm
Grant is Right.. Follow his advice. RML Utilities is a good tool for the analysis.
Thank You,
Best Regards,
SQLBuddy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply