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.
SQL SERVER – RESOURCE SEMAPHORE and THREADPOOL
RESOURCE SEMAPHORE and THREADPOOL. They are indeed very troublemaking wait statistics and they indeed talk about Memory and CPU issues.
SQL SERVER – Remove Unused Cache MARK_IN_USE_FOR_REMOVAL
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.
SQL SERVER – What is 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.
SQL SERVER – What is Latch?
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?
Where are Table Variables Stored? – SQL in Sixty Seconds #095
A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
SQL SERVER – sys.dm_os_sys_info and Lock Pages in Memory
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.