{"id":2439,"date":"2014-06-11T11:00:03","date_gmt":"2014-06-11T15:00:03","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=2439"},"modified":"2014-11-13T13:37:54","modified_gmt":"2014-11-13T18:37:54","slug":"server-configuration-page","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/","title":{"rendered":"The Server Configuration Page"},"content":{"rendered":"<div>\n<h3>Introduction<\/h3>\n<p>\nThere is one page type that is quite unique. It is page type 14. Page type 14 is in fact so unique, that there is only one page of this type per SQL Server instance. There seems to be no official name known for this page type, so I will just call it the \"Server Configuration Page\".\n<\/p>\n<h3>The Server Configuration Page<\/h3>\n<p>\nThe Server Configuration Page is always stored in page 10 of the first data file in the <span class=\"tt\">master<\/span> database. Before we talk about what is stored in this page, let us take a quick peek at one.\n<\/p>\n<div>\n[sql]\nUSE master;<br \/>\nGO<br \/>\nDBCC TRACEON(3604);<br \/>\nDBCC PAGE(0,1,10,3);<br \/>\n[\/sql]\n<\/div>\n<p>\nAs with the other page types, using <span class=\"tt\">DBCC PAGE<\/span> with mode 3 returns a quite readable output:\n<\/p>\n<p>\n<a href=\"http:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg\" alt=\"The Server Configuration Page\" title=\"The Server Configuration Page\" width=\"768\" height=\"513\" class=\"aligncenter size-full wp-image-2440\" srcset=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg 768w, https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page-300x200.jpg 300w, https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page-150x100.jpg 150w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a>\n<\/p>\n<p>\nThe complete output on my demo instance looks like this:\n<\/p>\n<div>\n[sourcecode]\ncconfsz = 8                         cmajor = 10                         cminor = 0<br \/>\ncrevision = 16                      cbootsource = 2                     crecinterval = 0<br \/>\nccatalogupdates = 0                 cmbSrvMemMin = 16                   cmbSrvMemMax = 2147483647<br \/>\ncusrconnections = 0                 cnetworkpcksize = 4096              ckbIndexMem = 0<br \/>\ncfillfactor = 0                     ctapreten = 0                       cwritestatus = 0<br \/>\ncfgpriorityboost = 0x0              cfgexposeadvparm = 0x1              cfglogintime = 10<br \/>\ncfgpss = 0                          cfgpad = 4096                       cfgxdes = 16<br \/>\ncfgaffinitymask = 0                 cfgaffinitymask64 = 0               cfgIOAffinityMask = 0<br \/>\ncfgIOAffinity64Mask = 0             cfgbuf = 4362                       cfgdes = 0<br \/>\ncfglocks = 0                        cfgquerytime = 600                  cfgcursorthrsh = -1<br \/>\ncfgrmttimeout = 10                  cfg_dtc_rpcs = 0                    cclkrate = 31250<br \/>\ncfg_max_text_repl_size = 65536      cfgupddate = 41782                  cfgupdtime = 23522824<br \/>\nfRemoteAccess = 1                   cfgbufminfree = 331                 cnestedtriggers = 0x1<br \/>\ncdeflang = 0                        cfgTransformNoiseWords = 0x0        cfgPrecomputeRank = 0x0<br \/>\ncrossdbownchain = 1                 cidCfg = 0x3400d008                 cidCfgOld = 0x3400d008<br \/>\ncfgCutoffYear = 2049                cfgLangNeutralFT = 1033             maxworkthreads = 0<br \/>\nminworkthreads = 32                 minnetworkthreads = 32              threadtimeout = 15<br \/>\nconnectsperthread = 0               cusroptions = 0                     exchcostthreshold = 5<br \/>\nmaxdop = 0                          cpwdpolicyupgrade = 0x1             cfServerTriggerRecursion = 1<br \/>\ncfDisableResultsetsFromTriggers = 0 cfgPHConnectTimeout = 60            CLREnabled = 1<br \/>\ncfgmaxcrawlrange = 4                ftSmallBufMin = 0                   ftSmallBufMax = 100<br \/>\nftLargeBufMin = 0                   ftLargeBufMax = 100                 RemoteDacEnabled = 0<br \/>\nCommCritComplianceEnabled = 0       EkmEnabled = 0                      cUserInstanceTimeout = 0x3c<br \/>\ncfgEnableUserInstances = 0x1        m_BackupCompressionDefault = 0x0    FilestreamAccessLevel = 1<br \/>\nOptimizeForAdhocWorkloads = 0       cchecksum = 1152<br \/>\n[\/sourcecode]\n<\/div>\n<p>\nIf you look closely at the names, you might notice some that look familiar. In fact, these values are the configuration values you can set with <span class=\"tt\">sp_configure<\/span>.\n<\/p>\n<h3>sp_configure and sys.configurations<\/h3>\n<p>\nSQL Server comes with a collection of user-settable configuration values. These values range from the max memory setting to the processor affinity mask. To change any of these values you can use the <span class=\"tt\">sp_configure<\/span> stored procedure. To see the current values you can use the following query against the <span class=\"tt\">sys.configurations<\/span> DMV:\n<\/p>\n<div>\n[sql]\nSELECT C.configuration_id,<br \/>\n       C.name,<br \/>\n       C.value,<br \/>\n       C.minimum,<br \/>\n       C.maximum,<br \/>\n       C.value_in_use,<br \/>\n       C.description,<br \/>\n       C.is_dynamic,<br \/>\n       C.is_advanced<br \/>\n  FROM sys.configurations AS C;<br \/>\n[\/sql]\n<\/div>\n<p>\nBelow is the output of the <span class=\"tt\">name<\/span> and <span class=\"tt\">value<\/span> columns on the same demo instance:\n<\/p>\n<div>\n[sourcecode]\nname                                value<br \/>\n----------------------------------- ----------<br \/>\naccess check cache bucket count     0<br \/>\naccess check cache quota            0<br \/>\nAd Hoc Distributed Queries          0<br \/>\naffinity I\/O mask                   0<br \/>\naffinity mask                       0<br \/>\naffinity64 I\/O mask                 0<br \/>\naffinity64 mask                     0<br \/>\nAgent XPs                           0<br \/>\nallow updates                       0<br \/>\nbackup compression default          0<br \/>\nblocked process threshold (s)       0<br \/>\nc2 audit mode                       0<br \/>\nclr enabled                         1<br \/>\ncommon criteria compliance enabled  0<br \/>\ncontained database authentication   1<br \/>\ncost threshold for parallelism      5<br \/>\ncross db ownership chaining         0<br \/>\ncursor threshold                    -1<br \/>\nDatabase Mail XPs                   0<br \/>\ndefault full-text language          1033<br \/>\ndefault language                    0<br \/>\ndefault trace enabled               1<br \/>\ndisallow results from triggers      0<br \/>\nEKM provider enabled                0<br \/>\nfilestream access level             1<br \/>\nfill factor (%)                     0<br \/>\nft crawl bandwidth (max)            100<br \/>\nft crawl bandwidth (min)            0<br \/>\nft notify bandwidth (max)           100<br \/>\nft notify bandwidth (min)           0<br \/>\nindex create memory (KB)            0<br \/>\nin-doubt xact resolution            0<br \/>\nlightweight pooling                 0<br \/>\nlocks                               0<br \/>\nmax degree of parallelism           0<br \/>\nmax full-text crawl range           4<br \/>\nmax server memory (MB)              2147483647<br \/>\nmax text repl size (B)              65536<br \/>\nmax worker threads                  0<br \/>\nmedia retention                     0<br \/>\nmin memory per query (KB)           1024<br \/>\nmin server memory (MB)              0<br \/>\nnested triggers                     1<br \/>\nnetwork packet size (B)             4096<br \/>\nOle Automation Procedures           0<br \/>\nopen objects                        0<br \/>\noptimize for ad hoc workloads       0<br \/>\nPH timeout (s)                      60<br \/>\nprecompute rank                     0<br \/>\npriority boost                      0<br \/>\nquery governor cost limit           0<br \/>\nquery wait (s)                      -1<br \/>\nrecovery interval (min)             0<br \/>\nremote access                       1<br \/>\nremote admin connections            0<br \/>\nremote login timeout (s)            10<br \/>\nremote proc trans                   0<br \/>\nremote query timeout (s)            600<br \/>\nReplication XPs                     0<br \/>\nscan for startup procs              0<br \/>\nserver trigger recursion            1<br \/>\nset working set size                0<br \/>\nshow advanced options               1<br \/>\nSMO and DMO XPs                     1<br \/>\ntransform noise words               0<br \/>\ntwo digit year cutoff               2049<br \/>\nuser connections                    0<br \/>\nuser options                        0<br \/>\nxp_cmdshell                         1<\/p>\n<p>(69 row(s) affected)<br \/>\n[\/sourcecode]\n<\/p><\/div>\n<p>\n(Do not look at these values for best practice advice. In fact some are set against all recommendations.)\n<\/p>\n<p>\nThe output contains 69 different configuration values. The Server Configuration Page on the other hand contains 74 values. So there are a few in there that you cannot change through T-SQL. <span class=\"tt\">cclkrate = 31250<\/span> for example is one of those values. It looks like it has something to do with a clock rate. However, I do not know any more details about this or any of the other values that are not exposed through <span class=\"tt\">sys.configurations<\/span>.\n<\/p>\n<h3>Summary<\/h3>\n<p>\nSQL Server comes with 69 configuration values. These values are stored in the Server Configuration Page which is always located in page 10 of the first data file in the <span class=\"tt\">master<\/span> database. That page also stores a handful of additional configuration values but their functionality is not documented.\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Server Configuration Page is the place where SQL Server stores its configuration values (sp_configure). It is of a special page type that is found only once per SQL Server instance. Read on to get all the details.<\/p>\n<p> <a href=\"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/\">[more&#8230;]<\/a><\/p>\n","protected":false},"author":3,"featured_media":2440,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[118,5,27,14,105],"tags":[111,190,191,15],"class_list":["post-2439","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dmvs-cvs","category-general","category-series","category-sql-server-internals","category-storage-wednesday","tag-dbcc-page","tag-server-configurations-page","tag-sp_configure","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The Server Configuration Page - sqlity.net<\/title>\n<meta name=\"description\" content=\"The Server Configuration Page is used by SQL Server to store its sys.configurations values. It is of a special page type, found only once per instance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Server Configuration Page - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"The Server Configuration Page is used by SQL Server to store its sys.configurations values. It is of a special page type, found only once per instance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-11T15:00:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T18:37:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"513\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"The Server Configuration Page\",\"datePublished\":\"2014-06-11T15:00:03+00:00\",\"dateModified\":\"2014-11-13T18:37:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/\"},\"wordCount\":754,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/server_configuration_page.jpg\",\"keywords\":[\"DBCC PAGE\",\"server configurations page\",\"sp_configure\",\"SQL Server\"],\"articleSection\":[\"DMVs &amp; CVs\",\"General\",\"Series\",\"SQL Server Internals\",\"Storage Wednesday\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/\",\"name\":\"The Server Configuration Page - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/server_configuration_page.jpg\",\"datePublished\":\"2014-06-11T15:00:03+00:00\",\"dateModified\":\"2014-11-13T18:37:54+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"The Server Configuration Page is used by SQL Server to store its sys.configurations values. It is of a special page type, found only once per instance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/server_configuration_page.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/server_configuration_page.jpg\",\"width\":768,\"height\":513,\"caption\":\"The Server Configuration Page\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2439\\\/server-configuration-page\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Server Configuration Page\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Server Configuration Page - sqlity.net","description":"The Server Configuration Page is used by SQL Server to store its sys.configurations values. It is of a special page type, found only once per instance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/","og_locale":"en_US","og_type":"article","og_title":"The Server Configuration Page - sqlity.net","og_description":"The Server Configuration Page is used by SQL Server to store its sys.configurations values. It is of a special page type, found only once per instance.","og_url":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2014-06-11T15:00:03+00:00","article_modified_time":"2014-11-13T18:37:54+00:00","og_image":[{"width":768,"height":513,"url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg","type":"image\/jpeg"}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"The Server Configuration Page","datePublished":"2014-06-11T15:00:03+00:00","dateModified":"2014-11-13T18:37:54+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/"},"wordCount":754,"commentCount":0,"image":{"@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg","keywords":["DBCC PAGE","server configurations page","sp_configure","SQL Server"],"articleSection":["DMVs &amp; CVs","General","Series","SQL Server Internals","Storage Wednesday"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/","url":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/","name":"The Server Configuration Page - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg","datePublished":"2014-06-11T15:00:03+00:00","dateModified":"2014-11-13T18:37:54+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"The Server Configuration Page is used by SQL Server to store its sys.configurations values. It is of a special page type, found only once per instance.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#primaryimage","url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg","contentUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg","width":768,"height":513,"caption":"The Server Configuration Page"},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/2439\/server-configuration-page\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"The Server Configuration Page"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/06\/server_configuration_page.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-Dl","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=2439"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2439\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media\/2440"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=2439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=2439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=2439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}