Database Developer Question:
Download Questions 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;

Download Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Explain me what is a column in a Table?Please explain what are string functions in SQL?