While dealing with performance problems, database professionals tend to focus on technical aspects of the system such as resource queues, resource utilization and so on.
SQL Server introduced a component called data collector that collects different sets of data related to performance and other from different sources and store it in a relational warehouse known as management data warehouse.
The data collector installs three system data collection sets that collect disk usage, server activity, and query statics information.
The data collection platform helps you automate the collection of performance and other information and also analyze it graphically with preconfigured reports.
SQL Server introduced a component called data collector that collects different sets of data related to performance and other from different sources and store it in a relational warehouse known as management data warehouse.
The data collector installs three system data collection sets that collect disk usage, server activity, and query statics information.
The data collection platform helps you automate the collection of performance and other information and also analyze it graphically with preconfigured reports.
