We use cookies to try and give you a better experience in Freshdesk.
You can learn more about what kind of cookies we use, why, and how from our Privacy policy. If you hate cookies, or are just on a diet, you can disable them altogether too. Just note that the Freshdesk service is pretty big on some cookies (we love the choco-chip ones), and some portions of Freshdesk may not work properly if you disable cookies.
We’ll also assume you agree to the way we use cookies and are ok with it as described in our Privacy policy, unless you choose to disable them altogether through your browser.
"The performance counter "Performance SQL Server\SQLServer:General Statistics Logins" (SQLServer:General Statistics\Logins/sec) on host MyServer exceeded the threshold of 2, the current values are:
Average: 3
Minimum: 3
Maximum: 4"
I receive a lot of emails with similar "performance counter" messages where do I set these thresholds?
0 Votes
Ingmar Koecher posted almost 7 years ago Admin Best Answer
All those thresholds are set in System Health packages which contain performance objects. The quickest way to find those packages is to do the following in the management console:
The event alert itself includes the name of the package (Performance SQL Server in this case) and the name of the counter SQLServer:General Statistics Logins which exceeded the threshold. So for this example, expand the Performance SQL Server package, click on Performance / SNMP and finally double-click on the SQLServer:General Statistics Logins counter. You can change the threshold on the Alert tab. Save the configuration when done.
Depending on your setup you may also need to click Save & Deploy or push the configuration to the remote host(s).
I hope this explains, let us know if you have more questions.
0 Votes
2 Comments
Ingmar Koecher posted almost 7 years ago
Thanks! That knowledge should allow me to do the rest of the fine tuning I needed.
0 Votes
Ingmar Koecher posted almost 7 years ago Admin Answer
All those thresholds are set in System Health packages which contain performance objects. The quickest way to find those packages is to do the following in the management console:
The event alert itself includes the name of the package (Performance SQL Server in this case) and the name of the counter SQLServer:General Statistics Logins which exceeded the threshold. So for this example, expand the Performance SQL Server package, click on Performance / SNMP and finally double-click on the SQLServer:General Statistics Logins counter. You can change the threshold on the Alert tab. Save the configuration when done.
Depending on your setup you may also need to click Save & Deploy or push the configuration to the remote host(s).
I hope this explains, let us know if you have more questions.
0 Votes
Login or Sign up to post a comment