Valid 70-765 Dumps shared by ExamDiscuss.com for Helping Passing 70-765 Exam! ExamDiscuss.com now offer the newest 70-765 exam dumps, the ExamDiscuss.com 70-765 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-765 dumps with Test Engine here:
You deploy a Microsoft SQL Server instance to support a new application. The application uses the tempdb database maintain session state data. Users reports performance issues with the application. You observer performance problems immediately and begin troubleshooting. You observer numerous instances of the page PAGE_up and PAGEELATCH_EX wait events in the logs for the server. The resources for the description for the wait is 2:1:1.
Correct Answer: A
Note: PAGELATCH_EX occurs when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Exclusive mode. PAGELATCH_UP occurs when a task is waiting on a latch for a buffer that is not in an I/O request. The latch request is in Update mode. References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql?view=sql-server-2017