SQL Server 2000

Performance Tuning

Seminar-Konfigurator

Detaillierte Beschreibung

Inhalte

• Tag 1:
• Performance Tuning, Capacity Planning, and Sizing Overview
• SQL Server 2000 Architecture Fundamentals
• Dynamic and Manual Memory Configuration
• Data Storage
• Filegroups and File Placement
• Pages, Extents, and Rows
• Lock Management
• Thread Management
• Fiber Mode Scheduling and Worker Threads
• Understanding the I/O Subsystem and RAID
• I/O Latencies and SQL Server
• Guidelines for Configuring I/O Subsystems
• Configuring and Tuning the System
• Tuning the Disk Subsystem
• Tuning Memory
• Optimizing Database Layout
• SQL Server Configuration Options
• Extended Memory Support
• Named Instances of SQL Server
• Federated Servers with Distributed Partitioned Views
• Administration Enhancements
• Log Shipping
• SQL Profiler
• Tag 2:
• Monitoring Performance with System Monitor
• Using SQL Profiler
• Setting Trace Options
• Running Traces
• Debugging SQL Statements
• Capture and Replay
• Tuning SQL Statements
• Tuning SQL Statements and Stored Procedures
• Using and Tuning Indexes
• Using Hints in SQL Server
• Modeling for Sizing and Capacity Planning
• Sizing the Database and Application Servers
• Methods for Sizing a System
• Capacity Planning
• Data Warehouses
• Tuning Replicated Systems
• High-Performance Backup and Recovery

Ihre Wunschthemen