70-583 · Question #64
A Windows Azure application connects to a SQL Azure database. Connections to the database are being dropped due to throttling. You need to recommend an approach for identifying the root cause of the…
The correct answer is A. Use Dynamic Management Views to analyze performance issues. C. Make sure the application is closing database connections that are not needed. Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. There are two types of dynamic management views and functions: Server-scoped dynamic management views and…
Question
A Windows Azure application connects to a SQL Azure database. Connections to the database are being dropped due to throttling. You need to recommend an approach for identifying the root cause of the problem. Which two actions should you recommend? (Each correct answer presents part of the solution. Choose two.)
Options
- AUse Dynamic Management Views to analyze performance issues.
- BDecrease the connection timeout in the database connection string.
- CMake sure the application is closing database connections that are not needed.
- DUse SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.
How the community answered
(54 responses)- A70% (38)
- B11% (6)
- D19% (10)
Explanation
Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. There are two types of dynamic management views and functions: Server-scoped dynamic management views and functions. These require VIEW SERVER STATE permission on the server. Database-scoped dynamic management views and functions. These require VIEW DATABASE STATE permission on the database.
Topics
Community Discussion
No community discussion yet for this question.