How to you access Change Tracking in SQL Performance Investigator?
What is Change Tracking used for in SQL PI?
This video below covers how to view Change Tracking included in SQL Performance Investigator (SQL PI) for SQL Server, Oracle, and SQL Server Analysis Services (SSAS).
Change Tracking is an integrated monitoring mechanism. It periodically tracks changes in environments and activity that can potentially influence system performance and enables the user to view correlation between occurrences of changes and SQL Server's activity and behavior patterns.
Use the Categories filter mechanism to refine the set of displayed change tracking occurrences. These categories are displayed on the right-hand side of the pane.
In SQL Server, these categories include
In Oracle, the change tracking categories include
For SQL Server Analysis Services, the change tracking categories include
How to access the Change Tracking Dashboard
Note: selecting a specific dimension (such as Databases, Files, or Disks) from the Performance Tree will display only the changes made in this specific dimension. The instance view displays all changes made
In the panel that appears, colored dots are superimposed over the Resource Consumption chart.
Each dot corresponds to a change tracking category. These can be selected from the list on the right side of the panel with a count of the number of this event logged during the selected time range.
In the panel below, there is a list of all of the changes recorded by the change tracking mechanism during the time period selected. Each event includes the time and date, a description of the event, the category, and may also include the user the event was attributed to for events such as creating a new database table.
By clicking the Add Change button, a user defined change can be added. Enter the date and a brief description of the event to add the new change to the panel. Then click the OK button.
Change tracking collections run at different frequencies, depending on the change tracking category. For example by default, account changes are checked every 24 hours, while database objects are checked once every hour. This means that if a users makes any change to a user account, it would not be visible on the data on PI dashboard until up to 24 hours later. These durations are controlled by hidden agent status property settings and can be change using a groovy script in the Foglight Script console.