Use the XenDesktop_DatabaseActivity Knowledge Script to Monitors the activity of the databases associated with the Broker, Host, and Machine Creation XenDesktop services.
This script raises an event if the average transaction time, the average transaction rate, or the transaction error rate exceeds the thresholds you set for those three services. You can also choose to collect data on those metrics.
Citrix XenDesktop or XenApp site object
The default schedule is every 15 minutes.
Set the following parameters on the Values tab as needed:
|
Description |
How to Set It |
|---|---|
|
General Settings |
|
|
Job failure event notification |
|
|
Event severity when job fails |
Set the severity level, from 1 to 40, to indicate the importance of an event in which the DatabaseActivity job fails. The default is 5. |
|
Monitor Broker Service |
|
|
Event Notification |
|
|
Raise event if average transaction time exceeds threshold? |
Select Yes to raise an event when the average transaction time for the Broker service exceeds threshold. The default is Yes. |
|
Threshold - Maximum average transaction time |
Specify the maximum average transaction time for the Broker service that can exist before an event is raised. The default is 5000 milliseconds. |
|
Event severity when average transaction time is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the average transaction time for the Broker service is exceeded. The default is 10. |
|
Raise event if transaction rate exceeds threshold? |
Select Yes to raise an event when the transaction rate for the Broker service exceeds threshold. The default is Yes. |
|
Threshold - Maximum transaction rate |
Specify the maximum transaction rate for the Broker service that can exist before an event is raised. The default is 20 transactions per second. |
|
Event severity when transaction rate is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the transaction rate for the Broker service is exceeded. The default is 10. |
|
Raise event if transaction error rate exceeds threshold? |
Select Yes to raise an event when the transaction error rate for the Broker service exceeds threshold. The default is Yes. |
|
Threshold - Maximum transaction error rate |
Specify the maximum transaction error rate for the Broker service that can exist before an event is raised. The default is 0 errors per seconds. |
|
Event severity when transaction error rate is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the transaction error rate for the Broker service is exceeded. The default is 10. |
|
Data Collection |
|
|
Collect data for Broker service? |
Select Yes to collect data for the Broker service. The default is unselected. |
|
Monitor Host Service |
|
|
Event Notification |
|
|
Raise event if average transaction time exceeds threshold? |
Select Yes to raise an event when the average transaction time for the Host service exceeds threshold. The default is Yes. |
|
Threshold - Maximum average transaction time |
Specify the maximum average transaction time for the Host service that can exist before an event is raised. The default is 5000 milliseconds. |
|
Event severity when average transaction time is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the average transaction time for the Host service is exceeded. The default is 10. |
|
Raise event if transaction rate exceeds threshold? |
Select Yes to raise an event when the transaction rate for the Host service exceeds threshold. The default is Yes. |
|
Threshold - Maximum transaction rate |
Specify the maximum transaction rate for the Host service that can exist before an event is raised. The default is 20 transactions per second. |
|
Event severity when transaction rate is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the transaction rate for the Host service is exceeded. The default is 10. |
|
Raise event if transaction error rate exceeds threshold? |
Select Yes to raise an event when the transaction error rate for the Host service exceeds threshold. The default is Yes. |
|
Threshold - Maximum transaction error rate |
Specify the maximum transaction error rate for the Host service that can exist before an event is raised. The default is 0 errors per seconds. |
|
Event severity when transaction error rate is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the transaction error rate for the Host service is exceeded. The default is 10. |
|
Data Collection |
|
|
Collect data for Host service? |
Select Yes to collect data for the Host service. The default is unselected. |
|
Monitor Machine Creation Service |
|
|
Event Notification |
|
|
Raise event if average transaction time exceeds threshold? |
Select Yes to raise an event when the average transaction time for the Machine Creation service exceeds threshold. The default is Yes. |
|
Threshold - Maximum average transaction time |
Specify the maximum average transaction time for the Machine Creation service that can exist before an event is raised. The default is 5000 milliseconds. |
|
Event severity when average transaction time is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the average transaction time for the Machine Creation service is exceeded. The default is 10. |
|
Raise event if transaction rate exceeds threshold? |
Select Yes to raise an event when the transaction rate for the Machine Creation service exceeds threshold. The default is Yes. |
|
Threshold - Maximum transaction rate |
Specify the maximum transaction rate for the Machine Creation service that can exist before an event is raised. The default is 20 transactions per second. |
|
Event severity when transaction rate is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the transaction rate for the Machine Creation service is exceeded. The default is 10. |
|
Raise event if transaction error rate exceeds threshold? |
Select Yes to raise an event when the transaction error rate for the Machine Creation service exceeds threshold. The default is Yes. |
|
Threshold - Maximum transaction error rate |
Specify the maximum transaction error rate for the Machine Creation service that can exist before an event is raised. The default is 0 errors per seconds. |
|
Event severity when transaction error rate is exceeded |
Set the event severity level, from 1 to 40, to indicate the importance of the event in which the transaction error rate for the Machine Creation service is exceeded. The default is 10. |
|
Data Collection |
|
|
Collect data for Machine Creation service? |
Select Yes to collect data for the Machine Creation service. The default is unselected. |