Query store for SQL Server 2019 : Identify and Fix Poorly Performing Queries /: Identify and Fix Poorly Performing Queries. (2019)

• Record Type: Book
• Further Information: Note: Tracy Boggiano, Grant Fritchey.
• Other Names: Boggiano, Tracy; Fritchey, Grant
• Contents: Intro; Table of Contents; About the Authors; About the Technical Reviewer; Introduction; Chapter 1: What Is Query Store?; Query Store Usefulness; Baselining Performance; What Is a Baseline?; How Query Store Provides a Baseline; Catalog Views; Stabilizing Performance; Troubleshooting Without Query Store Techniques; SQL Server Profiler; SQL Server Profiler Concepts; SQL Server Profiler Event Classes Related to Performance; Server-Side Traces; Disadvantages of SQL Server Profiler or Server-Side Traces over Query Store; Extended Events; Extended Events Concepts Disadvantages of Extended Events over Query StoreDisadvantage of SQL Server Profiler and Server-Side Traces over Extended Events; Lightweight Show Plan Trace Flag; sys.dm_exec_query_plan_stats; DMVs; Disadvantages of DMVs; sp_whoisactive; Wait Statistics; Stabilizing Performance Before Query Store Techniques; Plan Guides/USE PLAN Hint; Updating Statistics; Recompiling Stored Procedures; Removing Plans from the Plan Cache; Query Store: The Game Changer; What Information Is Gathered; What Information Query Store Provides for Us: Use Cases; Automatic Plan Correction; Wait Statistics; Conclusion Chapter 2: Overview and Architecture of the Query StoreHow Query Store Works; Collecting Query and Plan Information; Collecting Query Runtime Information and Wait Statistics; General Notes on Data Collection; The Data Collected by Query Store; Query and Query Plan Information; Runtime Information; Wait Statistics; Information About the Query Store; Summary; Chapter 3: Configuring Query Store; Query Store Defaults; Configuration Options; OPERATION_MODE; CLEANUP_POLICY (STALE_QUERY_THRESHOLD_DAYS); DATA_FLUSH_INTERVAL_SECONDS; MAX_STORAGE_SIZE_MB; INTERVAL_LENGTH_MINUTES SIZE_BASED_CLEANUP_MODEQUERY_STORE_CAPTURE_MODE; MAX_PLANS_PER_QUERY; WAIT_STATISTICS_CAPTURE_MODE; Changing Configuration Using the GUI; Query Store Configuration Catalog View; Query Store Configuration Best Practices; Parameterization and Query Store; Impact of "Drop and Create" vs. "Alter"; Impact of Database Renaming; Reducing Recovery Times with Trace Flags; Query Store and Memory-Optimized Tables; Configuring Query Store for Natively Compiled Stored Procedures; Enabling and Disabling Automatic Plan Regression Correction (APRC); Maintaining Query Store Monitoring Desired vs. Actual StateQuery Store Read-Only States; How to Fix Query Store in Error State; Monitoring Space Usage; How to Clear Query Store; Failed Plan Forcing; Removing Plans and Queries; Reset Statistics for a Plan; Conclusion; Chapter 4: Standard Query Store Reports; Regressed Queries Report; Overall Resource Consumption Report; Top Resource Consuming Queries Report; Queries with Forced Plan Report; Queries with High Variation Report; Query Wait Statistics Report; Tracked Queries Report; Conclusion; Chapter 5: Query Store Catalog Views; sys.database_query_store_options
• Publisher Details: Berkeley, CA : Apress
• Publication Date: 2019
• Extent: 1 online resource (224 pages)
• Subjects: 005.75/85; Database management; Querying (Computer science); Database management; Querying (Computer science); Electronic books
• Languages: English
• ISBNs: 9781484250044; 1484250044
• Related ISBNs: 9781484250037
• Notes: Note: Print version record.
• 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.