I have a client with MS SQL Server instances (2000, 2005) scattered across 20-30 servers. I've been engaged to get things organized and will be periodically reviewing the state of the database infrastructure for health, testing backups, etc. We also plan to get as many of these databases up to 2008 as possible.
I'm aware of services like New Relic for Linux stack web apps and databases, and I stumbled onto the SQL Monitor product (RedGate) just today via Google. Can anyone provide some direction in terms of services or tools (that you have experience with) that would enable me/my client to monitor and manage their MS SQL instances?