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

What is Blocking in SQL Server ?

How is Deadlock Different From a Blocking Situation in SQL Server ...

What are the Different Recovery Models Inside SQL Server ?

General Information List of All Allowed Databases in MS SQL Serve ...

What is the Difference Between DB Mirroring and Log Shipping in S ...