Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook,Apr 2007-Digital Press.pdf

- Free Books & magazines
Microsoft® SQL ServerTM
2005 Performance
Optimization and Tuning
Handbook
This Page Intentionally Left Blank
Microsoft® SQL ServerTM
2005 Performance
Optimization and Tuning
Handbook
Ken England
Gavin Powell
Amsterdam • Boston • Heidelberg • London • New York • Oxford
Paris • San Diego• San Francisco • Singapore • Sydney • Tokyo
Digital Press is an imprint of Elsevier
Digital Press is an imprint of Elsevier
30 Corporate Drive, Suite 400, Burlington, MA 01803, USA
Linacre House, Jordan Hill, Oxford OX2 8DP, UK
Copyright © 2007, Elsevier Inc. All rights reserved.
No part of this publication may be reproduced, stored in a retrieval system, or
transmitted in any form or by any means, electronic, mechanical, photocopying,
recording, or otherwise, without the prior written permission of the publisher.
Permissions may be sought directly from Elsevier’s Science & Technology Rights
Department in Oxford, UK: phone: (+44) 1865 843830, fax: (+44) 1865 853333,
E-mail: ******@. You may plete your request online
via the Elsevier homepage (), by selecting “Support & Contact”
then “Copyright and Permission” and then “Obtaining Permissions.”
Recognizing the importance of preserving what has been written, Elsevier prints its
books on acid-free paper whenever possible.
Library of Congress Cataloging-in-Publication Data
Application Submitted.
British Library Cataloguing-in-Publication Data
A catalogue record for this book is available from the British Library.
ISBN: 978-1-55558-319-4
For information on all Elsevier Digital Press publications visit our Web site at
Printed in the United States of America
07 08 09 10 11 12 10 9 8 7 6 5 4 3 2 1
Contents at a Glance
Introduction xv
1 Performance and SQL Server 2005 1
2. Logical Database Design for Performance 19
3. Physical Database Design 65
4. SQL Server Storage Structures 75
5. Indexing 121
6. Basic Query Tuning 193
7. What Is Query O