| Description |
1 online resource |
|
text file PDF rda |
| Series |
The expert's voice in SQL server |
|
Expert's voice in SQL server.
|
| Note |
Includes index. |
| Summary |
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. |
| 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. |
| Subject |
SQL server.
|
|
SQL server |
|
Client/server computing.
|
|
Database management.
|
|
Architecture client-serveur (Informatique) |
|
Bases de données -- Gestion. |
|
Algorithms & data structures. |
|
Databases. |
|
Client/server computing |
|
Database management |
| Indexed Term |
computerwetenschappen |
|
computer sciences |
|
databasebeheer |
|
database management |
|
Information and Communication Technology (General) |
|
Informatie- en communicatietechnologie (algemeen) |
| In: |
Springer eBooks |
| Other Form: |
Printed edition: 9781430267737 |
| ISBN |
9781430267720 (electronic bk.) |
|
1430267720 (electronic bk.) |
|
1430267739 (print) |
|
9781430267737 (print) |
| Standard No. |
10.1007/978-1-4302-6772-0 doi |
|
More Resources