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.)
A.
Use Dynamic Management Views to analyze performance issues.
B.
Decrease the connection timeout in the database connection string.
C.
Make sure the application is closing database connections that are not needed.
D.
Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.
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.