• Article

Lesson 3: Monitoring a Data-tier Application

In this lesson, you will learn where to view information about the data-tier application (DAC) you deployed in the last lesson.

Note

Information about the DAC you deployed in the last lesson will not appear in the Utility Explorer until the data has been uploaded into the utility management data warehouse (UMDW). The default upload interval is 15 minutes.

Procedures

Viewing DAC properties in the Object Explorer details page

  1. In the SQL Server Management Studio Object Explorer pane, navigate to the node for the test instance where you deployed the DAC, then open the Management node under that instance and select the Data-tier Applications node.

  2. Review the information in the list view at the top of the Object Explorer Details pane. The DAC name, version, and description from the DAC project are displayed on this pane, along with the date the DAC was created.

  3. Select the row of the DAC data in the top of the Object Explorer details pane to see the data also presented in the lower part of the pane.

Viewing DAC resource utilization in the Utility Explorer details page

  1. Wait for the UMDW upload interval to expire.

  2. In the Management Studio Utility Explorer pane, select the Deployed Data-tier Applications node.

  3. Review the information in the list view at the top of the Utility Explorer Content pane. The information in the list view makes it easy to see if the CPU and file usage of the DAC complies with the overall site policies defined for the SQL ServerUtility.

  4. Select the row of the DAC in the top of the Utility Explorer Content pane to see more information about the DAC presented in the lower part of the tab.

    1. Select the CPU Utilization tab to view charts of CPU usage trends.

    2. Select the Storage Utilization tab to view usage details for all of the data and log files along with charts of file usage trends.

    3. Select the Policy Details tab to view the policies associated with the DAC.

    4. Select the Property Details tab to view properties such as collation and recovery model.

Next Steps

You have successfully viewed the information about the DAC you deployed in the previous lesson. Next, you will edit the DAC project. See Lesson 4: Editing a DAC in Visual Studio.