{"product_id":"9780470633885","title":"Professional SQL Server 2008 Internals and Troubleshooting","description":"\u003cb\u003eA hands-on resource for SQL Server 2008 troubleshooting methods and tools\u003c\/b\u003e \u003cp\u003eSQL 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.\u003c\/p\u003e \u003cp\u003eYou'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.\u003c\/p\u003e \u003cp\u003eTopics Covered:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eSQL Server Architecture\u003c\/li\u003e \u003cli\u003eUnderstanding Memory\u003c\/li\u003e \u003cli\u003eSQL Server Waits and Extended Events\u003c\/li\u003e \u003cli\u003eWorking with Storage\u003c\/li\u003e \u003cli\u003eCPU and Query Processing\u003c\/li\u003e \u003cli\u003eLocking and Latches\u003c\/li\u003e \u003cli\u003eKnowing Tempdb\u003c\/li\u003e \u003cli\u003eDefining Your Approach To Troubleshooting\u003c\/li\u003e \u003cli\u003eViewing Server Performance with PerfMon and the PAL Tool\u003c\/li\u003e \u003cli\u003eTracing SQL Server with SQL Trace and Profiler\u003c\/li\u003e \u003cli\u003eConsolidating Data Collection with SQLDiag and the PerfStats Script\u003c\/li\u003e \u003cli\u003eIntroducing RML Utilities for Stress Testing and Trace File Analysis\u003c\/li\u003e \u003cli\u003eBringing It All Together with SQL Nexus\u003c\/li\u003e \u003cli\u003eUsing Management Studio Reports and the Performance Dashboard\u003c\/li\u003e \u003cli\u003eUsing SQL Server Management Data Warehouse\u003c\/li\u003e \u003cli\u003eShortcuts to Efficient Data Collection and Quick Analysis\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47105814167792,"sku":"9780470633885","price":34.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780470633885_p0.jpg?v=1763706625","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780470633885","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}