{"id":617,"date":"2008-10-01T12:32:10","date_gmt":"2008-10-01T11:32:10","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=617"},"modified":"2008-10-01T12:33:45","modified_gmt":"2008-10-01T11:33:45","slug":"sql-server-memoria-beallitas-es-vergodes","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/10\/01\/sql-server-memoria-beallitas-es-vergodes\/","title":{"rendered":"SQL Server mem\u00f3ria be\u00e1ll\u00edt\u00e1s \u00e9s verg\u0151d\u00e9s"},"content":{"rendered":"<p>Annak idej\u00e9n az SQL 2000 kapcs\u00e1n \u00fagy tanultam, hogy az sql server okosan b\u00e1nik a mem\u00f3ri\u00e1val, \u00e9s ha a szabad RAM m\u00e9rete 5 MByte al\u00e1 esik, akkor a Lazy Writer elkezdi ki\u00edrni a m\u00f3dos\u00edtott lapokat a diszkre. Teszi ezt az\u00e9rt, hogy ne kezdjen el lapozni az oprendszer.<br \/>\n2005-ben azonban elkezdtem azt tapasztalni, hogy az sql server t\u00falzab\u00e1lta mag\u00e1t, \u00e9s az oprendszer m\u00e9gis csak kem\u00e9nyen lapozott alatta, \u00e9s \u00fagy t\u0171nt, hogy nem m\u00e1s processzek miatt, hanem az SQL Server miatt.<br \/>\nAz MVP newsgroupon olvasom, hogy m\u00e1soknak is van ilyen probl\u00e9m\u00e1ja. 8 G RAM volt a g\u00e9pben, az SQL Server 6 G-ra volt bekorl\u00e1tozva. M\u00e1s folyamatok, mint Database Mail, stb. miatt azonban m\u00e9g \u00edgy is nagy lapoz\u00e1sok t\u00f6rt\u00e9ntek, err\u0151l az SQL Server \u00edr is az error logj\u00e1ban (A significant part of sql server process memory has been paged out. This may result in a performance degradation.).<br \/>\nA koll\u00e9g\u00e1nak 4 Gig\u00e1ra vissza kellett h\u00fazni a max memory be\u00e1ll\u00edt\u00e1st, hogy megnyugodjon a szerver. Ez <a href=\"http:\/\/blogs.msdn.com\/psssql\/archive\/2007\/05\/31\/the-sql-server-working-set-message.aspx#3733369\">m\u00e1snak is bev\u00e1lt<\/a>. J\u00f3 err\u0151l tudni.<\/p>\n<p>Van, akinek az OS File Cache viszi el a ramot. Nekem is <a href=\"http:\/\/soci.hu\/blog\/index.php\/2008\/07\/28\/vista-memoriakezelesi-furcsasag\/\">gyan\u00fas volt m\u00e1r egyszer<\/a>, ezek szerint nem v\u00e9letlen\u00fcl. Van egy be\u00e1ll\u00edt\u00e1s a System applet m\u00f6g\u00f6tt (Performance Options, Advanced, Memory, Adjust for best performace of Programs vagy System Cache), hogy file server vagy application server \u00fczemm\u00f3dban m\u0171k\u00f6dj\u00f6n a szerver\u00fcnk. Ez pont a File Cache m\u00e9ret\u00e9t szab\u00e1lyozza, teh\u00e1t ha ez rosszul van be\u00e1ll\u00edtva egy SQL Serveren, akkor ez m\u00e1r gyan\u00fas lehet.<\/p>\n<p>Nem csak a File Cache szor\u00edthatja ki az SQL Servert a mem\u00f3ri\u00e1b\u00f3l, de ha az, arra az al\u00e1bbi <a href=\"http:\/\/msmvps.com\/blogs\/omar\/archive\/2007\/09\/19\/a-significant-part-of-sql-server-process-memory-has-been-paged-out-this-may-result-in-performance-degradation.aspx\">cikk<\/a> megold\u00e1st adhat.<\/p>\n<p>R\u00e9szletes elemz\u00e9s \u00e9s l\u00e9p\u00e9senk\u00e9nti hibakeres\u00e9s a probl\u00e9m\u00e1r\u00f3l <a href=\"http:\/\/blogs.msdn.com\/psssql\/archive\/2007\/05\/31\/the-sql-server-working-set-message.aspx\">itt tal\u00e1lhat\u00f3<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Annak idej\u00e9n az SQL 2000 kapcs\u00e1n \u00fagy tanultam, hogy az sql server okosan b\u00e1nik a mem\u00f3ri\u00e1val, \u00e9s ha a szabad RAM m\u00e9rete&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,4,30,21,58],"tags":[],"class_list":["post-617","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=617"}],"version-history":[{"count":3,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/617\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/617\/revisions\/620"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}