References > Aliases > Understand the AppInsight for SQL details view

Understand the AppInsight for SQL details view

The AppInsight for SQL Details view is the equivalent of the Application Details view of a traditional SAM application; however, there are some notable differences:

  • Details view: Unlike a traditional Application Details view, the AppInsight for SQL Details view is comprised of two tabs, or sub-views, that host a variety of resources and information:
    • Summary tab: This view displays an informative summary about the current SQL instance.



    • Queries tab: This view displays details about the most expensive queries running across all databases on the current SQL instance.
    • Database Details view: This view displays details about the selected database.
    • Performance Counter Details view: This view displays details about the selected performance counter.

From here, you can select from the drop down menu and choose to display different amounts of data based on a time range, as shown below:

Editing Resources

Both the titles and subtitles of each resource can be changed by clicking Edit in the upper right-hand corner of any resource, and then clicking Submit.

The time and date displayed at the top of each resource (where applicable) shows the range of data currently loaded into the resource. This, along with the Sample Interval Range, can be changed by clicking Edit from within the resource.

Additionally, certain resources will allow you to add and remove component monitors from the resource. You can do this by clicking Edit and then checking the component monitors you want to keep.

Pertinent data for each resource is grouped together by default.