Healthy SQL a comprehensive guide to healthy SQL server performance

Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you....

Full description

Bibliographic Details
Main Author: Pearl, Robert
Format: eBook
Language:English
Published: [California] Apress 2015
Series:The expert's voice in SQL server
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 06271nmm a2200661 u 4500
001 EB001923963
003 EBX01000000000000001086865
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781430267720 
020 |a 1430267720 
020 |a 1430267739 
050 4 |a QA76.9.C55 
100 1 |a Pearl, Robert 
245 0 0 |a Healthy SQL  |b a comprehensive guide to healthy SQL server performance  |c Robert Pearl 
260 |a [California]  |b Apress  |c 2015 
300 |a 1 online resource 
505 0 |a 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) 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
653 |a Architecture client-serveur (Informatique) 
653 |a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502 
653 |a SQL server / http://id.loc.gov/authorities/names/n90684343 
653 |a computerwetenschappen 
653 |a COMPUTERS / Programming Languages / SQL. / bisacsh 
653 |a Client/server computing / fast 
653 |a COMPUTERS / Client-Server Computing / bisacsh 
653 |a Information and Communication Technology (General) 
653 |a Bases de données / Gestion 
653 |a Database management / fast 
653 |a Algorithms & data structures / bicssc 
653 |a Database management / http://id.loc.gov/authorities/subjects/sh85035848 
653 |a Informatie- en communicatietechnologie (algemeen) 
653 |a Databases / bicssc 
653 |a databasebeheer 
653 |a computer sciences 
653 |a database management 
653 |a SQL server / fast 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a The expert's voice in SQL server 
500 |a Includes index 
028 5 0 |a 10.1007/978-1-4302-6772-0 
773 0 |t Springer eBooks 
776 |z 9781430267737 
776 |z 1430267720 
776 |z 1430267739 
776 |z 9781430267720 
776 |z 9781430267737 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781430267720/?ar  |x Verlag  |3 Volltext 
082 0 |a 384 
082 0 |a 658 
082 0 |a 500 
082 0 |a 005.7585 
520 |a Healthy SQL is about ensuring the ongoing performance health of a SQL Server database. An unhealthy database is not just an inconvenience; it can bring a business to its knees. And if you are the database administrator, the health of your SQL Server implementation can be a direct reflection on you. It's in everyone's best interest to have a healthy SQL implementation. Healthy SQL is built around the concept of a medical checkup, giving you the tools you need to assess the current health of your database and take action to improve upon that health and maintain good performance to your business. Healthy SQL aids in developing a rigorous routine so that you know how healthy your SQL Server machines are, and how you can keep those same servers healthy and fit for duty. The book is filled with practical advice and a time-tested strategy, helping you put together a regimen that will ensure your servers are healthy, your implementation is fully optimized, your services are redundant and highly available, and you have a plan for business continuity in the event of a disaster. If your current environment doesn't match up with these criteria, then pick up a copy of Healthy SQL today and start your journey on the road to a fit and tight SQL Server deployment