Use the SQL Server Profiler to capture all SQL activities.
Use a Dynamic Management View to analyze performance.
Use the Database Engine Tuning Advisor to analyze the workload.
Use Microsoft SQL Server Management Studio to analyze the SQL logs.
第1题:
You are evaluating a Windows Azure application. The application includes the following elements: - A web role that provides the ASP.NET user interface and business logic - A single SQL Azure database that contains all application data Each page must receive data from the business logic layer before returning results to the client. Traffic has increased significantly. The business logic is causing high CPU usage. You need to recommend an approach for scaling the application. What should you recommend?()
第2题:
You are planning the migration of an existing application to Windows Azure and SQL Azure. The current application includes reports that are hosted by SQL Server Reporting Services. You need to recommend an approach for migrating the reports. What should you recommend? ()
第3题:
windows Azure平台包含了()等重要组成部分。
第4题:
An on-premise .NET application uses an on-premise Microsoft SQL Server 2008 database. The existing compute infrastructure is insufficient to support peak loads. You plan to move only the compute-intensive component of the application into Windows Azure. The component requires access to the on-premise database. The on-premise database cannot be accessed from outside the network boundary. You need to recommend a database topology. What should you recommend?()
第5题:
You are designing a Windows Azure application that will store data. You have the following requirements: - The data storage system must support the storage of more than 500 GB of data. - Data retrieval must be possible from a large number of parallel threads without threads blocking each other. You need to recommend an approach for storing data. What should you recommend?()
第6题:
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?()
第7题:
You are designing an integration test plan for a Windows Azure .NET 3.5 application. You need to recommend a testing environment that allows developers to debug the application while accessing data in the cloud. What should you recommend?()
第8题:
在Windows Azure存储系统中,()类型提供了结构化的存储。
第9题:
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?()
第10题:
You are planning the deployment of a SQL Azure database. Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%. You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database. What should you recommend?()