May 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
Expensive Queries

SQL SERVER – List Expensive Queries – Updated March 2021

March 17, 2021
Pinal Dave
SQL Performance
SQL CPU, SQL Memory, SQL Scripts, SQL Server

One of my favorite scripts which I discuss with my client during Comprehensive Database Performance Health Check is how to get a list of Expensive Queries.

Read More
RESOURCE SEMAPHORE

SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL

March 2, 2021
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, Memory Grant, SQL CPU, SQL Memory, SQL Server, SQL Wait Stats

RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.

Read More
Remove Unused

SQL SERVER – Remove Unused Cache MARK_IN_USE_FOR_REMOVAL

January 8, 2021
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Memory, SQL Scripts, SQL Server

Today’s topic is very unique and one should not try it out without the proper consultation of an expert. How to Remove Unused Cache MARK_IN_USE_FOR_REMOVAL. 

Read More
spinlock

SQL SERVER – What is Spinlock?

September 16, 2020
Pinal Dave
SQL Tips and Tricks
SQL Latch, SQL Memory, SQL Server, SQL Server DBCC, SQL Spinlock

After reading both the blog post, I got another question from my client on What is Spinlock? Let us discuss today What is Spinlock. 

Read More
what is latch

SQL SERVER – What is Latch?

September 15, 2020
Pinal Dave
SQL
SQL Latch, SQL Memory, SQL Server, SQL Server DBCC

Earlier I wrote about SQL SERVER – SQLOS Scheduler and the Process States, lots of people liked the blog post and asked me another question – What is Latch?

Read More
Table Variable Stored

Where are Table Variables Stored? – SQL in Sixty Seconds #095

August 6, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Memory, SQL Performance, SQL Scripts, SQL Server, SQL Variable, Temp Table

A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,

Read More
Lock Pages in Memory

SQL SERVER – sys.dm_os_sys_info and Lock Pages in Memory

June 19, 2020
Pinal Dave
SQL Performance
SQL Memory, SQL Server, SQL Server Security, Starting SQL

This time DBA called me as he wanted to know if how to confirm that lock pages in memory is enabled for the SQL Server instance.

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

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

Go to mobile version