Microsoft
70-473 · Question #3
You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine. The application experiences performance issues, which you suspect are related to the connection
The correct answer is D. sys.dm_exec_sessions. https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/10/08/connection-pooling-for-the-sql- server-
Monitor and manage an Azure data platform solution
Question
You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine. The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections. You need to identify whether the performance issues are related to the connection pooling. Which dynamic management view should you query?
Options
- Asys.dm_os_memory_pools
- Bsys.dm_exec_requests
- Csys.dm_exec_connections
- Dsys.dm_exec_sessions
How the community answered
(29 responses)- A3% (1)
- B10% (3)
- C7% (2)
- D79% (23)
Explanation
https://blogs.msdn.microsoft.com/sql_pfe_blog/2013/10/08/connection-pooling-for-the-sql- server-
Topics
#SQL Server performance#Connection pooling#DMV#sys.dm_exec_sessions
Community Discussion
No community discussion yet for this question.