-
Title
Information collected by SQL PI Change Tracking feature -
Description
What information is collected by Change Tracking, when enabling SQL PI extension?
-
Cause
Enabling SQL PI extension in Foglight for SQL Server allows tracking OS and Database changes.
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.
- Accounts once a day
- Database Configuration every hour
- Database Objects every hour
- Master Configuration every hour
- System Configuration every 15 minutes
-
Resolution
Main Categories and Sub-Categories for Change Tracking (SQL PI extension is enabled):
SQL Server level
Accounts
- User Accounts
Database Configuration
- File Group
- File
Database Objects
- Schema
- Table
- Database
- Index
- Partition Schema
- Partition Function
- Constraint
- Table Partition
Execution Plan
- Execution Plan
Master configuration of the instance
- Version Info
- Instance Configuration
- SQL server Version
- SQL Edition
- SP Version
- Product Version
- SQL Server collation
- Log Shipping
- Mirroring
- Cluster
- Replication
- HADR Enabled
Database Configuration
- Disk Size Growth
Database Properties (obtained using DATABASEPROPERTYEX via the Database Properties collection)
- Database ID
- Database Name
- Is ANSI Null Default
- Is ANSI Nulls enabled
- Is ANSI Padding enabled
- Is ANSI Warnings enabled
- Is Arithmetic Abort enabled
- Is Auto Close enabled
- Is Auto Create Statistics
- Is Auto Shrink
- Is Auto Update Statistics
- Is Close Cursors on Commit Enabled
- Collation
- Concatenate Null Yields Null
- Is Numeric Round-Abort Enabled
- Is Quoted Identifiers Enabled
- Recovery model
- Is Recursive Triggers Enabled
- Page Verify Option Described
- Database State
- Is Full Text Enabled
- Is Local Cursors Default
- Is Merge Published
- Is Subscribed
- Update Ability
- User Access
- Database Recovery Model
System changes collected by PI Change Tracking are:
System Configuration
- Amount of RAM
- Windows Version
- NT Version
- Server Name
- CPU Count
- CPU type
WMI OS Data collected by PI Change Tracking
- Network Interface
- Disk
- Swap Space Allocation