-
Notifications
You must be signed in to change notification settings - Fork 10
Disable System Database Collection
| Previous Setup MDW Job Proxy | Manual Configuration | Configure Policy Based Management Next |
|---|
FineBuild can disable System Database query statistics data collection.
By default the MDW data collection process will include data for the system databases. The information for the system databases is of little use for performance tuning purposes and requires a meaningful amount of disk space to store it. Microsoft have documented how to disable the collection process for the System Databases in KB2793580.
FineBuild will automatically perform the steps given in KB2793580 to disable System Database Collection.
The following steps show what you would have to do for manual Disable System Database Collection. FineBuild does all of this work for you automatically.
Perform the process given in KB2793580.
Copyright FineBuild Team © 2014 - 2021. License and Acknowledgements
| Previous Setup MDW Job Proxy | Top | Configure Policy Based Management Next |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP