Healthy SQL : a comprehensive guide to healthy SQL server performance /: a comprehensive guide to healthy SQL server performance. (2015)

• Record Type: Book
• 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; 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.
• 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.