The SQL Server Performance Event Monitor watches SQL Server performance counters such as the number of active transactions. It alerts based on the thresholds you set when configuring the monitor. This tutorial will teach you how to begin monitoring SQL Server performance with FrameFlow.
To begin, enter the name of the instance you're monitoring under "Instance Name".
The first option alerts based on the number of requests per second to find a page in the buffer pool. You can set alert levels for values that are greater or less than expected.
The next option indicates and alerts on the number of physical database page reads that are issued per second. This statistic displays the total number of physical page reads across all databases.
The third option indicates the number of physical database page writes that are issued per second. Set alerting levels for values that are greater or less than the values expected.
Next, indicate the number of active transactions that will trigger each level of alert.
You can also set alerting parameters for the number of transactions started per second.
The same option is also available for the number of logins started per second.
You can also monitor logouts per second in the same way.
The next option lets you choose the number of user connections per second that will trigger each level of alert.
The option after that alerts based on the average amount of wait time (in milliseconds) for each lock request that resulted in a wait.
The option to alert based on "MSSQL:Locks: Number of Deadlocks/sec" controls alerting parameters for the number of lock requests per second that resulted in a deadlock.
The next option counts and alerts based on the number of SQL compilations per second.
Similarly, the option to alert based on "MSSQL:SQL Statistics: SQL Re-Compilations/sec" alerts based on the number of re-compilations per second.
Under "Options", choose what level of alert you want to receive if the event monitor cannot connect to your device. Then, choose a level of alert to receive if counters are missing when the event monitor runs.
This tutorial taught you how to configure a SQL Server Performance Event Monitor. Make sure to check out our SQL Server Event Monitor for more SQL Server compatibility. To view more documentation about this event monitor, view its Technical Resources page.More Tutorials