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.
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)
|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.|