Packt+ | Advance your knowledge in tech

You're reading from 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.

Product type Paperback

Published in Jul 2012

Publisher Packt

ISBN-13 9781849685740

Length 478 pages

Edition 1st Edition

Languages

Tools

SQL Server

Concepts

Servers

Table of Contents (28) Chapters

Microsoft SQL Server 2012 Performance Tuning Cookbook

Credits

About the Authors

Acknowledgement

About the Reviewers

www.PacktPub.com

1. Preface

1. Mastering SQL Trace Using Profiler FREE CHAPTER

2. Tuning with Database Engine Tuning Advisor

3. System Statistical Functions, Stored Procedures, and the DBCC SQLPERF Command

4. Resource Monitor and Performance Monitor

5. Monitoring with Execution Plans

6. Tuning with Execution Plans

7. Dynamic Management Views and Dynamic Management Functions

8. SQL Server Cache and Stored Procedure Recompilations

9. Implementing Indexes

10. Maintaining Indexes

11. Points to Consider While Writing Queries

12. Statistics in SQL Server

13. Table and Index Partitioning

14. Implementing Physical Database Structure

15. Advanced Query Tuning Hints and Plan Guides

16. Dealing with Locking, Blocking, and Deadlocking

17. Configuring SQL Server for Optimization

18. Policy-based Management

19. Resource Management with Resource Governor

Index

Configuring Resource Governor with SQL Server Management Studio

Before we look at configuring Resource Governor, we will first set up a real-life scenario.

Let's suppose that AdventureWorks2012 is our production database and it has billions of records. The database supports multiple applications. One of the applications supported by the database is a web application, which is an OLTP database application that consumes AdventureWorks2012 database. The normal functioning of the web application is very important compared to any other applications consuming the database server resources.

Another application is the reporting application that is used to generate reports. To fulfil reporting requirements, this application runs queries with heavy calculations. Because of heavy calculations, queries take longer to execute and consume a high percentage of CPU and memory resources, which leaves less room for other query requests, made by the web application, to execute efficiently. Due to this, the...

The rest of the chapter is locked

You're reading from 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.

Table of Contents (28) Chapters

Configuring Resource Governor with SQL Server Management Studio

Unlock this book and the full library FREE for 7 days

Personalised recommendations for you