O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Note

For more coverage of monitoring SQL Server, see Chapter 13. In that chapter, you will learn how to use Performance Monitor ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required