Microsoft.SQL.Server.2012.Performance.Tuning.Cookbook,.Shah,.Thaker,.Packt,.2012.pdf

Microsoft SQL Server
2012 Performance
Tuning Cookbook
80 recipes to help you tune SQL Server 2012 and achieve
optimal performance
Ritesh Shah
Bihag Thaker
professional expertise distilled
PUBLISHING
BIRMINGHAM - MUMBAI
Microsoft SQL Server 2012 Performance
Tuning Cookbook
Copyright © 2012 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or
transmitted in any form or by any means, without the prior written permission of the publisher,
except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the
information presented. However, the information contained in this book is sold without
warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers
and distributors will be held liable for any damages caused or alleged to be caused directly or
indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of panies
and products mentioned in this book by the appropriate use of capitals. However, Packt
Publishing cannot guarantee the accuracy of this information.
First published: July 2012
Production Reference: 1160712
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-84968-574-0
Cover Image by Asher Wishkerman (a.******@)
Credits
Authors Project Coordinator
Ritesh Shah Sai Gamare
Bihag Thaker
Proofreader
Reviewers Lesley Harrison
Satya SK Jayanty
Maria Zakourdaev Indexer
Monica Ajmera Mehta
Michael Zilberstein
Graphics
Acquisition Editor
Manu Joseph
Dhwani Devater
Valentina Dsilva
Lead Technical Editor
Kedar Bhat Production Coordinator
Shantanu Zagade
Technical Editors
Apoorva Bolar Cover Work
Shantanu Zagade
Madhuri Das
Merin Jose
Copy Editor
Brandt D'Mello
About the Authors
Ritesh Shah i