Printer Friendly

SQL server 2005 practical troubleshooting; the data base engine. (CD-ROM included).


SQL server 2005 practical troubleshooting; the data base engine. (CD-ROM included)

Ed. by Ken Henderson.



461 pages




Insider Henderson and a team of developers and support engineers give novice to advanced users exceptional access to diagnostic and troubleshooting tools here. Each chapter starts with the basics on the architecture of a key server component, then goes deeper into details starting with the most common problems user encounter. In the process Henderson covers issues with waiting and blocking (including identifying sources and resource type specifics), data corruption and recovery (including storage internals, data recovery best practices and database consistency errors), memory (including Windows, SQLOS and SQL memory management), procedure caches (including common problems and solutions), query processors (including best practices), service crashes and other critical failures, the product Service Broker, SQLOS and scheduling (including configuration), Tempdb (including how space is consumed) and clustering (including getting performance up to acceptable levels). The CD-ROM contains a selection of tools, sample code and scripts.

([c]20072005 Book News, Inc., Portland, OR)
COPYRIGHT 2007 Book News, Inc.
No portion of this article can be reproduced without the express written permission from the copyright holder.
Copyright 2007 Gale, Cengage Learning. All rights reserved.

Article Details
Printer friendly Cite/link Email Feedback
Publication:SciTech Book News
Article Type:Book review
Date:Mar 1, 2007
Previous Article:Something dangerous; emergent and changing illicit drug use and community health.
Next Article:Cybersins and digital good deeds; a book about technology and ethics.

Related Articles
DB2 SQL PL; essential guide for DB2 UDB on Linux, Unix, Windows, i5/0s, and z/OS, 2d ed. (CD-ROM included).
Mastering Oracle SQL and SQL*Plus. (CD-ROM included).
Microsoft SQL Server 2000 Notification Services. (CD-ROM included).
Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours. (CD-ROM included).
Supporting Users and Troubleshooting a Windows XP Operating System.
Microsoft Exchange server 2003 resource kit. (CD-ROM included).
SQL Server 2005 for Developers. (CD-ROM included).
Introduction to SQL; mastering the relational database language. 4th ed. (CD-ROM included).
Inside SQL server 2005 tools. (CD-ROM included).

Terms of use | Copyright © 2016 Farlex, Inc. | Feedback | For webmasters