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

August 9, 2012

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

(PRWEB) August 09, 2012

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.

For the original version on PRWeb visit: http://www.prweb.com/releases/prweb2012/8/prweb9784610.htm

Source: prweb

comments powered by Disqus