MSSQL Monitoring

Started by lindeamon, February 20, 2013, 03:54:55 PM

Previous topic - Next topic

lindeamon

hi,

what is the best way to monitor MSSQL ?
for starters i want to know if a database is mounted. i had times that the disk containing the db files was lost and the sql server was up but there was no db.
would wmi be the best solution or perfmon counters ?

10x,
Lindeamon

Victor Kirhenshtein

Hi!

Performance counters probably will be easier to configure.

Best regards,
Victor