|
Microsoft SQL Server 2012 Performance Tuning Cookbook is divided into
three major parts—Performance Monitoring, Performance Tuning, and Performance Management—that are mandatory for dealing with performance in any capacity.
Microsoft SQL Server 2012 Performance Tuning Cookbook offers a great way to manage performance with effective, concise, and practical recipes. You will learn how to diagnose performance issues, fix them, and take precautions to avoid common mistakes.
Each recipe given in this book is an individual task that will address different performance aspects to take your SQL Server's Performance to a higher level.
The first part of this book covers monitoring with SQL Server Profiler, DTA, system statistical functions, SPs with DBCC commands, Resource Monitor, Reliability and Performance Monitor, and execution plans.
The second part of the book offers execution plan, dynamic management views and
dynamic management functions, SQL Server Cache, stored procedure recompilations, indexes, important ways to write effective T-SQL, statistics, table and index partitioning, advanced query tuning with query hints and plan guide, dealing with locking, blocking,
and deadlocking, and configuring SQL Server for optimization to boost performance.
The third and final part gives you knowledge about performance management with the help
of policy based management and management with Resource Governor.
|
