Chapter 14 -- Monitoring SQL Server Performance and Activity

3 4

Chapter 14

About This Chapter

This chapter prepares you to monitor SQL Server 2000 performance and activity. You will learn about developing a performance monitoring methodology for SQL Server. You will learn about each of the Microsoft tools that are available for monitoring SQL Server 2000, including when the use of each tool is most appropriate. Finally, you will learn how to perform specific monitoring tasks using the most commonly used monitoring tools.

Before You Begin

To complete this chapter, you must have

• A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1, "Hardware Requirements," in Lesson 1 of Chapter 2.
• Microsoft Windows 2000 Server running on your computer on an NTFS partition.
• A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain .
• Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).
• Created the SSEMDB database using the CreateDB.sql script (see Chapter 6).
• Created the Customer table in the SSEMDB database using the SSEMDB_Full.sql script (see Chapter 9).