单项选择题
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 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 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?()