 |
|
|
Item Details
| Title:
|
PROFESSIONAL SQL SERVER 2010 INTERNALS AND TROUBLESHOOTING
|
| By: |
Christian Bolton, Justin Langford, Brent Ozar |
| Format: |
Paperback |
| List price:
|
£47.50 |
|
We currently do not stock this item, please contact the publisher directly for
further information.
|
|
|
|
|
|
| ISBN 10: |
0470484284 |
| ISBN 13: |
9780470484289 |
| Publisher: |
JOHN WILEY & SONS INC |
| Pub. date: |
29 December, 2009 |
| Pages: |
624 |
| Description: |
A hands-on resource for SQL Server 2008 troubleshooting methods and toolsSQL Server administrators need to ensure that SQL Server remains running 24/7. |
| Synopsis: |
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 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 AnalysisNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. |
| Illustrations: |
Illustrations |
| Publication: |
US |
| Imprint: |
Wrox Press |
| Returns: |
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...
|
|
|
|
|