{"id":45,"date":"2006-05-15T15:20:03","date_gmt":"2006-05-15T19:20:03","guid":{"rendered":"http:\/\/www.onurbaser.info\/gunluk\/baserwww\/2006\/05\/15\/isa-server-2004-ve-msde-sqlservrexe-deki-hafiza-kullanimi-sorunu\/"},"modified":"2006-05-17T11:34:42","modified_gmt":"2006-05-17T15:34:42","slug":"isa-server-2004-ve-msde-sqlservrexe-deki-hafiza-kullanimi-sorunu","status":"publish","type":"post","link":"https:\/\/www.onurbaser.info\/gunluk\/bilgisayar\/2006\/05\/15\/isa-server-2004-ve-msde-sqlservrexe-deki-hafiza-kullanimi-sorunu\/","title":{"rendered":"ISA Server 2004 ve MSDE (sqlservr.exe) deki haf\u0131za kullan\u0131m\u0131 sorunu"},"content":{"rendered":"

Microsoft ISA server 2004 ile y\u00fcklenen msde veritaban\u0131 haf\u0131zay\u0131 o anda kullanan uygulama yoksa her dakika gittik\u00e7e haf\u0131zan\u0131z\u0131 i\u015fgal ediyor (2 gig bir makinada 1.5 gig – tek bir program – \u00e7\u0131kabiliyor.)<\/p>\n

Bu bilinen bir \u00f6zellik(yada hata).
\nBunu \u00e7\u00f6zmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulayabilirsiniz.<\/strong><\/p>\n

1.\u00d6nce MSDE’nin ne kadar haf\u0131za kullanabil\u011fine bak\u0131n :<\/p>\n\n\n\n
<\/td>\nA\u015fa\u011f\u0131daki kodu \u00e2\u20ac\u0153checksqlmemory.sql\u00e2\u20ac\u009d dosyas\u0131 olarak kay\u0131t edin\u00e7<\/p>\n
USE master
\nEXEC sp_configure ‘show advanced options’, 1
\nRECONFIGURE WITH OVERRIDEUSE master
\nEXEC sp_configure ‘max server memory (MB)’USE master
\nEXEC sp_configure ‘show advanced options’, 0
\nRECONFIGURE WITH OVERRIDE<\/div>\n<\/td>\n<\/tr>\n

\n<\/strong><\/td>\n		komut ekran\u0131nda (cmd.exe)<\/em><\/p>\n
osql -E -S ServerComputerName<\/var>\\msfw -i <\/strong>DOSYAYOLUNUYAZIN<\/var>\\checksqlmemory.sql<\/var><\/strong><\/div>\n

bunu yaz\u0131n<\/em><\/td>\n<\/tr>\n<\/table>\n

2.Haf\u0131za kullan\u0131m\u0131n\u0131 d\u00fc\u015f\u00fcrmek i\u00e7in:<\/p>\n\n\n
<\/td>\nA\u015fa\u011f\u0131daki komutlar\u0131 \u00e2\u20ac\u0153setchecksqlmemory.sql\u00e2\u20ac\u009d olarak kay\u0131t edin.<\/p>\n
USE master
\nEXEC sp_configure ‘show advanced options’, 1
\nRECONFIGURE WITH OVERRIDEUSE master
\nEXEC sp_configure ‘max server memory (MB)’, MaxServerMemory<\/var>
\nRECONFIGURE WITH OVERRIDEUSE master
\nEXEC sp_configure ‘show advanced options’, 0
\nRECONFIGURE WITH OVERRIDE<\/div>\n

Not<\/strong> Bu \u00f6rnekdeki, MaxServerMemory<\/var> 512 ile de\u011fi\u015ftirin (512 MB i\u00e7in)<\/td>\n<\/tr>\n<\/table>\n

Genelde msde i\u00e7in 1\/3 haf\u0131zan\u0131z\u0131 ay\u0131rman\u0131z \u00f6nerilir.<\/p>\n

Orjinal makale i\u00e7in buraya t\u0131klay\u0131n<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft ISA server 2004 ile y\u00fcklenen msde veritaban\u0131 haf\u0131zay\u0131 o anda kullanan uygulama yoksa her dakika gittik\u00e7e haf\u0131zan\u0131z\u0131 i\u015fgal ediyor (2 gig bir makinada 1.5 gig – tek bir program – \u00e7\u0131kabiliyor.) Bu bilinen bir \u00f6zellik(yada hata). Bunu \u00e7\u00f6zmek i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uygulayabilirsiniz. 1.\u00d6nce MSDE’nin ne kadar haf\u0131za kullanabil\u011fine bak\u0131n : A\u015fa\u011f\u0131daki kodu \u00e2\u20ac\u0153checksqlmemory.sql\u00e2\u20ac\u009d dosyas\u0131 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[3],"tags":[],"class_list":["post-45","post","type-post","status-publish","format-standard","hentry","category-bilgisayar"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9nmfM-J","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/posts\/45","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/comments?post=45"}],"version-history":[{"count":1,"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/posts\/45\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/posts\/45\/revisions\/239"}],"wp:attachment":[{"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/media?parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/categories?post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onurbaser.info\/gunluk\/wp-json\/wp\/v2\/tags?post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}