Diagnose problem on the SQL Server with Packt's New Book and eBook

Share Article

Monitor SQL Server Performance with Profiler, Execution Plan, and system statistical function

Microsoft SQL Server

Microsoft SQL Server 2012 Performance Tuning Cookbook

Packt is pleased to announce Microsoft SQL Server 2012 Performance Tuning Cookbook, a new book and ebook for DBA's that will help them learn about the performance tuning needs for SQL Server 2012 and monitoring the SQL Server performance with Profiler, Execution Plan, and system statistical function.

About The Authors:
Ritesh Shah : Ritesh Shah is a data professional with more than 10 years of experience in Microsoft technology right from SQL Server 2000. He has sucessfully deployed many medium scale as well as large scale projects using Microsoft technology.

Bihag Thaker : Bihag Thaker is an SQL Server enthusiast, an MCTS (SQL Server 2005) and MCITP (SQL Server 2008) who has been working on SQL Server technology for the past few years. He is currently working in the role of a database administrator, and has worked on numerous performance tuning assignments and executed large scale database migrations.

This book is divided into three major parts -- Performance Monitoring, Performance Tuning, and Performance Management--that are mandatory to deal with performance in any capacity. Filled with numerous recipes, the first part covers Monitoring with SQL Server Profiler, DTA, System statistical function, SPs with DBCC commands, Resource Monitor & Reliability, and Performance Monitor and Execution Plan.

The second part of the book focuses on Execution Plan, Dynamic Management Views, and Dynamic Management Functions, SQL Server Cache and Stored Procedure Recompilations, Indexes, Table and Index Partitioning, Advanced Query tuning with Query Hints and Plan Guide, and Configuring SQL Server for optimization to boost performance.

The third and final part provides information on performance management with the help of Policy Based Management and Management with Resource Governor.

Some of the essential chapters covered in this book are -

Chapter 1: Mastering SQL Trace Using Profiler
Chapter 2: Tuning with Database Engine Tuning Advisor
Chapter 3: System Statistical Functions, Stored Procedures, and the DBCC SQLPERF Command
Chapter 4: Resource Monitor and Performance Monitor
Chapter 5: Monitoring with Execution Plans
Chapter 6: Tuning with Execution Plans
Chapter 7: Dynamic Management Views and Dynamic Management Functions
Chapter 8: SQL Server Cache and Stored Procedure Recompilations
Chapter 9: Implementing Indexes
Chapter 10: Maintaining Indexes
Chapter 11: Points to Consider While Writing Queries
Chapter 12: Statistics in SQL Server
Chapter 13: Table and Index Partitioning
Chapter 14: Implementing Physical Database Structure
Chapter 15: Advanced Query Tuning Hints and Plan Guides
Chapter 16: Dealing with Locking, Blocking, and Deadlocking
Chapter 17: Configuring SQL Server for Optimization
Chapter 18: Policy-based Management
Chapter 19: Resource Management with Resource Governor

Packt has also published and is due to publish various related titles:

  •     Microsoft SQL Server 2012 Security Cookbook (Expected September 2012)
  •     SQL Server 2012 with PowerShell V3 Cookbook (Expected October 2012)
  •     Microsoft SQL Server 2012 Integration Services: An Expert Cookbook (May 2012)

Packt Enterprise is a publishing division of Packt Publishing designed to serve the information needs of IT Professionals in the Enterprise space. Packt Enterprise also publishes on Microsoft, IBM, Oracle, Citrix, Java, Amazon, Google and SAP technologies.

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Duane Moraes
Packt Publishing Limited
+44 121 265 6486
Email >
Follow us on
Visit website