70-583 · Question #65
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…
The correct answer is B. Use a Dynamic Management View to analyze performance. 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. 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?
Options
- AUse the SQL Server Profiler to capture all SQL activities.
- BUse a Dynamic Management View to analyze performance.
- CUse the Database Engine Tuning Advisor to analyze the workload.
- DUse Microsoft SQL Server Management Studio to analyze the SQL logs.
How the community answered
(42 responses)- A5% (2)
- B83% (35)
- C2% (1)
- D10% (4)
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.