Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages.

N� de r�f. du vendeur M00321447743-V

Contacter le vendeur

Signaler cet article

D�tails bibliographiques

Titre: SQL Server 2005 Practical Troubleshooting: The Database Engine
�diteur: Addison-Wesley
Date de parution: 2006
Langue: anglais
ISBN � 10 chiffres: 0321447743
ISBN � 13 chiffres: 9780321447746
�tat de l'article: very good

A propos de ce titre

Synopsis

Never-Before-Published Insiders’ Information for Troubleshooting SQL Server 2005.

This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people who know it most intimately: the people who wrote it, designed it, and support it. SQL Server expert Ken Henderson, author of the best-selling Guru’s Guides to SQL Server, has assembled a “dream team” of SQL Server developers and support engineers to provide in-depth troubleshooting and diagnostic information that has never been documented before: information that would be impossible to get without access to Microsoft’s own source code.

From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You’ll find comprehensive, in-depth chapters on

• Waiting and blocking

• Data corruption and recovery

• Memory

• Procedure cache issues

• Query processing

• Server crashes and other critical failures

• Service Broker

• SQLOS and scheduling

• tempdb

• Clustering

This is the indispensable resource for everyone who must keep SQL Server running smoothly: DBAs, database application developers, API programmers, and Web developers alike.

Contents

About the Authors ix

Preface xii

Acknowledgments xiv

1 Waiting and Blocking Issues 1

2 Data Corruption and Recovery Issues 47

3 Memory Issues 137

4 Procedure Cache Issues 183

5 Query Processor Issues 225

6 Server Crashes and Other Critical Failures 273

7 Service Broker Issues 331

8 SQLOS and Scheduling Issues 369

9 Tempdb Issues 411

10 Clustering Issues 425

The Aging Champion 441

Index 445

� propos de l?auteur

The authoring team is a mix of developers from the SQL Server development team and support professionals from Microsoft’s Customer Support Services organization. Seven developers from the SQL Server development team and three support professionals from Microsoft CSS contributed to this book.

SQL Server Development Team

August Hill has been a developer for more than 30 years. For the past six years he has been a member of the SQL Server Service Broker team. He’s made a number of contributions to the product in the area of supportability. When he’s not developing software he can be found playing guitar or tasting Washington wines. He can be reached at august.hill@microsoft.com.

Cesar Galindo-Legaria is the manager of the Query Optimizer group in SQL Server. He received a Ph.D. in computer science (databases) from Harvard University in 1992. After working for a graphics company in the Boston area, he went back to databases, doing post-doctoral visits in European research centers. In 1995 he joined Microsoft to work on a new relational query processor, first shipped with SQL Server 7.0, which introduced a fully cost-based query optimizer, a rich set of execution algorithms, and a number of auto-administration features. He has been working on query processing for SQL Server ever since. He holds several patents on query processing and optimization, and has published a number of research papers in that area.

Ken Henderson has been a developer for more than 25 years. He has worked with SQL Server since 1990 and has built software for a number of firms throughout his career, including H&R Block, the Central Intelligence Agency, the U.S. Navy, the U.S. Air Force, Borland International, JP Morgan, and various others. He joined Microsoft in 2001 and is currently a developer in the Manageability Platform group within the SQL Server development team. He is the creator of SQL Server 2005’s SQLDiag facility and spends his days working on SQL Server management tools and related technologies. He is the author of eight books on a variety of computing topics, including the popular Guru’s Guide series of SQL Server books available from Addison-Wesley. He lives with his family in the Dallas area and may be reached via email at khen@khen.com.

Sameer Tejani, originally from Arusha, Tanzania, has spent the past 10 years working at Microsoft in the SQL Server group. His work has exposed him to different areas of the SQL Server Engine, including the T-SQL execution framework, Open Data Services (ODS), connection management, User Mode Scheduler (UMS), and other areas. He is solely responsible for the infamous “non-yielding scheduler” error messages that support professionals have come to abhor! He is currently a software development lead in the SQL Server Security team. In his spare time, Sameer enjoys being outdoors and going on long bike rides. He lives with his wife Farhat in the Seattle area.

