Valid 70-764 Dumps shared by PrepAwayExam.com for Helping Passing 70-764 Exam! PrepAwayExam.com now offer the newest 70-764 exam dumps, the PrepAwayExam.com 70-764 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 70-764 dumps with Test Engine here:
You have a database named DB1. Users report that a database application that updates the data in DB1 is unresponsive. You need to identify which process prevents the application from responding. What should you do?
Correct Answer: B
Explanation/Reference: Explanation: Sys.dm_exec_session_wait_stats returns information about all the waits encountered by threads that executed for each session. You can use this view to diagnose performance issues with the SQL Server session and also with specific queries and batches. References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management- views/sys-dm-exec-session-wait-stats-transact-sql