单项选择题
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. -
单项选择题
You are designing a Windows Azure application. Corporate policy dictates that you must retain all application logs. You need to recommend an approach for complying with the corporate policy. What should you recommend？（）
A. Perform on-demand transfers.
B. Configure scheduled transfers.
C. Configure a diagnostic trace listener.
D. Increase the diagnostics buffer quotas.
