From past few weeks, I have been taking interview for Sr. SQL DBA position in my team. What I found is, even candidates saying that they have expertise
There are many tools in market that can help you troubleshoot in specific situations. My personal favorite for finding out issue with SQL Server is SQL-Server-First-Responder-Kit created by
Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait stats on server, I found ‘LCK_M_X’ wait to be most prominent wait on