Santeri Voutilainen, better known as Santtu, has been a software design engineer in SQL Server storage engine team since 1999. He has worked closely on page allocation, latches, and the lock manager. A graduate of Harvard University, he is in the final stages of a master’s degree in computer science from the University of Washington. Although he calls Seattle home, Santeri was born in Finland and spent most of his young life in Nepal. He is an avid traveler and outdoorsman and spends his free time exploring the Pacific Northwest with his wife and one-year-old son. Santtu can be reached at sqlsanttu@vode.net.

Slava Oks is a software architect for the Storage Engine and Infrastructure team in SQL Server. He has been with Microsoft for more than nine years. During the SQL Server 2005 development, project he worked on architecture and implementation of SQLOS. He’s made a number of contributions to the product in the area of performance, scalability, supportability, and testability. He is also the author of a popular SQL Server’s blog located at blogs.msdn.com/slavao. When he’s not developing software he can be found playing sports or having fun with friends and family.

Wei Xiao worked on the design of the SQL Server Storage Engine in Microsoft from 1996 to April 2006. His main areas of focus are access methods, concurrency control, space management, logging, and recovery. He also worked on SQL Server performance monitoring and troubleshooting. He has spoken at several industry conferences, including Microsoft Tech Ed and SQL PASS. He is currently working on a Microsoft internal data storage project.

Microsoft Customer Support Services

Bart Duncan has worked with SQL Server and related technologies for about 10 years. He is currently an escalation engineer in the SQL Server product support group. Bart lives in Dallas, Texas, where he is fortunate to share a home with his wonderful wife, Dr. Andrea Freeman Duncan.

Bob Ward is a senior escalation engineer in Microsoft Customer Service and Support (CSS) based in the Microsoft Regional Support Center in Irving, Texas. He has worked with Microsoft for 13 years and has now supported every release of Microsoft SQL Server from 1.1 for OS/2 to SQL Server 2005. His background in the computer industry spans 20 years and includes database development projects with companies like General Dynamics, Harris Hospital, and American Airlines. Bob graduated with a bachelor’s degree in computer science from Baylor University in 1986. He currently lives in North Richland Hills, Texas, with his wife Ginger and two sons, Troy and Ryan. Bob spends his spare time coaching youth sports, cheering for the local professional sports teams, and sharpening his golf game for a dream of playing on the PGA Legends Tour.

Cindy Gross has been a member of the Texas Microsoft PSS support team for SQL Server and Analysis Services since 2000. Cindy has taken on many roles during this time, including support engineer, content lead, and Yukon readiness lead. Before joining Microsoft, Cindy was a SQL Server DBA for seven years, working on SQL Server versions 1.11 and later. She is an avid reader of science fiction and fantasy, with a special love for books starring women as fighters. Her favorite non-technical author is Sheri S. Tepper. Cindy spends many weekends racing her dirt bike–currently a 2004 Honda CRF250X. You may contact Cindy from her website http://cindygross.spaces.live.com/.

Les informations fournies dans la section � A propos du livre � peuvent faire r�f�rence � une autre �dition de ce titre.

Description de la librairie

**WILLKOMMEN** im AbeBooks Shop von medimops - dein Onlineshop mit der gr��ten Auswahl an Second Hand B�chern. St�ber dich durch �ber 4 Millionen Artikel und spare bis zu 70 % im Vergleich zum Neupreis. Wir pr�fen alle Artikel sorgf�ltig auf Qualit�t und Funktionalit�t. **WELCOME** to the medimop's AbeBooks shop, the online shop with a large range of second-hand books. Browse more than 4 million articles and save up to 70% on the new price. All our articles are quality checked. ** BIENVENUE ** dans la boutique AbeBooks de momox shop! Sp�cialiste des articles culturels d'occasion, nous vous offrons une gamme diversifi�e de livres d'occasion. D�couvrez nos offres et �conomisez jusqu'� 70% du prix neuf! Nous grarantissons tous nos articles en bon �tat. ** BENVENUTI ** nello shop medimops di AbeBooks, lo shop online per i libri usati. Abbiamo piu�di 4 milioni di articoli e potete risparmiare fino al 70% rispetto al nuovo. Tutti i nostri prodotti sono controllati a mano per garantire la massima qualit�. ** BIENVENIDO ** a la tienda de medimops en AbeBooks, la tienda online con una gran oferta de libros de segunda mano. Navegue por m�s de 4 millones de art�culos y ahorre hasta un 70% sobre el precio nuevo. Todos nuestros art�culos son de calidad comprobada.

Visitez la page d�accueil du vendeur

