Chapter 10. SQL Server System and Database Administration

by Paul Jensen


  • Responsibilities of the System Administrator

  • System Databases

  • System Tables

  • System-Stored Procedures

  • Useful System Procedures

  • Other Methods of Querying the System Tables

This chapter outlines the role of the SQL Server system administrator, and also examines the system databases and tables and the methods the administrator can use to query system data. An understanding of these key structures is essential in administering a SQL Server database. Just like the mechanic who fixes your car, the administrator must know where to look when problems occur.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features