 |
|
|
Item Details
| Title:
|
PROFESSIONAL SQL SERVER 2008 INTERNALS AND TROUBLESHOOTING
|
| By: |
Christian Bolton, Justin Langford, Brent Ozar |
| Format: |
Electronic book text |
| List price:
|
£60.00 |
|
We currently do not stock this item, please contact the publisher directly for
further information.
|
|
|
|
|
|
| ISBN 10: |
0470618906 |
| ISBN 13: |
9780470618905 |
| Publisher: |
JOHN WILEY & SONS INC |
| Pub. date: |
7 January, 2010 |
| Pages: |
624 |
| Synopsis: |
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 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 Analysis Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. |
| Publication: |
US |
| Imprint: |
Wrox Press |
| Returns: |
Non-returnable |
|
|
|
 |
|
|
|
|
|
No Cheese, Please!
A fun picture book for children with food allergies - full of friendship and super-cute characters!Little Mo the mouse is having a birthday party.
|
My Brother Is a Superhero
Luke is massively annoyed about this, but when Zack is kidnapped by his arch-nemesis, Luke and his friends have only five days to find him and save the world...
|
|
|
|
|