The History of SQL Server and relational databases
Key performance ratios can quickly help a SQL Server DBA understand how well their overall system is performing. This chapter provides details on what ratios a DBA needs to monitor, along with recommendations for what to do when key performance metrics are out of line.
IX. PLM Steps 3 and 4 - Using History to Prepare for the Future Many SQL Server DBAs work in a reactive mode, which means they do little to plan for the future needs of the databases they oversee. This chapter discusses the importance of historical trend analysis, what key metrics should be tracked, and how to use historical data to forecast future needs. Performance Tuning for the SQL Server DBA
- Relational database history
- The evolution of SQL Server
- SQL Server and ANSI standards
- Pre-installation steps
- Installing SQL Server
- Configuring the run-time SQL Server system
- Patching SQL Server - Service packs
- SQL Server file management architecture
- Creating database files
- Creating SQL Server log files
- Using SQL Server file groups
- Using DTS to export and import SQL Server table data
- Windows security management for the server
- Windows authentication mode
- SQL Server rights and role management
- Overview of SQL Server backup & recovery
- Incremental backups
- Restoring a SQL Server database
- Standby database overview
- Shipping SQL Server log files to standby databases
- Microsoft replication architectures
- Creating a replication topology
- Configuring SQL Server replication
- Common database scheduled jobs
- Configuring SQLMail
- Setting SQL Server and server alert thresholds
- Creating customized error conditions
- Scheduling multi-step job streams
Key performance ratios can quickly help a SQL Server DBA understand how well their overall system is performing. This chapter provides details on what ratios a DBA needs to monitor, along with recommendations for what to do when key performance metrics are out of line.
IX. PLM Steps 3 and 4 - Using History to Prepare for the Future Many SQL Server DBAs work in a reactive mode, which means they do little to plan for the future needs of the databases they oversee. This chapter discusses the importance of historical trend analysis, what key metrics should be tracked, and how to use historical data to forecast future needs. Performance Tuning for the SQL Server DBA
- SQL Server monitoring for performance
- SQL Server startup parameter tuning
- T-SQL tuning
- SQL tuning for SQL Server
- Diagnosing storage and system problems
- Diagnosing session and O/S issues
No comments:
Post a Comment