- Retrait gratuit dans votre magasin Club
- 7.000.000 titres dans notre catalogue
- Payer en toute sécurité
- Toujours un magasin près de chez vous
- Retrait gratuit dans votre magasin Club
- 7.000.000 titres dans notre catalogue
- Payer en toute sécurité
- Toujours un magasin près de chez vous
Professional SQL Server 2008 Internals and Troubleshooting
Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort
Livre broché | Anglais
70,45 €
+ 140 points
Description
A hands-on resource for SQL Server 2008 troubleshooting methods and tools
SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.
You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.
Topics Covered:
- SQL Server Architecture
- Understanding Memory
- SQL Server Waits and Extended Events
- Working with Storage
- CPU and Query Processing
- Locking and Latches
- Knowing Tempdb
- Defining Your Approach To Troubleshooting
- Viewing Server Performance with PerfMon and the PAL Tool
- Tracing SQL Server with SQL Trace and Profiler
- Consolidating Data Collection with SQLDiag and the PerfStats Script
- Introducing RML Utilities for Stress Testing and Trace File Analysis
- Bringing It All Together with SQL Nexus
- Using Management Studio Reports and the Performance Dashboard
- Using SQL Server Management Data Warehouse
- Shortcuts to Efficient Data Collection and Quick Analysis
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Spécifications
Parties prenantes
- Auteur(s) :
- Editeur:
Contenu
- Nombre de pages :
- 581
- Langue:
- Anglais
Caractéristiques
- EAN:
- 9780470484289
- Date de parution :
- 01-01-10
- Format:
- Livre broché
- Format numérique:
- Trade paperback (VS)
- Dimensions :
- 188 mm x 234 mm
- Poids :
- 1029 g
