EBOOK Professional SQL Server 2008 Internals and Troubleshooting - Cindy Gross

EBOOK Professional SQL Server 2008 Internals and Troubleshooting
4.00 Oceń książkę!

Autor: Cindy Gross

 Wydawnictwo: Wrox Press
ISBN: 9780470633885
EAN: C46D9DDBEB
Format: 0,0 x 0,0 x 0,0
Oprawa: ...
Stron: 624
Data wydania: 2010
Gdzie kupić tanią książkę?
Selkar
książka
275.26zł
Kup książkę
Książka w Twoim domu w ciągu 48h

A hands-on resource for SQL Server 2008 troubleshooting methods and toolsSQL 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 ArchitectureUnderstanding MemorySQL Server Waits and Extended EventsWorking with StorageCPU and Query ProcessingLocking and LatchesKnowing TempdbDefining Your Approach To TroubleshootingViewing Server Performance with PerfMon and the PAL ToolTracing SQL Server with SQL Trace and ProfilerConsolidating Data Collection with SQLDiag and the PerfStats ScriptIntroducing RML Utilities for Stress Testing and Trace File AnalysisBringing It All Together with SQL NexusUsing Management Studio Reports and the Performance DashboardUsing SQL Server Management Data WarehouseShortcuts to Efficient Data Collection and Quick AnalysisNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Książka "EBOOK Professional SQL Server 2008 Internals and Troubleshooting"
Cindy Gross