Microsoft SQL Server 7.0: Monitoring and Optimizing

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

Target Audience
IT professionals including database administrators, application developers, independent software vendors, 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

Expected Duration
5:00 Hours

Objectives:

Microsoft SQL Server 7.0: Monitoring and Optimizing

  • To monitor and analyze server performance and set alerts using Performance Monitor
  • To explain how to monitor SQL Server 7.0 using SQL Server Profiler
  • To describe some additional monitoring and maintenance tools that can be used with SQL Server 7.0
  • To analyze and improve the performance of queries and indexes.
  • To discuss system maintenance and troubleshooting problems with system performance


    • Course Number: SQ7029E