I have been asked to monitor SQL to tell me when we are performing
better than others. Can anyone tell me what kinds of scheduled jobs or
scripts they utilize?

dalst36 (dalst36@yahoo.com) writes:
> I have been asked to monitor SQL to tell me when we are performing
> better than others. Can anyone tell me what kinds of scheduled jobs or
> scripts they utilize?

Could you be more specific? What do you mean with "performing better
than others"? And whoever those others are, I don't know what scripts
they use.

To know which tools you should use, you first need to what you want
to measure.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp