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

asked 06 Jul '12, 15:57

Doug's gravatar image

Doug ♦♦
10.1k112037
accept rate: 21%


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.

link

answered 06 Jul '12, 16:03

Doug's gravatar image

Doug ♦♦
10.1k112037
accept rate: 21%

edited 29 Jul '16, 16:09

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×74
×1

Asked: 06 Jul '12, 15:57

Seen: 3,582 times

Last updated: 29 Jul '16, 16:09