Polling sql server for database names and sizes

Question

Hi

Has anyone configured NPM (or if not APM) for polling a sql server and retrieving a list of database names and database sizes as a universal poller or any other way?

Thanks

Richard

sirpaw · Answer

Hi,

I know that there are existing templates for MS SQL Server 2005/2008 in SAM, and there are counters there that can somehow show the databases on the server; like the Transactions per Sec counter, which will show you the transaction rate on the server's databases. I'm not sure however what counter can show you the tables on a certain database. Also,you can do a little ASP coding on an NPM Custom HTML Resource to query a database and return a stored procedure like sp_databases for example, that will enumerate to you the databases on your target SQL Server.

Regards,

Paulo

rjones-uk · Answer

Thanks, I have SAM too, is there a template for this in SAM?

sirpaw · Answer

Hi,

I believe this is not possible through UnDP. You'll need Orion SAM for this.

Regards,

Paulo