Healthy SQL : a comprehensive guide to healthy SQL server performance /: a comprehensive guide to healthy SQL server performance. (2015)
- Record Type:
- Book
- Title:
- Healthy SQL : a comprehensive guide to healthy SQL server performance /: a comprehensive guide to healthy SQL server performance. (2015)
- Main Title:
- Healthy SQL : a comprehensive guide to healthy SQL server performance
- Further Information:
- Note: Robert Pearl.
- Authors:
- Pearl, Robert
- 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. Collecting Information from the System CatalogVirtually Speaking ... ; Memory Ballooning; Over-allocation of Memory/CPU; Best Practices: Says Who?; Some Not-So Best Practices; It Depends; Run Book; Road Map Essentials; Rob's Bonus Best Practice Considerations; Chapter 3: Waits and Queues; Introducing Waits and Queues; S-l-o-w Performance; Blame Game: Blame SQL Server; Back to Waiting; Wait Type Categories; Is Waiting a Problem?; Observing Wait Statistics; The Execution Model; CPU Pressure; Runnable Task Count; Signal Waits; Anatomy of a CPU Metadata Query; CPU Blame Game. 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; IndexesAt 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. Collecting Information from the System CatalogVirtually Speaking ... ; Memory Ballooning; Over-allocation of Memory/CPU; Best Practices: Says Who?; Some Not-So Best Practices; It Depends; Run Book; Road Map Essentials; Rob's Bonus Best Practice Considerations; Chapter 3: Waits and Queues; Introducing Waits and Queues; S-l-o-w Performance; Blame Game: Blame SQL Server; Back to Waiting; Wait Type Categories; Is Waiting a Problem?; Observing Wait Statistics; The Execution Model; CPU Pressure; Runnable Task Count; Signal Waits; Anatomy of a CPU Metadata Query; CPU Blame Game. 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. … (more)
- Publisher Details:
- California : Apress
- Publication Date:
- 2015
- Copyright Date:
- 2015
- Extent:
- 1 online resource
- Subjects:
- 005.7585
Computer science
Client/server computing
Database management
COMPUTERS -- Client-Server Computing
COMPUTERS -- Programming Languages -- SQL
Client/server computing
Database management
Computers -- Information Theory
Algorithms & data structures
Data structures (Computer science)
Computers -- Database Management -- General
Databases
Electronic books - Languages:
- English
- ISBNs:
- 9781430267720
1430267720
1430267739
9781430267737 - Related ISBNs:
- 9781430267737
- Notes:
- Note: Vendor-supplied metadata.
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.359336
- Ingest File:
- 01_321.xml