What is the best way to monitor a database?

4	I'd like to monitor a MS SQL Server database. What's the best way to accomplish that? server-monitor database-monitoring asked 06 Jul '12, 15:57 Doug ♦♦ 10.2k●12●21●38 accept rate: 21%

One Answer:

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

There are three approaches that work:

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.
The Execute Script monitor can periodically connect to a database and check something. The linked page has an example of how to do that.
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 ♦♦
10.2k●12●21●38
accept rate: 21%

Your answer

toggle preview

community wiki

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:

Asked: 06 Jul '12, 15:57

Seen: 21,391 times

Last updated: 29 Jul '16, 16:09