Use this Knowledge Script to monitor the number of site collections on each SharePoint content database in the server farm. This Knowledge Script raises an event when the number of site collections on each content database exceeds the maximum threshold.
SharePoint Server: Database
The default interval for this script is every hour.
Set the following parameters as needed:
Description |
How to Set It |
---|---|
General Settings |
|
Job failure event notification |
|
Event severity when job fails |
Set the event severity level, from 1 to 40, to indicate the importance of an event in which the job fails to monitor the number of site collections for each SharePoint content database. The default is 5. |
Monitor Site Collection Count for Each Content Database |
|
Event Notification |
|
Raise event when site collection count for each content database exceeds the threshold? |
Select Yes to raise an event if the number of site collections on a content database exceeds the threshold you set. The default is Yes. |
Event severity when the site collection count exceeds the threshold |
Set the event severity level, from 1 to 40, to indicate the importance of an event in which the number of site collections on a content database exceeds the threshold you set. The default is 10. |
Threshold -- Maximum site collection count for each content database |
Specify the maximum number of site collections a content database can contain before an event is raised. The default is 2000. |
Data Collection |
|
Collect data for site collection count for each content database? |
Select Yes to collect data for the site collection count of each content database. The default is unselected. |