{"id":3817,"date":"2023-09-13T09:59:17","date_gmt":"2023-09-13T06:59:17","guid":{"rendered":"https:\/\/www.ozgurguler.net\/blog\/?p=3817"},"modified":"2023-09-13T09:59:19","modified_gmt":"2023-09-13T06:59:19","slug":"sql-server-maksimum-ram-ayarlari","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/sql-server-maksimum-ram-ayarlari\/","title":{"rendered":"Sql Server Maksimum Ram Ayarlar\u0131"},"content":{"rendered":"

Biraz giri\u015f bilgisi olacak ama sizlere \u00e7ok basit ve her zaman i\u015fe yarayabilecek bir bilgiden bahsetmek istiyorum. SQL Server \u00e7ok fazla RAM t\u00fcketiyor. Bu RAM t\u00fcketimi o kadar \u00e7ok b\u00fcy\u00fck boyutlara ula\u015f\u0131yorki zamanla i\u015fletim sistemi \u00e7al\u0131\u015famaz hale geliyor.<\/p>\n

\u00c7\u00f6z\u00fcm bilgisayar\u0131 restart etmek. Bilgisayar\u0131 restart edince problem \u00e7\u00f6z\u00fcl\u00fcyor ama bellirli bir s\u00fcre sonra yeniden ayn\u0131 problemle kar\u015f\u0131la\u015f\u0131yoruz.<\/p>\n

Bu durumu d\u00fczeltmek SQL Server Properties k\u0131sm\u0131nda Memory sekmesinde gerekli ayarlar\u0131 yapmak gerekir.<\/p>\n

\"\"<\/a><\/p>\n

Burada Maximum server memory(in MB) \u00e7ok b\u00fcy\u00fck bir rakam olarak belirlenmi\u015f. Burada kendi donan\u0131m\u0131m\u0131za g\u00f6re haf\u0131za ayarlar\u0131n\u0131 yapmam\u0131z gerekir. A\u015fa\u011f\u0131daki ayarlar sadece SQL Server i\u00e7in ayr\u0131lm\u0131\u015f server i\u00e7in ayarlanm\u0131\u015f RAM ayarlar\u0131d\u0131r. E\u011fer di\u011fer SQL Server componentlerini (SSIS ve Full Text Search) SQL Server Buffer Pool i\u00e7in ay\u0131rd\u0131\u011f\u0131m\u0131z bu bellek miktarlar\u0131n\u0131 d\u00fc\u015f\u00fcrmemiz gerekecektir.<\/p>\n

Physical RAM MaxServerMem Setting
\n2GB 1500
\n4GB 3200
\n6GB 4800
\n8GB 6400
\n12GB 10000
\n16GB 13500
\n24GB 21500
\n32GB 29000
\n48GB 44000
\n64GB 60000
\n72GB 68000
\n96GB 92000
\n128GB 124000<\/p>\n

Ayn\u0131 ayarlamay\u0131 ayr\u0131ca T-SQL komutu ile de \u015fu \u015fekilde yapabilirsiniz:<\/p>\n

— Turn on advanced options
\nEXEC sp_configure ‘Show Advanced Options’,1;
\nGO
\nRECONFIGURE;
\nGO
\n— Set max server memory = 3072MB
\nEXEC sp_configure ‘max server memory (MB)’,3072;
\nGO
\nRECONFIGURE;
\nGO
\n— See what the current values are
\nEXEC sp_configure;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Biraz giri\u015f bilgisi olacak ama sizlere \u00e7ok basit ve her zaman i\u015fe yarayabilecek bir bilgiden bahsetmek istiyorum. SQL Server \u00e7ok fazla RAM t\u00fcketiyor. Bu RAM t\u00fcketimi o kadar \u00e7ok b\u00fcy\u00fck boyutlara ula\u015f\u0131yorki zamanla i\u015fletim sistemi \u00e7al\u0131\u015famaz hale geliyor. \u00c7\u00f6z\u00fcm bilgisayar\u0131 restart etmek. Bilgisayar\u0131 restart edince problem \u00e7\u00f6z\u00fcl\u00fcyor ama bellirli bir s\u00fcre sonra yeniden ayn\u0131 problemle […]<\/p>\n","protected":false},"author":4,"featured_media":2722,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,10],"tags":[],"class_list":["post-3817","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","category-sql-server-tsql"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/3817","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=3817"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/3817\/revisions"}],"predecessor-version":[{"id":3819,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/3817\/revisions\/3819"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media\/2722"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=3817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=3817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=3817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}