What are the System Data Collection Sets Predefined Inside SQL Server ?

During the installation, there are 3 System Data Collection are made available to DBAs. These to be later configured to monitor SQL Server. These cannot be deleted.

Disk Usage : Collects data about disk and log usage for all the databases installed on the system.

Server Activity : Collects resource usage statistics and performance data from the server and SQL Server.

Query Statistics : Collects query statistics, individual query text, query plans, and specific queries.



You May Interest

Generating Random Letters in MS SQL

Changing MS SQL Database Name with Query

What are Replication and Database Mirroring in SQL Server ?

What Have INCLUDED Columns With SQL Server Indexes ?

How is Change Tracking is Different From Change Data Capture ?