Managing Server Activity

As a database administrator, it is your job to make sure that SQL Server runs smoothly. To ensure that SQL Server is running optimally, you can actively monitor the server to

  • Keep track of user connections and locks

  • View processes and commands that active users are running

  • Check the status of locks on processes and objects

  • See blocked or blocking transactions

  • Ensure that processes complete successfully, and detect errors if they do not

When problems arise, you can terminate a process, if necessary.

Note

For more coverage of monitoring SQL Server, see Chapter 14. In that chapter, you will learn how to use Performance Monitor and SQL Server Profiler to keep track of SQL Server activity, performance, and errors.

Examining Process ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.