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?
SQL SERVER – 3 Different Usage of DBCC SQLPERF
Have you ever wondered what does DBCC SQLPERF do in SQL Server?