Page 169 - DCAP508_DATABASE_ADMINISTRATION

Sartaj Singh, Lovely Professional University
Unit 12: Tools and Techniques for Monitoring Performance

Unit 12: Tools and Techniques for Monitoring Notes
Performance

CONTENTS
Objectives
Introduction
12.1 Benefits of Monitoring SQL Server for Performance

12.2 Monitoring in a Dynamic Environment
12.3 Monitoring with SQL Profiler
12.4 Uses of SQL Profiler
12.5 Starting SQL Profiler
12.5.1 SQL Profiler Terminology
12.5.2 SQL Profiler Scenarios
12.5.3 Monitoring with SQL Profiler Event Categories

12.6 Monitoring with System Monitor
12.7 Monitoring with SQL Server Enterprise Manager
12.8 Monitoring the Error Logs
12.8.1 Comparing Error and Application Log Output
12.8.2 Viewing the SQL Server Error Log: SQL Server 2000
12.8.3 Viewing the Windows Application Log
12.9 Monitoring with Transact – SQL Statements
12.10 Monitoring with SNMP
12.10.1 SNMP Terminology

12.11 Enabling SQL Server Support of SNMP on Windows 98
12.12 Enabling SQL Server MIB
12.13 Copying the MSSQL – MIB to an SNMP Workstation
12.14 Summary
12.15 Keywords
12.16 Review Questions
12.17 Further Readings

Objectives

After studying this unit, you will be able to:
Know about different tools and techniques available for monitoring performance
Learn how to do monitoring with SQL Profiler
Understand concept of monitoring with system monitor

Analyze monitoring with the help of the Error Logs

LOVELY PROFESSIONAL UNIVERSITY 163