{"id":14394,"date":"2019-12-27T06:30:25","date_gmt":"2019-12-27T06:30:25","guid":{"rendered":"https:\/\/dbtut.com\/?p=14394"},"modified":"2019-12-27T06:30:28","modified_gmt":"2019-12-27T06:30:28","slug":"how-to-change-instance-settings-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/","title":{"rendered":"How To Change Instance Settings in SQL Server"},"content":{"rendered":"

In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS and click properties.<\/p>\n

\"\"<\/p>\n

You will see general information on the General tab.<\/p>\n

Memory Settings<\/h2>\n

When we switch to the Memory tab, we see “Minimum server memory (in MB):<\/strong>” and “Maximum server memory (in MB):<\/strong>“. In this section, we can set the minimum and maximum memory that SQL Server Instance will use. Some concepts must be well understood for setting memory correctly. You can find the details in the article “Numa Nodes, MAX\/MIN Server Memory, Log Pages In Memory and MAXDOP<\/a>“.<\/p>\n

In Other memory options;<\/h4>\n

“Index creation memory(in KB, 0=dynamic memory);<\/strong>” value indicates the minimum memory value to be allocated for sort operations when creating an index. I don’t recommend changing this value unless you have a specific problem when creating an index.<\/p>\n

“Minimum memory per query (in KB);” value indicates the minimum amount of memory to be allocated for a query, as the name implies. I do not recommend changing this default value unless you have a specific need.<\/p>\n

\"\"<\/p>\n

Processors Settings<\/h2>\n

On the Processors tab, in the Enable processors section,<\/p>\n

Processor Affinity in SQL Server<\/h4>\n

If you select the “Automatically set processor affinity mask for all processor” option, threads are automatically distributed across all CPUs.<\/p>\n

I\/O Affinity in SQL Server<\/h4>\n

If you select the “Automatically set I\/O affinity mask for all processors” option, sql server automatically distributes I\/O related operations to all CPUs.<\/p>\n

By not selecting these two options, you can distribute workloads between CPUs specifically as follows, but I wouldn’t recommend it. By selecting the first two options, we must ensure that the workload distribution is automatic. This is the default.<\/p>\n

\"\"<\/p>\n

I recommend not changing the Maximum worker threads<\/strong> setting. 0 indicates that it is set automatically.<\/p>\n

If you select the Boost SQL Server priority<\/strong> option, you increase the priority of SQL Server according to other services running on the operating system. I have not chosen this option so far in the environments I manage.<\/p>\n

If you select the Use Windows fibers<\/strong> option, you can reduce the workload of some processes that are seen in symmetric multiprocessing (SMP) environments. I have not chosen this option until now in the environments I manage.<\/p>\n

Security Settings<\/h2>\n

Server Authentication<\/h4>\n

If you select Windows Authentication mode<\/strong> from Server authentication in Security, you can only connect to SQL Instance with windows accounts.<\/p>\n

If you select SQL server and Windows Authentication mode<\/strong>, you can connect to SQL Instance with both sql logins and windows logins. You can find detailed information in the article “How To Create a Login On SQL Server(Manage Logins)<\/a>“.<\/p>\n

Login Auditing<\/h4>\n

If you select Failed logins only<\/strong> in login auditing, SQL Server logs the failed logins in the Error Log.<\/p>\n

\"\"<\/p>\n

Database Settings<\/h2>\n

In Database Settings, you can set the default index fill factor<\/strong>, enable compress backup, and set default paths to create databases.<\/p>\n

Recovery inteval<\/strong>; This is the upper limit required to recover databases after restarting SQL Server. Default value is 0 which means that an automatic checkpoint occurs every 60 seconds. Do not change this configuration if you do not know what you do. If you want to understand database recovery operations and checkpoint, you may want to read the articles “What is Database Checkpoint<\/a>” and “What is SQL Server Transaction Log<\/a>”<\/p>\n

\"\"<\/p>\n

In the Advanced tab, we can make many settings such as file stream<\/strong>, contained database<\/strong>, maxdop<\/strong>. You can find detailed information in the following articles. You can also use the Search section on many topics you are looking for.<\/p>\n

“What is File Stream On SQL Server<\/a>“,<\/p>\n

“What is Contained Database and How To Create<\/a>“,<\/p>\n

“Numa Nodes, MAX\/MIN Server Memory, Log Pages In Memory and MAXDOP<\/a>”<\/p>\n

\"\"<\/p>\n

Finally, you can grant permission to a login at the instance level from the permissions tab.<\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

In this article I will explain how to configure SQL Server Instance through SSMS. Right-click on the instance via SSMS and click properties. You will see general information on the General tab. Memory Settings When we switch to the Memory tab, we see “Minimum server memory (in MB):” and “Maximum server memory (in MB):“. In …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":14403,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[7069,7055,7048,7063,7108,7043,7044,7038,7045,7056,7091,7114,7073,7074,7075,7113,7049,7110,7067,7078,7087,7083,7086,7070,7071,7096,7061,7058,7099,7033,7103,7036,7042,7039,7041,7040,7037,7057,7098,7106,7068,7104,7062,7034,7035,7115,7102,7046,7060,7059,7101,7097,7053,7054,7052,7050,7077,7080,7082,7079,7072,7047,7094,7090,7095,7066,7109,7092,7093,7089,7100,7111,7088,7081,7105,7107,3485,7112,7064,7084,7085,7051,7076,7065],"class_list":["post-14394","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-auditing-failed-logins-in-sql-server","tag-automatically-set-i-o-affinity-mask-for-all-processors","tag-automatically-set-processor-affinity-mask-for-all-processor","tag-boost-sql-server-priority","tag-both-failed-and-successful-logins-sql-server","tag-change-instance-properties","tag-change-instance-properties-in-sql-server","tag-change-instance-settings-in-sql-server","tag-configure-instance-settings-in-sql-server","tag-cpu-affinity-in-sql-server","tag-cpu-affinity-sql-server","tag-database-settings-default-index-fill-factor","tag-database-settings-in-sql-server","tag-default-index-fill-factor","tag-enable-compress-backup","tag-enable-failed-and-successful-logins-sql-server","tag-enable-processors","tag-ensure-sql-server-audit-is-set-to-capture-both-failed-and-successful-logins","tag-failed-logins-only","tag-grant-permission-to-a-login-at-the-instance-level","tag-how-do-i-change-my-database-engine-configuration","tag-how-do-i-find-properties-in-sql-server","tag-how-do-i-find-server-properties","tag-how-to-audit-successful-logon-logoff-and-failed-logons","tag-how-to-log-success-and-failed-logins","tag-how-to-set-processor-affinity-sql-server","tag-i-o-affinity","tag-i-o-affinity-in-sql-server","tag-i-o-affinity-sql-server","tag-index-creation-memory","tag-index-creation-memory-sql-server","tag-instance-memory-settings","tag-instance-properties","tag-instance-properties-in-sql-server","tag-instance-properties-mssql","tag-instance-properties-sql-server","tag-instance-settings-in-sql-server","tag-io-affinity-in-sql-server","tag-io-affinity-sql-server","tag-log-success-and-failed-logins","tag-login-auditing","tag-login-auditing-sql-server","tag-maximum-worker-threads","tag-minimum-memory-per-query","tag-minimum-memory-per-query-in-kb","tag-mssql-default-index-fill-factor","tag-mssql-index-creation-memory","tag-other-memory-options","tag-processor-affinity","tag-processor-affinity-in-sql-server","tag-processor-affinity-vs-io-affinity-sql-server","tag-processor-and-io-affinity-sql-server","tag-processors-settings","tag-processors-settings-in-server-properties","tag-processors-settings-on-the-processors-tab","tag-processors-tab","tag-recovery-interval-in-minutes","tag-recovery-interval-in-sql-server","tag-recovery-interval-ms-sql","tag-recovery-interval-sql","tag-server-authentication","tag-server-memory-options","tag-set-cpu-affinity-sql-server","tag-set-processor-affinity-sql-server","tag-setting-a-processor-affinity-in-sql-server","tag-sql-server-and-windows-authentication-mode","tag-sql-server-audit-is-set-to-capture-both-failed-and-successful-logins","tag-sql-server-automatically-set-processor-affinity-mask","tag-sql-server-automatically-set-processor-affinity-mask-for-all-processors","tag-sql-server-change-memory-settings","tag-sql-server-io-affinity-mask","tag-sql-server-login-auditing-both-failed-and-successful-logins","tag-sql-server-memory-settings","tag-sql-server-recovery-interval","tag-succesfull-logins-only","tag-successful-and-failed-logins-sql-server","tag-top-queries-by-cpu-and-io","tag-use-sql-server-audit-to-capture-both-failed-and-successful-logins","tag-use-windows-fibers","tag-view-or-change-the-properties-of-instance","tag-view-or-change-the-properties-of-server","tag-what-is-cpu-affinity","tag-what-is-recovery-interval-in-sql-server","tag-windows-authentication-mode"],"aioseo_notices":[],"yoast_head":"\nHow To Change Instance Settings in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Change Instance Settings in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Change Instance Settings in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Change Instance Settings in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-27T06:30:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-27T06:30:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png\" \/>\n\t<meta property=\"og:image:width\" content=\"623\" \/>\n\t<meta property=\"og:image:height\" content=\"369\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Change Instance Settings in SQL Server\",\"datePublished\":\"2019-12-27T06:30:25+00:00\",\"dateModified\":\"2019-12-27T06:30:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\"},\"wordCount\":647,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png\",\"keywords\":[\"Auditing Failed Logins in SQL Server\",\"Automatically set I\/O affinity mask for all processors\",\"Automatically set processor affinity mask for all processor\",\"Boost SQL Server priority\",\"both failed and successful logins sql server\",\"Change Instance Properties\",\"Change Instance Properties in SQL Server\",\"Change Instance Settings in SQL Server\",\"Configure Instance Settings in SQL Server\",\"cpu affinity in SQL Server\",\"cpu affinity sql server\",\"database settings default index fill factor\",\"Database Settings in SQL Server\",\"default index fill factor\",\"enable compress backup\",\"enable failed and successful logins sql server\",\"Enable processors\",\"ensure 'sql server audit' is set to capture both 'failed' and 'successful logins'\",\"Failed logins only\",\"grant permission to a login at the instance level\",\"How do I change my database engine configuration?\",\"How do I find properties in SQL Server?\",\"How do I find server properties?\",\"How to Audit Successful Logon\/Logoff and Failed Logons\",\"How to log Success and Failed Logins\",\"how to set processor affinity sql server\",\"I\/O Affinity\",\"I\/O affinity in SQL Server\",\"i\/o affinity sql server\",\"Index creation memory\",\"index creation memory sql server\",\"Instance Memory Settings\",\"Instance Properties\",\"Instance Properties in SQL Server\",\"Instance Properties MSSQL\",\"Instance Properties SQL Server\",\"Instance Settings in SQL Server\",\"IO Affinity in SQL Server\",\"io affinity sql server\",\"log success and failed logins\",\"Login Auditing\",\"login auditing sql server\",\"Maximum worker threads\",\"Minimum memory per query\",\"Minimum memory per query (in KB);\",\"mssql default index fill factor\",\"mssql index creation memory\",\"Other memory options\",\"Processor Affinity\",\"Processor Affinity in SQL Server\",\"processor affinity vs io affinity sql server\",\"processor and io affinity sql server\",\"Processors Settings\",\"Processors Settings in Server properties\",\"Processors Settings On the Processors tab\",\"Processors tab\",\"recovery interval in minutes\",\"recovery interval in sql server\",\"recovery interval ms sql\",\"recovery interval sql\",\"Server Authentication\",\"Server Memory options\",\"set cpu affinity sql server\",\"set processor affinity sql server\",\"setting a processor affinity in sql server\",\"SQL server and Windows Authentication mode\",\"sql server audit' is set to capture both 'failed' and 'successful logins'\",\"sql server automatically set processor affinity mask\",\"sql server automatically set processor affinity mask for all processors\",\"sql server change memory settings\",\"sql server io affinity mask\",\"sql server login auditing both failed and successful logins\",\"sql server memory settings\",\"sql server recovery interval\",\"Succesfull logins only\",\"successful and failed logins sql server\",\"Top Queries by CPU and IO\",\"use sql server audit to capture both failed and successful logins\",\"Use Windows fibers\",\"view or change the properties of instance\",\"view or change the properties of server\",\"What is CPU Affinity\",\"What is recovery interval in SQL Server?\",\"Windows Authentication mode\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\",\"name\":\"How To Change Instance Settings in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png\",\"datePublished\":\"2019-12-27T06:30:25+00:00\",\"dateModified\":\"2019-12-27T06:30:28+00:00\",\"description\":\"How To Change Instance Settings in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png\",\"width\":623,\"height\":369},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Change Instance Settings in SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Change Instance Settings in SQL Server - Database Tutorials","description":"How To Change Instance Settings in SQL Server","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:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Change Instance Settings in SQL Server - Database Tutorials","og_description":"How To Change Instance Settings in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-27T06:30:25+00:00","article_modified_time":"2019-12-27T06:30:28+00:00","og_image":[{"width":623,"height":369,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Change Instance Settings in SQL Server","datePublished":"2019-12-27T06:30:25+00:00","dateModified":"2019-12-27T06:30:28+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/"},"wordCount":647,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png","keywords":["Auditing Failed Logins in SQL Server","Automatically set I\/O affinity mask for all processors","Automatically set processor affinity mask for all processor","Boost SQL Server priority","both failed and successful logins sql server","Change Instance Properties","Change Instance Properties in SQL Server","Change Instance Settings in SQL Server","Configure Instance Settings in SQL Server","cpu affinity in SQL Server","cpu affinity sql server","database settings default index fill factor","Database Settings in SQL Server","default index fill factor","enable compress backup","enable failed and successful logins sql server","Enable processors","ensure 'sql server audit' is set to capture both 'failed' and 'successful logins'","Failed logins only","grant permission to a login at the instance level","How do I change my database engine configuration?","How do I find properties in SQL Server?","How do I find server properties?","How to Audit Successful Logon\/Logoff and Failed Logons","How to log Success and Failed Logins","how to set processor affinity sql server","I\/O Affinity","I\/O affinity in SQL Server","i\/o affinity sql server","Index creation memory","index creation memory sql server","Instance Memory Settings","Instance Properties","Instance Properties in SQL Server","Instance Properties MSSQL","Instance Properties SQL Server","Instance Settings in SQL Server","IO Affinity in SQL Server","io affinity sql server","log success and failed logins","Login Auditing","login auditing sql server","Maximum worker threads","Minimum memory per query","Minimum memory per query (in KB);","mssql default index fill factor","mssql index creation memory","Other memory options","Processor Affinity","Processor Affinity in SQL Server","processor affinity vs io affinity sql server","processor and io affinity sql server","Processors Settings","Processors Settings in Server properties","Processors Settings On the Processors tab","Processors tab","recovery interval in minutes","recovery interval in sql server","recovery interval ms sql","recovery interval sql","Server Authentication","Server Memory options","set cpu affinity sql server","set processor affinity sql server","setting a processor affinity in sql server","SQL server and Windows Authentication mode","sql server audit' is set to capture both 'failed' and 'successful logins'","sql server automatically set processor affinity mask","sql server automatically set processor affinity mask for all processors","sql server change memory settings","sql server io affinity mask","sql server login auditing both failed and successful logins","sql server memory settings","sql server recovery interval","Succesfull logins only","successful and failed logins sql server","Top Queries by CPU and IO","use sql server audit to capture both failed and successful logins","Use Windows fibers","view or change the properties of instance","view or change the properties of server","What is CPU Affinity","What is recovery interval in SQL Server?","Windows Authentication mode"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/","name":"How To Change Instance Settings in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png","datePublished":"2019-12-27T06:30:25+00:00","dateModified":"2019-12-27T06:30:28+00:00","description":"How To Change Instance Settings in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/12\/Ads\u0131z-21.png","width":623,"height":369},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/27\/how-to-change-instance-settings-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Change Instance Settings in SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14394","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14394"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14394\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14403"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14394"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14394"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14394"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}