June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
SQLOS Scheduler

SQL SERVER – SQLOS Scheduler and the Process States

September 14, 2020
Pinal Dave
SQL Server
CPU Scheduler, CPU Threads, SQL CPU, SQL Server, SQL Wait Stats

I strongly suggest that you first watch it before we continue on today’s topic of SQLOS Scheduler and the Process States.

Read More
Statistics from Query

SQL SERVER – Wait Statistics from Query Execution Plan

June 22, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Wait Stats, SSMS

Recently one of my clients asked if I know a way to find the Wait Statistics from the Query Execution Plan. Yes, there is a way to do it.

Read More
asynchronous load

SQL SERVER – QDS_LOADDB Wait and Asynchronous Load of Query Store

June 10, 2020
Pinal Dave
SQL Performance
Query Store, SQL Server, SQL Wait Stats

The client who has SQL Server 2017 faced a very high wait type of QDS_LOADDB. The way to fix it is to enable the Asynchronous Load of Query Store.

Read More
non-clustered-primary-key0

SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention Changing Primary Key to Non-Clustered

May 11, 2020
Pinal Dave
SQL Performance
oStress, Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Wait Stats, SSMS, Stress Testing

You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.

Read More
contention

SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention with OPTIMIZE_FOR_SEQUENTIAL_KEY

May 6, 2020
Pinal Dave
SQL Tips and Tricks
oStress, Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Server 2019, SQL Wait Stats, SSMS, Stress Testing

I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.

Read More
Last Page Insert

SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column

May 5, 2020
Pinal Dave
SQL Performance
oStress, Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Wait Stats, SSMS, Stress Testing

Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.

Read More
Insert Workload

SQL SERVER – Impact of Recovery Model on Insert Workload Stress Test and Wait Statistics

May 4, 2020
Pinal Dave
SQL Performance
Best Practices, Load Testing, oStress, Recovery Model, SQL Backup, SQL Download, SQL Log, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Wait Stats, SSMS, Stress Testing

Today we will talk about the Tecovery Model on Insert Workload Stress Test and Wait Statistics. I had earlier consulted for during Health Check.

Read More
Previous 1 2 3 4 5 … 13 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version