Muutke küpsiste eelistusi

Healthy SQL: A Comprehensive Guide to Healthy SQL Server Performance 1st ed. [Pehme köide]

4.75/5 (5 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 408 pages, kõrgus x laius: 254x178 mm, kaal: 7627 g, 216 Illustrations, black and white; XXV, 408 p. 216 illus., 1 Paperback / softback
  • Ilmumisaeg: 27-May-2015
  • Kirjastus: APress
  • ISBN-10: 1430267739
  • ISBN-13: 9781430267737
Teised raamatud teemal:
  • Pehme köide
  • Hind: 53,33 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 62,74 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Healthy SQL: A Comprehensive Guide to Healthy SQL Server Performance 1st ed.Suurem pilt
  • Formaat: Paperback / softback, 408 pages, kõrgus x laius: 254x178 mm, kaal: 7627 g, 216 Illustrations, black and white; XXV, 408 p. 216 illus., 1 Paperback / softback
  • Ilmumisaeg: 27-May-2015
  • Kirjastus: APress
  • ISBN-10: 1430267739
  • ISBN-13: 9781430267737
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781430267737.html
Märksõnad:
"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 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 Servermachines 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.

Arvustused

The books intended audience includes both junior and seasoned SQL Server DBAs: they will appreciate it for the hands-on approach as well as for the valuable scripts and tools they will easily incorporate in their toolboxes. (Alberto Bolchini, Computing Reviews, computingreviews.com, May, 2016)

About the Author xvii
About the Technical Reviewer xix
Acknowledgments xxi
Foreword xxv
Chapter 1 Introduction to Healthy SQL 1(18)
Enter the DBA
1(3)
Who Cares?
2(1)
SQL Fitness
3(1)
What You Will Learn?
3(1)
What Is Healthy SQL?
4(3)
What Is a Health Check?
5(1)
Recent Infamy
6(1)
Why Perform a Health Check?
7(10)
Performance
8(1)
Security
9(3)
Stability
12(2)
Audits
14(1)
Migration
15(1)
Upgrade
15(1)
Backups
15(1)
Business Continuity
16(1)
When to Perform a Health Check
17(2)
Chapter 2 Creating a Road Map 19(24)
Statistics and Performance
19(3)
Understanding the Terms
19(1)
Applying Real-World Principles of Statistics to Performance
20(2)
Inventories
22(6)
The Checklist
28(6)
What to Collect
29(1)
CPU, Memory, I/O, Locking, and Blocking
30(1)
Collecting Information from the System Catalog
31(3)
Virtually Speaking...
34(2)
Memory Ballooning
35(1)
Over-allocation of Memory/CPU
36(1)
Best Practices: Says Who?
36(4)
Some Not-So Best Practices
37(1)
It Depends
38(1)
Run Book
39(1)
Road Map Essentials
40(1)
Rob's Bonus Best Practice Considerations
41(2)
Chapter 3 Waits and Queues 43(38)
Introducing Waits and Queues
43(2)
S-l-o-w Performance
45(2)
Blame Game: Blame SQL Server
47(1)
Back to Waiting
47(8)
Wait Type Categories
48(1)
Is Waiting a Problem?
49(1)
Observing Wait Statistics
50(5)
The Execution Model
55(3)
CPU Pressure
58(7)
Runnable Task Count
58(1)
Signal Waits
59(1)
Anatomy of a CPU Metadata Query
59(5)
CPU Blame Game
64(1)
I/O May Be Why Your Server Is So Slow
65(15)
I/O Blame Game
65(1)
Fragmentation Affects I/O
66(1)
I/O Latch Buffer Issues
67(5)
Related Performance Monitor Counters
72(2)
Memory Pressure
74(4)
Parallelism and CXPACKET
78(1)
Blocking and Locking, Oh My!
79(1)
Summary
80(1)
Chapter 4 Much Ado About Indexes 81(34)
Indexes 101
82(14)
What Are Indexes?
82(1)
Index Types and Terminology
83(2)
Index Advantages vs. Disadvantages
85(1)
B-Tree Index Structure
86(2)
Index-Related Dynamic Management Views and Functions
88(2)
Where to Place Indexes
90(1)
Fill Factor and Page Splitting
91(5)
Common Index Issues
96(14)
Index Usage
96(2)
Index Fragmentation
98(3)
Index Reorganization
101(1)
Missing Indexes
102(5)
Duplicate Indexes
107(3)
Database Engine Tuning Advisor
110(4)
Summary
114(1)
Chapter 5 Tools of the Trade: Basic Training 115(34)
Build a Better Mousetrap
115(1)
Monday Morning Mania (Busiest DBA Day)
116(5)
Activity Monitor
117(3)
sp_whoisactive
120(1)
SSMS Standard Reports
121(2)
Server-Level Reports
121(1)
Database Reports
122(1)
SQL Server 2012 Performance Dashboard
123(3)
The Power of Dynamic Management Views and Function Categories
126(5)
sys.dm_os_performance_counters (How to Read and Calculate Them)
127(2)
Diagnostic DMOs
129(2)
Bonus: sys.dm_exec_query_profiles DMO (SQL Server 2014 Only)
131(1)
SQL Profiler/Trace
131(3)
Default Trace
132(1)
Ensure Default Trace Is On
132(2)
Performance Monitor
134(1)
Data Collector
135(10)
Management Data Warehouse: SQL Server 2008 and Higher
145(2)
Basic Training Completed
147(2)
Chapter 6 Expanding Your Tool Set 149(38)
New Tools
149(24)
Extended Events
149(1)
The New Session Wizard
150(10)
The system_health Session
160(2)
The sp_server_diagnostics Procedure
162(1)
XQuery
163(4)
SQL Server 2012 System Health Reporting Dashboard
167(6)
Other Free and Downloadable Tools
173(12)
PowerShell
173(1)
SQLPowerDoc
174(1)
Performance Analysis of Logs
174(9)
SQL Server Best Practice Analyzer (Through 2012)
183(2)
Closing the Tool Shed
185(2)
Chapter 7 Creating a SQL Health Repository 187(44)
Laying the Repository Groundwork
187(1)
Deploying the Management Data Warehouse
188(6)
Configuring the Data Collection
194(3)
Post-Configuration Tasks
197(11)
Accounts, Privileges, Rights, and Credentials
208(7)
Configuring Account Privileges for MDW Server
209(1)
Configuring Account Privileges for the MDW Client
210(5)
MDW Caveats
215(1)
Defining a Custom Data Collection
215(8)
Rolling Your Own
223(6)
Summary
229(2)
Chapter 8 Monitoring and Reporting 231(48)
SQL Server Agent Alerts, Operators, and Notifications
232(14)
Configure Database Mail
232(6)
Configuring SQL Server Agent Alerts
238(8)
Monitoring with Extended Events
246(12)
Deadlocks
248(7)
Blocking and Locking
255(2)
Monitoring Errors with Extended Events
257(1)
Monitoring Software
258(3)
Build vs. Buy
259(1)
Features, Polling, Agents, Push vs. Pull
260(1)
Licensing and Pricing
261(1)
Evaluating Monitoring Software
261(1)
Reporting on Server Health
261(16)
MDW Reports
262(2)
Building the Custom SSRS Report
264(1)
Create the Report Framework
265(12)
Summary
277(2)
Chapter 9 High Availability and Disaster Recovery 279(44)
Evolution of Disaster Recovery and SQL Server
279(11)
Business Continuity
281(3)
Concepts of High Availability and Disaster Recovery
284(1)
Database Backups and Recovery Models
285(2)
Challenges of High Availability
287(2)
SQL DR Drawbacks
289(1)
Backup and Recovery
290(7)
First Line of Defense
291(1)
Point-in-Time Restore
291(4)
Database Corruption: Detection, Recovery, and Repair
295(2)
Log Shipping
297(5)
About Log Shipping
297(1)
Deploy Log Shipping
298(4)
Mirroring
302(6)
About Database Mirroring
302(1)
Configuring Database Mirroring
303(5)
Clustering
308(4)
About Clustering
309(2)
Multisubnet Clusters
311(1)
Availability Groups (2012)
312(7)
Enabling and Setting Up the AG Feature
312(6)
Read-Only Replicas
318(1)
Virtualization
319(1)
Peer-to- Peer Replication
319(2)
DR Run Book
321(1)
Summary
322(1)
Chapter 10 Surviving the Audit 323(46)
Overview
323(1)
Database Forensics
324(1)
Benefits of Database Forensics
325(1)
Regulatory Compliance
325(1)
Industry Rules and Regulation
326(1)
Database Access Control and Compliance
326(6)
Control Access to the Database Environment
326(1)
Segregation of Duties
327(1)
Monitoring
327(1)
Backup/Recovery
327(1)
SQL Code
328(1)
Change Control
328(1)
Login and Password Policy Enforcement
328(3)
The Tale of the DBA and the Developer
331(1)
Transaction Log
332(5)
Reading the Transaction Log
333(4)
C2 Auditing and Common Criteria Compliance
337(1)
SQL Audit
338(8)
Creating an Audit in SQL Server Management Studio
339(3)
Server Audit Specification
342(2)
Database Audit Specification
344(1)
Generating Audit Activity
344(1)
Viewing the Audit Log
345(1)
DDL Triggers
346(2)
Default Trace
348(8)
Reviewing the Default Trace Output
348(2)
Using the Default Trace to Capture SQL Server Configuration Changes
350(1)
Creating the History Tracking Table
351(1)
Methodology
352(1)
Creating the Stored Procedure
353(2)
Testing the Process
355(1)
Change Data Capture
356(5)
Policy-Based Management
361(7)
Creating a Implementing a SQL Password Enforcement Policy
363(3)
Testing the Policies
366(1)
Applying Policies
367(1)
Summary
368(1)
Index 369
Robert Pearl, president and founder of Pearl Knowledge Solutions, Inc., has been a Microsoft SQL Server MVP since 2009, having received his fifth MVP recognition award. He is a solutions-oriented senior DBA with 15+ years of experience, and is considered a subject-matter expert on SQL Server technology. He also coined the terms Healthy SQL and SQL Fitness to kick off the worldwide healthy SQL campaign to highlight the need for regular health checks to ensure that everyones SQL Server environment has achieved a healthy state. He is a SQL Community and SQL Saturday evangelist, promoter, and speaker, and maintains his regular blog called Pearl Knows at SQLServerCentral.com. Pearl was voted Top Blogger in the 2011 SQL Mag Community Choice Awards. He is also the creator/developer of the award-winning product SQL Centrica web-based database monitoring and alert system for DBAs. Robert is a SQL Saturday organizer and co-chair of the successful New York Metro PASS SQL Saturdays.