{"id":38,"date":"2006-06-14T12:51:07","date_gmt":"2006-06-14T10:51:07","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=38"},"modified":"2006-12-28T16:11:21","modified_gmt":"2006-12-28T14:11:21","slug":"perf-threshold-sms-sql-connections-500-over-2-hours","status":"publish","type":"post","link":"https:\/\/contoso.se\/blog\/?p=38","title":{"rendered":"Perf Threshold: SMS SQL Connections > 500 over 2 hours"},"content":{"rendered":"<p><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\">Do you recognize this alert?\u00c2\u00a0<\/span><\/p>\n<p><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\" \/><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\"><code><span style=\"font-size: 10pt\">SMS_SERVER - SMS 2003 Perf Threshold: SMS SQL Connections > 500 over 2 hours.<\/span><\/code><\/span><span style=\"font-size: 10pt; font-family: 'Courier New'\"><br \/>\n<code>SQLServer:General Statistics: User Connections: value = 300,5. The average over last 2 samples is 300.5.\u00c2\u00a0<\/code><\/span><\/p>\n<p><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\">The cause might be that the MOM agent has a large number of connection from sqldmo_%\/sqldmo_(number) to the database. <\/span><span lang=\"SV\" style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'; mso-ansi-language: SV\">The agent not always disconnect. <\/span><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\">Try to restart you mom agent, you can do that by the following command\u00c2\u00a0<\/span><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\"> <\/span><\/p>\n<p><span style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'\" \/><code><span lang=\"SV\" style=\"font-size: 10pt; mso-ansi-language: SV\">net stop mom<\/span><\/code><span lang=\"SV\" style=\"font-size: 10pt; font-family: 'Courier New'; mso-ansi-language: SV\"><br \/>\n<code>net start mom<\/code><\/span><span lang=\"SV\" style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'; mso-ansi-language: SV\">\u00c2\u00a0<\/span><span lang=\"SV\" style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'; mso-ansi-language: SV\" \/><span lang=\"SV\" style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'; mso-ansi-language: SV\"> <\/span><span lang=\"SV\" style=\"font-size: 11pt; font-family: 'Verdana','sans-serif'; mso-ansi-language: SV\">\u00c2\u00a0<\/p>\n<p><\/span>\u00c2\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you recognize this alert?\u00c2\u00a0 SMS_SERVER &#8211; SMS 2003 Perf Threshold: SMS SQL Connections > 500 over 2 hours. SQLServer:General Statistics: User Connections: value = 300,5. The average over last 2 samples is 300.5.\u00c2\u00a0 The cause might be that the MOM agent has a large number of connection from sqldmo_%\/sqldmo_(number) to the database. The agent &hellip; <a href=\"https:\/\/contoso.se\/blog\/?p=38\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/38"}],"collection":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=38"}],"version-history":[{"count":0,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions"}],"wp:attachment":[{"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}