SQLDBA Interview Questions in CGI
- What is inline memory ? In which version they introduced ?
- Suppose blocking is happening for a database, how you find and fix the problem ?
- What is the main features of SQL 2016 features ?
- What is Deadlock and live lock? How will you go resolve this types of issues ?
- What monitoring tools, you will use in your environment ?
- what is the use of filesteam ? In what type of projects will implement this filestream technology ?
- We got a performance issue, your manager told to find the problem using perfmon. What Important counters you will use to run ?