Cargando…
Microsoft SQL Server 2012 Performance Tuning Cookbook : 80 Recipes to Help You Tune SQL Server 2012 and Achieve Optimal Performance /
Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2012.
|
| Colección: | Enterprise : professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- Microsoft SQL Server 2012 Performance Tuning Cookbook; Microsoft SQL Server 2012 Performance Tuning Cookbook; Credits; About the Authors; Acknowledgement; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Mastering SQL Trace Using Profiler; Introduction.
- Creating a trace or workloadGetting ready; How to do it ... ; How it works ... ; There's more ... ; Some background of SQL Trace; SQL Trace terms and concepts; SQL Trace; SQL Server Profiler; Event; Event class; Event category; Data column; Trace; Trace properties and Trace definition; Filter; Trace file; Trace table; Trace template; Architecture of SQL Trace; Trace and workload; Commonly-used event classes; Commonly-used data columns; Filtering events; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Detecting slow running and expensive queries; Getting ready; How to do it ...
- How it works ... There's more ... ; Trace templates; Creating trace with system stored procedures; Getting ready; How to do it ... ; How it works ... ; 2. Tuning with Database Engine Tuning Advisor; Introduction; Analyzing queries using Database Engine Tuning Advisor; Getting ready; How to do it ... ; How it works ... ; Running Database Engine Tuning Advisor for workload; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Executing Database Tuning Advisor from command prompt; Getting ready; How to do it ... ; How it works ... ; There's more ...
- 3. System Statistical Functions, Stored Procedures, and the DBCC SQLPERF CommandIntroduction; Monitoring system health using system statistical functions; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Monitoring with system stored procedure; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Monitoring log space usage statistics with DBCC command; Getting ready; How to do it ... ; How it works ... ; There's more ... ; 4. Resource Monitor and Performance Monitor; Introduction; Monitoring of server performance; Getting ready; How to do it ... ; How it works ...
- There's more ... Monitoring CPU usage; Getting ready; How to do it ... ; How it works ... ; Monitoring memory (RAM) usage; Getting ready; How to do it ... ; How it works ... ; 5. Monitoring with Execution Plans; Introduction; Working with estimated execution plan; Getting ready; How to do it ... ; How it works ... ; Working with actual execution plan; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Monitoring performance of a query by SET SHOWPLAN_XML; Getting ready; How to do it ... ; How it works ... ; Monitoring performance of a query by SET STATISTICS XML; Getting ready; How to do it ...