A Windows Azure application connects to a SQL Azure database.
The database size has increased significantly.
Some queries in the application no longer complete.
You need to recommend an approach for identifying queries that do not complete.
What should you recommend?
A.
Use the SQL Server Profiler to capture all SQL activities.
B.
Use a Dynamic Management View to analyze performance.
C.
Use the Database Engine Tuning Advisor to analyze the workload.
D.
Use Microsoft SQL Server Management Studio to analyze the SQL logs.
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.