SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Interview questions for SQL Server Performance Tuning Specialists

If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.

I have converted some of my learning as questions and posted it here. These are not necessarily be the interview questions.

I am sure that this will help us to assess our knowledge and hope this will lead to good learning for thirsty minds.


How LRU K algorithm is associated with SQL Server?

What is Halloween effect?

What is the impact of running SELECT statement in Repeatable Read and Read committed isolation levels?

What is thread starvation in SQL Server?

What is the side effect of using /3GB switch on 32 bit systems?

What is the shortcut key to invoke Task manager? :-)

What is the formula that SQL Server uses to calculate max worker threads?

Who are the authors of SQL Server 2008 Internals book? (The easier one)

Who is Ken Henderson?  How he is associated with SQL Server community? (I could not avoid this question)

What are the top 2 DMVs you would use first while analyzing performance issue of SQL Server 2008 Instance?

What is the difference between preemptive and non-preemptive scheduling?

What is the difference between SQLIO and SQLIOSim?

What are the possible spool operators you can see in SQL Server execution plan?

How merry-go-round scanning is associated with SQL Server?

How pruning heuristics algorithm is associated with SQL Server?



I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer


Posted by thirumurugan_888 on 3 December 2012

Hi Ram,

I followed your blog daily.this question very useful to me.



Posted by Ganeshkumar005 on 4 December 2012

where are the answers?

Posted by Ramkumar (LivingForSQLServer) on 4 December 2012


Just google it if you are thirsty to learn. You can find answers for most of the questions in few seconds. some may consume more time but will take you to great learning experience for sure.

Happy reading !!!

Leave a Comment

Please register or log in to leave a comment.