Cargando…
SQL Server query performance tuning /
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey?s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress,
2014.
|
| Edición: | Fourth edition. |
| Colección: | Expert's voice in SQL server.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- At a Glance; Introduction; Chapter 1: SQL Query Performance Tuning; The Performance Tuning Process; The Core Process; Iterating the Process; Performance vs. Price; Performance Targets; "Good Enough" Tuning; Performance Baseline; Where to Focus Efforts; SQL Server Performance Killers; Insufficient Indexing; Inaccurate Statistics; Improper Query Design; Poorly Generated Execution Plans; Excessive Blocking and Deadlocks; Non-Set-Based Operations; Inappropriate Database Design; Excessive Fragmentation; Nonreusable Execution Plans; Frequent Recompilation of Queries.
- Chapter 3: Disk Performance AnalysisDisk Bottleneck Analysis; Disk Counters; % Disk Time; Current Disk Queue Length; Disk Transfers/Sec; Disk Bytes/Sec; Avg. Disk Sec/Read and Avg. Disk Sec/Write; Additional I/O Monitoring Tools; Sys.dm_io_virtual_file_stats; Sys.dm_os_wait_stats; Disk Bottleneck Resolutions; Optimizing Application Workload; Using a Faster I/O Path; Using a RAID Array; RAID 0; RAID 1; RAID 5; RAID 6; RAID 1+0 (RAID 10); Using a SAN System; Using Solid State Drives; Aligning Disks Properly; Adding System Memory; Creating Multiple Files and Filegroups.
- Improper Use of CursorsImproper Configuration of the Database Transaction Log; Excessive Use or Improper Configuration of tempdb; Summary; Chapter 2: Memory Performance Analysis; Performance Monitor Tool; Dynamic Management Objects; Hardware Resource Bottlenecks; Identifying Bottlenecks; Bottleneck Resolution; Memory Bottleneck Analysis; SQL Server Memory Management; Available Bytes; Pages/Sec and Page Faults/Sec; Paging File %Usage and Page File %Usage; Buffer Cache Hit Ratio; Page Life Expectancy; Checkpoint Pages/Sec; Lazy Writes/Sec; Memory Grants Pending.
- Moving the Log Files to a Separate Physical DiskUsing Partitioned Tables; Summary; Chapter 4: CPU Performance Analysis; Processor Bottleneck Analysis; % Processor Time; % Privileged Time; Processor Queue Length; Context Switches/Sec; Batch Requests/Sec; SQL Compilations/Sec; SQL Recompilations/Sec; Other Tools for Measuring CPU Performance; Sys.dm_os_wait_stats; Sys.dm_os_workers and Sys.dm_os_schedulers; Processor Bottleneck Resolutions; Optimizing Application Workload; Eliminating Excessive Compiles/Recompiles; Using More or Faster Processors; Not Running Unnecessary Software.
- Target Server Memory (KB) and Total Server Memory (KB)Additional Memory Monitoring Tools; DBCC MEMORYSTATUS; Dynamic Management Objects; Sys.dm_os_memory_brokers; Sys.dm_os_memory_clerks; Sys.dm_os_ring_buffers; Sys.dm_db_xtp_table_memory_stats; Sys.dm_xtp_system_memory_consumers; Memory Bottleneck Resolutions; Optimizing Application Workload; Allocating More Memory to SQL Server; Moving In-Memory Tables Back to Standard Storage; Increasing System Memory; Changing from a 32-Bit to a 64-Bit Processor; Compressing Data; Enabling 3GB of Process Address Space; Addressing Fragmentation; Summary.