I am working for a customer that has over 30 SQL Server 2005/8 databases in their enterprise. The databases are small to medium size (few gigabytes at the maximum). The customer has requested me to research a few third party SQL Server performance monitoring tools. I found this link that compares a few tools:
Two tools Idera SQL Diagnostic Manager and Precise i3 for SQL Server appear very promising. Have you used any of these tools? Or do you have a recommendation for another tool?
The other option, of course, is to build scripts that utilize system tables, dynamic management objects, built-in functions etc. But I think a third party tool is probably a better investment since they want this done at an enterprise level.
Thanks in advance for your help.