Microsoft SQL Server 2012 performance tuning cookbook : 80 recipes to help you tune SQL Server 2012 and achieve optimal performance / Ritesh Shah, Bihag Thaker.

Format:

Book

Author/Creator:

Shah, Ritesh.

Contributor:

Thaker, Bihag.

Series:

Enterprise : professional expertise distilled

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Physical Description:

1 online resource (478 p.)

Edition:

1st edition

Other Title:

SQL Server 2012 performance tuning cookbook

Place of Publication:

Birmingham : Packt Pub., 2012.

Language Note:

English

System Details:

text file

Summary:

Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance

Contents:

Cover; Copyright; Credits; About the Authors; Acknowledgement; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Mastering SQL Trace Using Profiler; Introduction; Creating a trace or workload; Filtering events; Detecting slow running and expensive queries; Creating trace with system stored procedures; Chapter 2: Tuning with Database Engine Tuning Advisor; Introduction; Analyzing queries using Database Engine Tuning Advisor; Running Database Engine Tuning Advisor for workload; Executing Database Tuning Advisor from command prompt

Chapter 3: System Statistical Functions, Stored Procedures, and the DBCC SQLPERF CommandIntroduction; Monitoring system health using system statistical functions; Monitoring with system stored procedure; Monitoring log space usage statistics with DBCC command; Chapter 4: Resource Monitor and Performance Monitor; Introduction; Monitoring of server performance; Monitoring CPU usage; Monitoring memory (RAM) usage; Chapter 5: Monitoring with Execution Plans; Introduction; Working with estimated execution plan; Working with actual execution plan

Monitoring performance of a query by SET SHOWPLAN_XMLMonitoring performance of a query by SET STATISTICS XML; Monitoring performance of a query by SET STATISTICS IO; Monitoring performance of a query by SET STATISTICS TIME; Including and understanding client statistics; Chapter 6: Tuning with Execution Plans; Introduction; Understanding Hash, Merge, and Nested Loop Join strategies; Finding table/index scans in execution plan and fixing them; Introducing Key Lookups, finding them in execution plans, and resolving them; Chapter 7: Dynamic Management Views and Dynamic Management Functions

IntroductionMonitoring current query execution statistics; Monitoring index performance; Monitoring performance of TempDB database; Monitoring disk I/O statistics; Chapter 8: SQL Server Cache and Stored Procedure Recompilations; Introduction; Monitoring compilations and recompilations at instance level using Reliability and Performance Monitor; Monitoring recompilations using SQL Server Profiler; Chapter 9: Implementing Indexes; Introduction; Increasing performance by creating a clustered index; Increasing performance by creating a non-clustered index; Increasing performance by covering index

Increasing performance by including columns in an indexImproving performance by a filtered index; Improving performance by a columnstore index; Chapter 10: Maintaining Indexes; Introduction; Finding fragmentation; Playing with Fill Factor; Enhance index efficiency by using the REBUILD index; Enhance index efficiency by using the REORGANIZE index; How to find missing indexes; How to find unused indexes; Enhancing performance by creating an indexed view; Enhancing performance with index on Computed Columns; Determining disk space consumed by indexes

Chapter 11: Points to Consider While Writing Queries

Notes:

"Quick answers to common problems."

ISBN:

9786613832139

9781283519687

1283519682

9781849685757

1849685754

OCLC:

823244916