Informations commerciales relatives au vendeur

momox SE
Schreiberhauer Stra�e 30, Berlin, 10317, Germany

Conditions de vente et de livraison

Conditions g�n�rales de vente

1. Champ d'application

Les CGV suivantes s'appliquent � toutes les commandes pass�es via notre Boutique sur le Marketplace d'AbeBooks. Sauf accord contraire, l'int�gration de vos propres conditions, le cas �ch�ant, est exclue.

2. partie contractante, conclusion du contrat, possibilit�s de correction

Le contrat de vente est conclu avec momox SE.

L'objet du contrat est la vente de marchandises.

Si nous mettons un Article en ligne sur Abebooks, l'activation de la Page d'offre sur Abebooks constitue...

Pour plus d'information

Droit de r�tractation

Vous avez le droit de vous r�tracter du pr�sent contrat sans donner de motif dans un d�lai de quatorze jours. Le d�lai de r�tractation est de quatorze jours � compter de la date � laquelle vous, ou un tiers autre que le transporteur et d�sign� par vous, avez pris possession de la derni�re marchandise. Pour exercer votre droit de r�tractation, vous devez informer momox SE, Schreiberhauer Stra�e 30, 10317 Berlin, num�ro de t�l�phone : +33 1 85 14 99 72, e-mail : service@momox-shop.fr, de votre d�cision de vous r�tracter du pr�sent contrat au moyen d'une d�claration d�nu�e d'ambigu�t� (par ex. lettre envoy�e par la poste, t�l�copie ou e-mail). Pour ce faire, vous pouvez utiliser le mod�le de formulaire de r�tractation, qui n'est toutefois pas obligatoire. Pour que le d�lai de r�tractation soit respect�, il suffit que vous envoyiez la communication relative � l'exercice du droit de r�tractation avant l'expiration du d�lai de r�tractation.

Cons�quences de la r�vocation

En cas de r�tractation du pr�sent contrat, nous vous rembourserons tous les paiements re�us de vous, y compris les frais de livraison (� l'exception des frais suppl�mentaires d�coulant du fait que vous avez choisi un mode de livraison autre que le mode moins co�teux de livraison standard propos� par nous), sans retard excessif et au plus tard quatorze jours � compter de la date � laquelle nous aurons �t� inform�s de votre d�cision de r�tractation du pr�sent contrat. Pour ce remboursement, nous utilisons le m�me moyen de paiement que celui que vous avez utilis� pour la transaction initiale, � moins qu'il n'en ait �t� express�ment convenu autrement avec vous ; en aucun cas, des frais ne vous seront factur�s pour ce remboursement. Nous pouvons refuser le remboursement jusqu'� ce que nous ayons r�cup�r� les marchandises ou jusqu'� ce que vous ayez fourni la preuve que vous avez renvoy� les marchandises, la date retenue �tant celle du premier de ces faits. Vous devrez renvoyer ou rendre le bien, sans retard excessif et, en tout �tat de cause, au plus tard quatorze jours � compter de la date � laquelle vous nous aurez inform�s de votre d�cision de r�tractation du pr�sent contrat.
Salesupply - Momox
87 rue de Fontenoy
59100 Roubaix
France
de renvoyer les marchandises.

Le d�lai est respect� si vous renvoyez les marchandises avant l'expiration des quatorze jours. Les frais directs de renvoi des marchandises sont � votre charge. Vous ne devez prendre en charge une �ventuelle perte de valeur des marchandises que si cette perte de valeur est due � une manipulation des marchandises qui n'est pas n�cessaire pour v�rifier leur nature, leurs caract�ristiques et leur fonctionnement.

Conditions d'exp�dition

Frais d?exp�dition de Allemagne�vers�Etats-Unis

Frais d?exp�dition de Allemagne�vers�Etats-Unis
Quantit� command�e	10 � 20 jours ouvr�s	10 � 20 jours ouvr�s
Premier article	EUR 5.00	EUR 15.00

Les d�lais de livraison sont fix�s par les vendeurs et varient en fonction du transporteur et du lieu. Les commandes transitant par les douanes peuvent �tre retard�es et les acheteurs sont responsables de tous les droits ou frais associ�s. Les vendeurs peuvent vous contacter au sujet de frais suppl�mentaires afin de couvrir toute augmentation des co�ts d'exp�dition de vos articles.

Informations vendeur d�taill�es