Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

up vote 1 down vote accepted

Sql Heartbeat from sqlsolutions.com 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

 
discard

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.