http://www.sqlservercentral.com/blogs/livingforsqlserver/2012/11/29/interview-questions-for-sql-server-performance-tuning-specialists/

Printed 2014/10/23 12:45AM

Interview questions for SQL Server Performance Tuning Specialists

By Ramkumar (LivingForSQLServer), 2012/11/29

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?

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.