SQL performance template needs to monitor multiple databases - not just 'master' - can this be done by SAM?

Where can I find a template, or else can this existing template be modified (SQL Server Performance 2005-2008) where all databases on a SQL server get monitored by these components rather than just one single database, like 'master'?

We have SQL servers with many databases, for instance, where there's 50 databases, I don't want to build 50 separate templates for one SQL server.

Thanks!

SQL Performance.jpg

Find more posts tagged with

template

sam

sql

performance_monitoring

Accepted answers

All comments

lukas.belza

Hello,

The "SQL Server 2005-2008 Performance (SQL)" template provides global statistics for whole instance of SQL server, not just one database. These statistics are available through Dynamic Management Views of "master" database (SQL Server Operating System Related Dynamic Management Views (Transact-SQL)).

Lukas Belza (SolarWinds development)

aLTeReGo

is correct, though some metrics such as most fragmented table are database specific. You might want to checkout our new AppInsight for SQL in the SAM 6.0 beta. It provides full monitoring of all databases running on the SQL instance and a whole lot more. You can sign-up here to download the SAM 6.0 beta and try it out for yourself.