Profile

e-Catalog

Contact

Search

Cart

Microsoft SQL Server 7.0: Monitoring and Optimizing

Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To enable students to monitor, maintain, tune, and troubleshoot SQL Server 7.0

Learning Objectives

Describe SQL Server 7.0?s monitoring and tuning tools. Discuss the principal factors that affect the performance of SQL Server 7.0 running on Windows NT. Show how to use Performance Monitor and SQL Server Profiler to monitor SQL Server 7.0 performance. Point out how to manage SQL Server user accounts and audit permissions. Distinguish between using log files, T-SQL stored procedures, DBCC commands, and the Current Activity window to gather data and monitor performance. Describe how to analyze queries using Query Analyzer and the SHOWPLAN options. Show how to use the Index Tuning Wizard to tune SQL Server 7.0 queries and indexes. Summarize how to use the sp_configure stored procedure to optimize SQL Server 7.0 performance. Describe how to use the Database Maintenance Plan Wizard to establish and implement a regular maintenance plan. Detail how to diagnose and resolve problems with client connectivity, server tools, and general server performance.

Topics Covered

Monitoring performance - Getting started - Performance Monitor - Monitoring SQL Server performance - Bottlenecks SQL Server Profiler - Working with Profiler - Using traces with Profiler - Hands-on: Using SQL Server Profiler Other maintenance tools - Log files and security audits - Enterprise Manager and T-SQL tools - Hands-on: Auditing permissions Analyzing and tuning performance - Analyzing and tuning queries - Using the Index Tuning Wizard - Hands-on: Tuning indexes - Optimizing SQL Server performance Maintenance and troubleshooting - System maintenance - Hands-on: Creating a database maintenance plan - Troubleshooting performance