SQL Server 2017 Query Performance Tuning : troubleshoot and optimize query performance /: troubleshoot and optimize query performance. (2014)

• Record Type: Book
• Uniform Title: SQL Server query performance tuning.
• Further Information: Note: Grant Fritchey.
• Authors: Fritchey, Grant
• Contents: Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; 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 or Inaccurate Indexing; Inaccurate Statistics; Improper Query Design; Poorly Generated Execution Plans; Excessive Blocking and Deadlocks; Non-Set-Based Operations; Inappropriate Database Design; Recompiling Execution Plans Frequent Recompilation of QueriesImproper Use of Cursors; Excessive Index Fragmentation; Summary; Chapter 2: Memory Performance Analysis; Performance Monitor Tool; Dynamic Management Views; 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; Target Server Memory (KB) and Total Server Memory (KB) Additional Memory Monitoring ToolsDBCC MEMORYSTATUS; Dynamic Management Views; 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; Monitoring Memory in Linux; 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 Chapter 3: Disk Performance AnalysisDisk Bottleneck Analysis; Disk Counters; Disk Transfers/Sec; Disk Bytes/Sec; Avg. Disk Sec/Read and Avg. Disk Sec/Write; Buffer Manager Page Reads/Writes; Additional I/O Monitoring Tools; Sys.dm_io_virtual_file_stats; Sys.dm_os_wait_stats; Monitoring Linux I/0; 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 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; Query Store; Measure CPU Behavior in Linux; Processor Bottleneck Resolutions; Optimizing Application Workload; Eliminating Excessive Compiles/Recompiles; Using More or Faster Processors
• Edition: Fifth edition
• Publisher Details: New York : Apress
• Publication Date: 2014; 2018
• Extent: 1 online resource
• Subjects: 005.75/85; Computer science; Querying (Computer science); Relational databases; Client/server computing; Database management; REFERENCE -- General; Microsoft programming; Databases; Computers -- Programming -- Microsoft Programming; Microsoft software; Microsoft .NET Framework; Computers -- Database Management -- General; Electronic books
• Languages: English
• ISBNs: 9781484238882; 1484238885
• Related ISBNs: 1484238877; 9781484238875
• Notes: Note: Description based on online resource; title from digital title page (viewed on September 19, 2018).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.