Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm a developer who inherited a Win2k3 box in a small shop with a database server (SQL Server). What kinds of things do I need to know to monitor the server and see what processes cause the most problems/use the most system resources?

Is there a handy utility that will help?

share|improve this question
up vote 1 down vote accepted

Sql Heartbeat from will give you a realtime view of whats going on all the time (including the running query). Its a free app but they also have a full solution to monitor everything (deadlocks/long running queries/etc.). Using the Sql Hearbeat is probably a good start. You'll want to start educating yourself about Sql Server to set up maintenance plans and backups to make sure you are covered.

share|improve this answer

There's a large selection of dynamic management views (DMVs) in SQL Server itself, where you can read in Books Online how to use them.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.