{"id":844,"date":"2009-04-30T18:31:19","date_gmt":"2009-04-30T17:31:19","guid":{"rendered":"http:\/\/soci.hu\/blog\/?p=844"},"modified":"2009-04-30T18:31:19","modified_gmt":"2009-04-30T17:31:19","slug":"read-only-filegroup-hogy-ne-lock-oljon-az-sql-server-nem","status":"publish","type":"post","link":"https:\/\/soci.hu\/blog\/index.php\/2009\/04\/30\/read-only-filegroup-hogy-ne-lock-oljon-az-sql-server-nem\/","title":{"rendered":"Read-only filegroup, hogy ne lock-oljon az SQL Server? Nem."},"content":{"rendered":"<p>Az egyik MCP vizsg\u00e1n c\u00e9loztak arra, hogy ha egy adatb\u00e1zis valamely filegroupj\u00e1t read only-v\u00e1 tessz\u00fck, akkor nem fog lockokat r\u00e1rakni a szerver, hisz minek, \u00fagyse lesznek m\u00f3dos\u00edt\u00f3 folyamatok.<\/p>\n<p>Nos, ez elm\u00e9letileg \u00edgy lehetne, <a href=\"http:\/\/blogs.msdn.com\/sqlserverstorageengine\/archive\/2007\/01\/08\/read-only-filegroups-and-locking.aspx\">de nem \u00edgy van<\/a>. Ha az eg\u00e9sz adatb\u00e1zis read only, akkor viszont t\u00e9nyleg nem lockol, ami adhat n\u00e9mi teljes\u00edtm\u00e9ny nyeres\u00e9get.<\/p>\n<p>M\u00e1sra az\u00e9rt j\u00f3:<\/p>\n<p>Read-only filegroups, They provide you the following three benefits:<\/p>\n<p>   1. Can be compressed (using NTFS compression)<br \/>\n   2. During recovery you don\u2019t need to apply logs to recover a read-only file group<br \/>\n   3. Protection of data from accidental modifications<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Az egyik MCP vizsg\u00e1n c\u00e9loztak arra, hogy ha egy adatb\u00e1zis valamely filegroupj\u00e1t read only-v\u00e1 tessz\u00fck, akkor nem fog lockokat r\u00e1rakni a szerver,&#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-844","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\/844","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=844"}],"version-history":[{"count":2,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/844\/revisions"}],"predecessor-version":[{"id":846,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/posts\/844\/revisions\/846"}],"wp:attachment":[{"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/soci.hu\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}