What is the best way to monitor a database?

Doug 1126
Viewed 0

I'd like to monitor a MS SQL Server database. What's the best way to accomplish that?

database-monitoring server-monitor
1 Answers

Update: The best answer is to use the new Database Monitor (for MS SQL Server)

See Database Monitor information

There are three approaches that work:

  1. For databases installed on Windows, most (all?) of them will publish performance counters. So the Performance Monitor could watch the counters. Here's an example counter list from an MSDN blog.

  2. The Execute Script monitor can periodically connect to a database and check something. The linked page has an example of how to do that.

  3. Create a web page that connects to the database and then returns something like "OK" or "Problem". The Web Page monitor could then check that page.

Doug1126
Related