July 17, 2007 at 1:17 pm
We've got a growing database server that is quickly getting more active. I wanted to find out how folks monitor their SQL Server 2005 instances? What tools have worked for you? What guidelines have you followed?
In particular, I want to be able to establish which database is driving the most activity, and diagnose which calls or statements are causing the most resource usage. On a bigger picture I want to understand how others are approaching monitoring in general with regards to SQL Server 2005.
Thanks!
Colin
July 17, 2007 at 3:13 pm
you can run the sql profiler in sql 2005 and monitor the bottlenecks in sql server....refer, http://technet.microsoft.com/en-us/library/ms181091.aspx
[font="Verdana"]- Deepak[/font]
July 17, 2007 at 3:18 pm
SQL Profiler is great, but it's more of a point-in-time diagnostics tool. I'm looking for more of a steady state tool.
July 18, 2007 at 1:32 am
Then think of using Quest's co-efficient.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 18, 2007 at 3:56 am
Have you seen this perfect document
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx
if not, try to read it! It was very helpful for me!
And more practice link based on document above
http://www.codeplex.com/sqldmvstats
I think it will help you when you will understand blueprint in first link.
July 18, 2007 at 5:08 am
I would suggest using the Reports section of SQL Server 2005 to monitor the performance of the SQL Server at run time.
For Example the following Reports
1> Server Dashboard
2> Performance : Top Queries by Total CPU
3> Performance : Top Queries by Total IO
4> Activity : Total Cursors
All of these reports are the Standard Reports from SQL Server Management Studio.
These reports in turn Query the Dynamic management views,catalog views .
Thanks
Sumit
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply