SQL Server Performance Event Monitor
Monitor Key SQL Server Performance Metrics
About the SQL Server Performance Event Monitor

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.

SQL Server Performance Event Monitor Settings

To begin, enter the name of the instance you're monitoring under "Instance Name".

Instance Name Field

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.

Page Lookups Counter

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.

Page Reads Counter

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.

Page Reads Counter

Next, indicate the number of active transactions that will trigger each level of alert.

Active Transactions Counter

You can also set alerting parameters for the number of transactions started per second.

Transactions Per Second Counter

The same option is also available for the number of logins started per second.

Logins Per Second Counter

You can also monitor logouts per second in the same way.

Logouts Per Second Counter

The next option lets you choose the number of user connections per second that will trigger each level of alert.

User Connections Per Second Counter

The option after that alerts based on the average amount of wait time (in milliseconds) for each lock request that resulted in a wait.

Lock Wait Time Counter

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.

Lock Request Per Second Counter

The next option counts and alerts based on the number of SQL compilations per second.

Compilations Per Second Counter

Similarly, the option to alert based on "MSSQL:SQL Statistics: SQL Re-Compilations/sec" alerts based on the number of re-compilations per second.

Re-Compilations Per Second Counter

More Options

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.

More Options

Summary

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