Home  |  My Account  |  Shopping Cart (0 items)   
   
Login/Signup  |  Help  |  Contact Us  
Search for Books:       Advanced Search
Advance Search Cancel
Title : Author :
From Date To Date
Publisher : ISBN Number :
Category : Price : From To

Professional SQL Server 2008 Internals and Troubleshooting-Brent Ozar, Christian Bolton, James Rowland Jones, Justin Langford
Professional SQL Server 2008 Internals and Troubleshooting  Review
by Brent Ozar, Christian Bolton, James Rowland Jones, Justin Langford (Author)
Customer Reviews (0) | Write a Review
Publisher : Wrox
Publish date : 25-Feb-2010
Category : SQL Server
Mediatype : Books
Binding : Paperback
Availability : InStock, Order now ships within 2-3 business days
List Price :   Rs. 549
15%   
off    
Greenleaf Price :  Rs. 467
You Save :  Rs. 82
ISBN : 9780470484289 / Indian ISBN 13: 9788126525508
Pages : 620
Book Summary : Professional SQL Server 2008 Internals and Troubleshooting
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.

From the Back Cover
An in-depth look at SQL Server and best practices for troubleshooting

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together—and simplifies—practical internal information concerning SQL Server along with troubleshooting techniques and methodologies. Packed with real-world examples of ways to effectively use troubleshooting tools, this book shows you how to efficiently and accurately determine the root of your SQL Server problem so you can successfully resolve it.

  • Escorts you through the lifecycle of a query to establish an understanding of the fundamental concepts and architectures
  • Examines the use of memory including the physical components, Windows memory management, and SQL Server's own memory architecture
  • Reviews SQL Server wait types and how to monitor them with Extended Events
  • Equips you with the knowledge to confidently specify and monitor your storage performance requirements
  • Details SQL Server's locking model, the internal use of latches, and row versioning
  • Shows you how to use SQLDiag, RML Utilities, SQL Nexus, the Management Data Warehouse, and how to build your own SQL Server Management Studio reports
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

wrox.com
Programmer Forums
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Help
Contact Us
Payments
Shipping & Returns
Help & FAQ
Policies
Terms of Use
Security
Privacy
About Us
Blog
Careers
About us
Misc
Home
Affiliate
e-Gift Voucher
Book List
Author List
Search for Books :
© 2013 Greenleaf Bookshop. One Stop Shop for all your Books, Audio Books,CBT's, DVD's