Database Developer Question:
Download Job Interview Questions and Answers PDF
Tell me what are DMVs?
Answer:
Dynamic management views (DMVs) and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance; that is, they let you see what is going on inside SQL Server. They were introduced in SQL Server 2005 as an alternative to system tables. One example is viewing operating system wait statistics via this query:
SELECT * FROM sys.dm_os_wait_stats;
Another example is examining current sessions, much like the sp_who2 command:
SELECT * FROM sys.dm_exec_sessions;
SELECT * FROM sys.dm_os_wait_stats;
Another example is examining current sessions, much like the sp_who2 command:
SELECT * FROM sys.dm_exec_sessions;
Download Database Developer Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain me what is a column in a Table? | Please explain what are string functions in SQL? |