Microsoft
70-459 · Question #112
You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues. You want to…
The correct answer is D. sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_query_text. sys.dm_exec_requests Returns information about each request that is executing within SQL Server. sys.dm_exec_sessions Returns one row per authenticated session on SQLServer. sys.dm_exec_sessions is a server- scope view that shows information about all active user connections…
Administer SQL Server
Question
You administer a SQL Server 2014 instance. Users report that the SQL Server has seemed slow today. A large database was being restored for much of the day, which could be causing issues. You want to write a query of the system views that will report the following: - Number of users that have aconnection to the server - Whether a user's connection is active - Whether any connections are blocked - What queries are being executed - Whether the database restore is still executing and, if it is, what percentage of the restore is complete Which system objects should you use in your query to best achieve this task?
Options
- Asys.dm_exec_requests, sys.dm_exec_sessions, sys.objects
- Bsys.dm_exec_sessions, sys.dm_exec_query_stats, sys.dm_exec_query_text,sys.objects
- Csys.sysprocesses, sys.dm_exec_query_text, sys.objects
- Dsys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_query_text
How the community answered
(28 responses)- A7% (2)
- B4% (1)
- C14% (4)
- D75% (21)
Explanation
- sys.dm_exec_requests Returns information about each request that is executing within SQL Server. * sys.dm_exec_sessions Returns one row per authenticated session on SQLServer. sys.dm_exec_sessions is a server- scope view that shows information about all active user connections and internal tasks. This information includes client version, client program name, client login time, login user, current session setting, and more. * sys.dm_exec_query_text Returns the text of the SQL batch that is identified by the specified sql_handle. sys.dm_exec_requests (Transact-SQL) sys.dm_exec_sessions (Transact-SQL)
Topics
#DMVs#sys.dm_exec_requests#sys.dm_exec_sessions#restore progress monitoring
Community Discussion
No community discussion yet for this question.