单项选择题
You are analyzing the performance of a SQL Azure database.
You need to recommend an approach for identifying the indexes that should be added to improve database performance.
What should you recommend？（）
A. Use SQL Server Profiler to identify missing indexes.
B. Use the Database Engine Tuning Advisor to identify missing indexes.
C. Use a Dynamic Management View to analyze query plans.
D. Use a DynamicManagement View to ascertain the number of pending I/O requests.
相关考题
-
单项选择题
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. -
多项选择题
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？（）
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. -
单项选择题
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）
A. Use a Dynamic Management View to check for locks.
B. Use a Dynamic Management View to check for blocked queries.
C. Use a Dynamic Management View to check for long-running queries.
D. Use a Dynamic Management View to check the size and maximum size of the database.
