{"id":1223,"date":"2015-10-01T10:06:21","date_gmt":"2015-10-01T07:06:21","guid":{"rendered":"http:\/\/www.ozgurguler.net\/blog\/?p=1223"},"modified":"2015-10-01T10:06:29","modified_gmt":"2015-10-01T07:06:29","slug":"this-index-operation-requires-512-kb-of-memory-per-dop-hatasi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/this-index-operation-requires-512-kb-of-memory-per-dop-hatasi\/","title":{"rendered":"This index operation requires 512 KB of memory per DOP hatas\u0131&#8230;"},"content":{"rendered":"<p>Logo uygulamalar\u0131nda,\u00a0 &#8220;<strong>This index operation requires 512 KB of memory per DOP. The total requirement of 8192 KB for DOP of 16 is greater than the sp_configure value of 2048 KB set for the advanced server configuration option &#8220;index create memory (KB)&#8221;.\u00a0 Increase this setting or reduce DOP and rerun the query.<\/strong> &#8221; hatas\u0131, SQL Server&#8217; da index olu\u015fturulmas\u0131 s\u0131ras\u0131nda kullan\u0131lan belle\u011fin yetersizli\u011finden kaynaklan\u0131r.<\/p>\n<p>\u00c7\u00f6z\u00fcm i\u00e7in Query Analyzer&#8217; dan a\u015fa\u011f\u0131daki komutlar \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r.<\/p>\n<p>exec sp_configure &#8216;index create memory (KB)&#8217;, 51200<br \/>\nreconfigure with override<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Logo uygulamalar\u0131nda,\u00a0 &#8220;This index operation requires 512 KB of memory per DOP. The total requirement of 8192 KB for DOP of 16 is greater than the sp_configure value of 2048 KB set for the advanced server configuration option &#8220;index create memory (KB)&#8221;.\u00a0 Increase this setting or reduce DOP and rerun the query. &#8221; hatas\u0131, SQL [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1223","post","type-post","status-publish","format-standard","hentry","category-logo-genel-destek"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1223"}],"version-history":[{"count":2,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1223\/revisions"}],"predecessor-version":[{"id":1225,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1223\/revisions\/1225"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}