Healthy SQL A Comprehensive Guide to Healthy SQL Server Performance
"Robert Pearl, a well-known DBA in the SQL community, explains his holistic vision of a database instance that needs regular check-ups and gives the tools, scripts, and best practices he has collected over the years." Alberto Bolchini, Computing Reviews, May 9, 2016 Healthy SQL is about en...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2015.
|
| Edición: | 1st ed. 2015. |
| Colección: | The expert's voice in SQL server
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629793006719 |
Tabla de Contenidos:
- Contents at a Glance; Chapter 1: Introduction to Healthy SQL; Enter the DBA; Who Cares?; SQL Fitness; What You Will Learn?; What Is Healthy SQL ?; What Is a Health Check?; Recent Infamy; Why Perform a Health Check?; Performance; Security; Stability; Audits; Migration; Upgrade; Backups; Business Continuity; When to Perform a Health Check; Chapter 2: Creating a Road Map; Statistics and Performance; Understanding the Terms; Applying Real-World Principles of Statistics to Performance; Inventories; The Checklist; What to Collect; CPU, Memory, I/O, Locking, and Blocking
- I/O May Be Why Your Server Is So SlowI/O Blame Game; Fragmentation Affects I/O; I/O Latch Buffer Issues; Related Performance Monitor Counters; Memory Pressure; Parallelism and CXPACKET; Blocking and Locking, Oh My!; Find All Locks Being Held by a Running Batch Process; Find All Currently Blocked Requests; Summary; Chapter 4: Much Ado About Indexes; Indexes 101; What Are Indexes?; Index Types and Terminology; Index Advantages vs. Disadvantages; Advantages; Disadvantages; B-Tree Index Structure; Index-Related Dynamic Management Views and Functions; Where to Place Indexes
- Fill Factor and Page SplittingFill Factor; Page Split Tracking; Common Index Issues; Index Usage; Index Fragmentation; Index Reorganization; Missing Indexes; Duplicate Indexes; Database Engine Tuning Advisor; Summary; Chapter 5: Tools of the Trade: Basic Training; Build a Better Mousetrap; Monday Morning Mania (Busiest DBA Day); Activity Monitor; sp_whoisactive; SSMS Standard Reports; Server-Level Reports; Database Reports; SQL Server 2012 Performance Dashboard; The Power of Dynamic Management Views and Function Categories; sys.dm_os_performance_counters (How to Read and Calculate Them)
- Diagnostic DMOsBonus: sys.dm_exec_query_profiles DMO (SQL Server 2014 Only); SQL Profiler/Trace; Default Trace; Ensure Default Trace Is On; Performance Monitor; Data Collector; Management Data Warehouse: SQL Server 2008 and Higher; Basic Training Completed; Chapter 6: Expanding Your Tool Set; New Tools; Extended Events; The New Session Wizard; The system_health Session; The sp_server_diagnostics Procedure; XQuery; SQL Server 2012 System Health Reporting Dashboard; Other Free and Downloadable Tools; PowerShell; SQLPowerDoc; Performance Analysis of Logs
- SQL Server Best Practice Analyzer (Through 2012)
