How do you monitor SQL?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 1

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]

Colin Bowern-465835 Valued Member Points: 55 More actions · Answer 2

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.

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

Then think of using Quest's co-efficient.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

jericho Valued Member Points: 54 More actions · Answer 4

Have you seen this perfect document

if not, try to read it! It was very helpful for me!

And more practice link based on document above

I think it will help you when you will understand blueprint in first link.

sumit-314810 SSC-Addicted Points: 402 More actions · Answer 5

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

Cookies on SQLServerCentral