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

Author (1):

Ritesh Shah

View More author details

Table of Contents (21) Chapters

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

Chapter 1. Mastering SQL Trace Using Profiler

In this chapter we will cover:

Creating a trace or workload
Filtering events
Detecting slow running and expensive queries
Creating trace with SQL Trace system stored procedures

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

You have been reading a chapter from

Microsoft SQL Server 2012 Performance Tuning Cookbook

Published in: Jul 2012

Publisher: Packt

ISBN-13: 9781849685740

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (1)

Ritesh Shah

Ritesh Shah is a data professional and has 10+ years of experience in Microsoft technology from SQL Server 2000 to the latest one and has worked from Visual Basic 6.0 to .NET Framework 4.0. He has deployed many medium scale as well as large scale projects using Microsoft technology. He shares his knowledge in his blog SQLHub.com and also helps the community in different portals like BeyondRelational.com, Experts-Exchange.com and Asp.Net forums.

See other products by Ritesh Shah