{"id":9,"date":"2011-06-20T13:20:55","date_gmt":"2011-06-20T13:20:55","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/20\/using-max_connections-variable\/"},"modified":"2011-06-20T13:20:55","modified_gmt":"2011-06-20T13:20:55","slug":"using-max_connections-variable","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/20\/using-max_connections-variable\/","title":{"rendered":"USING @@MAX_CONNECTIONS VARIABLE"},"content":{"rendered":"<p>@@MAX_CONNECTIONS Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured.<\/p>\n<p>Syntax:<\/p>\n<p><code><br \/>\nSELECT MAX_CONNECTIONS<br \/>\n<\/code><\/p>\n<p>Output for the Above query would give the following depending up on your server:<\/p>\n<p style=\"padding-left: 60px\"><a href=\"\/wp-content\/uploads\/2011\/06\/maxconnectionsresult.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28\" title=\"sqlmaxconnectionsresult\" src=\"\/wp-content\/uploads\/2011\/06\/maxconnectionsresult.png\" alt=\"\" width=\"149\" height=\"76\"><\/a><\/p>\n<p>Return Type of @@MAX_CONNECTIONS is integer<\/p>\n","protected":false},"excerpt":{"rendered":"<p>@@MAX_CONNECTIONS Returns the maximum number of simultaneous user connections allowed on an instance of SQL Server. The number returned is not necessarily the number currently configured. Syntax: SELECT MAX_CONNECTIONS Output for the Above query would give the following depending up on your server: Return Type of @@MAX_CONNECTIONS is integer<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3],"tags":[27,28,29,30,31],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-sql-server-variables","category-sqlserverpedia-syndication","tag-maxconnections","tag-maxconnections-global-variable-in-sql-server","tag-maxconnections-variable-in-sql-server","tag-need-of-maxconnections-variable-sql-server","tag-sql-server-system-variables-max_connections"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}