{"id":542,"date":"2008-07-17T08:28:50","date_gmt":"2008-07-17T07:28:50","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=542"},"modified":"2008-07-17T08:28:50","modified_gmt":"2008-07-17T07:28:50","slug":"sql-server-2008-analysis-services-windows-server-2008-on-vs-windows-server-2003-on","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2008\/07\/17\/sql-server-2008-analysis-services-windows-server-2008-on-vs-windows-server-2003-on\/","title":{"rendered":"SQL Server 2008 Analysis Services Windows Server 2008-on vs. Windows Server 2003-on"},"content":{"rendered":"<p>Hab\u00e1r nem \u00e9rtek az Analysis Serviceshez (m\u00e9g, az SSIS ut\u00e1n ez a k\u00f6vetkez\u0151 falat), de <a href=\"http:\/\/sqlcat.com\/technicalnotes\/archive\/2008\/07\/16\/running-microsoft-sql-server-2008-analysis-services-on-windows-server-2008-vs-windows-server-2003-and-memory-preallocation-lessons-learned.aspx\">ez a cikk<\/a> igen \u00e9rdekes. Nem annyira az SQL-es, ink\u00e1bb az operendszeres vonatkoz\u00e1sai miatt.<br \/>\nAz \u00e1tlagfelhaszn\u00e1l\u00f3 az \u00faj Windowsokb\u00f3l csak az \u00faj shellt tapasztalja meg, meg, hogy t\u00f6bb ram kell nekik. Ennek ellen\u00e9re a h\u00e1tt\u00e9rben kem\u00e9nyen fejlesztik a rendszer magj\u00e1t, csak az nem annyira l\u00e1tv\u00e1nyos, m\u00e9g, ha igen hasznos is.<br \/>\nA cikkben arr\u00f3l besz\u00e9lnek, hogy a Windows 2008-ban \u00faj mem\u00f3riakezel\u0151 van, ami sokkal jobban kezeli a sok, apr\u00f3 mem\u00f3riafoglal\u00e1st. Ez azonnal l\u00e1tszik, ha az Analysis Services-szel dolgoztatunk fel jelent\u0151s mennyis\u00e9g\u0171 adatot, a 2008-on kap\u00e1sb\u00f3l dupla olyan gyors lett a feldolgoz\u00e1s (tudom, minden teszt csal, de nem hiszem, hogy nagyot hazudn\u00e1nak).<br \/>\nA szerviznek meg lehet mondani, hogy el\u0151re allok\u00e1lja le a mem\u00f3ri\u00e1t, \u00edgy 2003-on is hasonl\u00f3 teljes\u00edtm\u00e9nyt  \u00e9rhet\u00fcnk el, mint 2008-on.<\/p>\n<p><img src='http:\/\/sqlcat.com\/blogs\/technicalnotes\/WindowsLiveWriter\/Run.WindowsServer2003andMemoryPreallocat_8B27\/image_6.png' alt='' class='aligncenter' \/><\/p>\n<p>Az eg\u00e9szb\u0151l sz\u00e1momra az az \u00e9rdekes, hogy gyorsabb Windows 2008-ban a mem\u00f3riakezel\u00e9s, amib\u0151l b\u00e1rmilyen app profit\u00e1lni fog. Megvett\u00fck. :)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hab\u00e1r nem \u00e9rtek az Analysis Serviceshez (m\u00e9g, az SSIS ut\u00e1n ez a k\u00f6vetkez\u0151 falat), de ez a cikk igen \u00e9rdekes. Nem annyira&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,6,4,30,21,58,55,54],"tags":[],"class_list":["post-542","post","type-post","status-publish","format-standard","hentry","category-architektura","category-adatbazisok","category-szakmai-elet","category-sql-server","category-sql-server-2005","category-sql-server-2008","category-windows","category-windows-server-2008"],"_links":{"self":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/542","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=542"}],"version-history":[{"count":0,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/542\/revisions"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=542"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=542"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}