{"id":827,"date":"2009-03-17T23:10:01","date_gmt":"2009-03-17T22:10:01","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=827"},"modified":"2009-03-17T23:10:01","modified_gmt":"2009-03-17T22:10:01","slug":"sql-server-lock-pages-in-memory-on-64-bit-platform","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2009\/03\/17\/sql-server-lock-pages-in-memory-on-64-bit-platform\/","title":{"rendered":"SQL Server: Lock Pages In memory on 64 bit platform"},"content":{"rendered":"<p>Yes, <a href=\"http:\/\/blogs.msdn.com\/slavao\/archive\/2005\/08\/31\/458545.aspx\">we do recommend<\/a> to turn on Lock pages in memory so that OS doesn&#8217;t page SQL Server out. On 64 bit you only need to grant the right &#8220;Lock Pages in Memory&#8221; to the SQL account for SQL Server to utilize this feature.<\/p>\n<p><a href=\"http:\/\/soci.hu\/blog\/wp-content\/uploads\/2009\/03\/lockpages.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/soci.hu\/blog\/wp-content\/uploads\/2009\/03\/lockpages-300x152.jpg\" alt=\"\" title=\"Lock Pages in Memory User Right be\u00e1ll\u00edt\u00e1sa az SQL Server accountra\" width=\"300\" height=\"152\" class=\"aligncenter size-medium wp-image-828\" srcset=\"https:\/\/soci.hu\/blog\/wp-content\/uploads\/2009\/03\/lockpages-300x152.jpg 300w, https:\/\/soci.hu\/blog\/wp-content\/uploads\/2009\/03\/lockpages-600x305.jpg 600w, https:\/\/soci.hu\/blog\/wp-content\/uploads\/2009\/03\/lockpages.jpg 657w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/blogs.msdn.com\/slavao\/archive\/2005\/11\/15\/493019.aspx\">Kapcsol\u00f3dik m\u00e9g<\/a>.<\/p>\n<p>Ha ez a hiba el\u0151j\u00f6n f\u0151leg <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\">n\u00e9zzetek ut\u00e1na<\/a>:<br \/>\n&#8220;A significant part of sql server process memory has been paged out. This may result in performance degradation&#8221;<\/p>\n<p>De m\u00e1r megyek is vissza a munk\u00e1hoz, mert igencsak beindult az \u00e9let, egyszerre 6 c\u00e9g sz\u00e1m\u00e1ra futnak munk\u00e1im, \u00e9s most adok aj\u00e1nlatot a j\u00f6v\u0151 h\u00e9ten egy \u00fajabb, v\u00e1rhat\u00f3an el\u00e9g nagy volumen\u0171 feladatra. Igaza van Marcellnak, v\u00e1ls\u00e1g m\u00e1s c\u00e9gn\u00e9l van, n\u00e1lunk mi\u00e9rt lenne? Ezzel nem akarom nagyk\u00e9p\u0171en lebecs\u00fclni sok ember nagyon is val\u00f3s gondj\u00e1t k\u00f6lcs\u00f6nprobl\u00e9m\u00e1k \u00e9s egy\u00e1ltal\u00e1n a meg\u00e9lhet\u00e9s miatt, csak azt akarom meger\u0151s\u00edteni, hogy att\u00f3l, hogy a gazdas\u00e1gi folyamatok nem a hely\u00fck\u00f6n vannak, att\u00f3l m\u00e9g megy az \u00e9let, folyik az \u00e9p\u00edtkez\u00e9s sok helyen. Van egy ismer\u0151s\u00f6m, aki kereskedelemb\u0151l \u00e9l, \u00e9s mondta, hogy a \u0151 c\u00e9g\u00e9re is igen neh\u00e9z id\u0151k j\u00e1rnak, nem tudja, ny\u00e1ron is l\u00e9tezni fog-e m\u00e9g a c\u00e9ge.<br \/>\nNeh\u00e9z kikapcsolni a sok negat\u00edv hangot, ami az ut\u00f3bbi h\u00f3napokban a csapb\u00f3l is folyik, nem tesz j\u00f3t az ember motiv\u00e1ci\u00f3j\u00e1nak. De j\u00f6n a tavaszi sz\u00e9l, rem\u00e9lem ez sok mindenben \u00faj vizet \u00e1raszt. Az amerikai t\u0151zsde m\u00e1r mocorog (de m\u00e9g messze nincs v\u00e9ge a medveszezonnak), akkor tal\u00e1n 1 \u00e9v m\u00falva m\u00e1r n\u00e1lunk is fog. \u00c9s ut\u00e1na tal\u00e1n a magyar gazdas\u00e1g is megindul.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yes, we do recommend to turn on Lock pages in memory so that OS doesn&#8217;t page SQL Server out. On 64 bit&#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,21,58],"tags":[],"class_list":["post-827","post","type-post","status-publish","format-standard","hentry","category-adatbazisok","category-szakmai-elet","category-sql-server-2005","category-sql-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/827","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=827"}],"version-history":[{"count":1,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/827\/revisions"}],"predecessor-version":[{"id":829,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/827\/revisions\/829"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}