Microsoft SQL Server 2012 Performance Tuning Cookbook

With this book you'll learn all you need to know about performance monitoring, tuning, and management for SQL Server 2012. Includes a host of recipes and screenshots to help you say goodbye to slow running applications.

Key Features

• Learn about the performance tuning needs for SQL Server 2012 with this book and ebook
• Diagnose problems when they arise and employ tricks to prevent them
• Explore various aspects that affect performance by following the clear recipes

Book Description

What you will learn

• Monitoring SQL Server Performance with Profiler, Execution Plan, and system statistical function
• Finding performance bottleneck with the help of Resource Monitor and DTA
• Creating and Managing Indexes efficiently to boost performance
• Creating and Managing Partition efficiently
• Managing database files efficiently
• Planning Guide and Query Hints
• Dealing with locking, blocking, and deadlocking
• Configuring SQL Server instance option for achieving performance benefit
• Managing Performance with Policy based management and Resource Governor

Who this book is for

SQL Server 2012 Performance Tuning Cookbook is aimed at SQL Server Database Developers, DBAs, and Database Architects who are working in any capacity to achieve optimal performance. However, basic knowledge of SQL Server is expected, but professionals who want to get hands-on with performance tuning and have not worked on tuning the SQL Server for performance will find this book helpful.