Recommendation os SQL Server Monitoring Tool

[DataPro]

Our shop is expanding use of SQL Server, both 2000 and 2005. We have
Litespeed on some boxes to handle the backup/recovery jobs. Can I ask
what are considered the best tools for monitoring SQL Server, in terms
of things like performance monitoring, tuning and auditing if it is
possible to get all of this functionality in one?

What do you use and like?

Thanks in advance.

Gerry

[Oscar Santiesteban]

Re: Recommendation os SQL Server Monitoring Tool

try Spotlight on SQL Server from www.quest.com
It is licensed per server but a very useful tool.

What do you use and like?
>
Thanks in advance.
>
Gerry
>

[DataPro]

Re: Recommendation os SQL Server Monitoring Tool

Thanks Oscar..will look into it.


Oscar Santiesteban wrote:

try Spotlight on SQL Server from www.quest.com
It is licensed per server but a very useful tool.
>
>
>

What do you use and like?

Thanks in advance.

Gerry