{"id":454,"date":"2021-04-09T08:09:19","date_gmt":"2021-04-09T08:09:19","guid":{"rendered":"https:\/\/datarebus.com\/?p=454"},"modified":"2021-05-27T08:29:40","modified_gmt":"2021-05-27T08:29:40","slug":"page-life-expectancy","status":"publish","type":"post","link":"https:\/\/datarebus.com\/index.php\/2021\/04\/09\/page-life-expectancy\/","title":{"rendered":"PAGE LIFE EXPECTANCY"},"content":{"rendered":"\n<h2><\/h2>\n\n\n\n<p>SQL Server i\u00e7in tan\u0131mlanan memory alan\u0131 ne kadar yeterli sorusuna en iyi cevab\u0131 verecek olan sorgudur. PLE \u00f6zetle, cache \u00fczerinde bir verinin ne kadar s\u00fcre kald\u0131\u011f\u0131n\u0131 g\u00f6sterir. E\u011fer bu s\u00fcre uzun ise sorun yok. Ama k\u0131sa ise bu datan\u0131n devaml\u0131 olarak cache \u00fczerinden diske aktar\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir. Bu da biraz daha memory ihtiyac\u0131na en iyi ipucudur. Di\u011fer taraftan b\u00fcy\u00fck veri \u00e7eken sorgular\u0131n \u00e7al\u0131\u015ft\u0131r\u0131l\u0131yor olmas\u0131 PLE de\u011ferini d\u00fc\u015f\u00fcr\u00fcr.<\/p>\n\n\n\n<p>SQL kitap\u00e7\u0131klar\u0131nda bu de\u011ferin &gt;300 olmas\u0131 talep edilir ama g\u00fcn\u00fcm\u00fczdeki RAM b\u00fcy\u00fckl\u00fcklerine bakar isek 300 bence biraz d\u00fc\u015f\u00fck.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\"><p>SELECT<\/p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; *<\/p><p>FROM sys.dm_os_performance_counters<\/p><p>WHERE dm_os_performance_counters.object_name LIKE \u2018%Buffer Manager%\u2019<\/p><p>AND dm_os_performance_counters.counter_name = \u2018Page life expectancy\u2019;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server i\u00e7in tan\u0131mlanan memory alan\u0131 ne kadar yeterli sorusuna en iyi cevab\u0131 verecek olan sorgudur. PLE \u00f6zetle, cache \u00fczerinde bir verinin ne kadar s\u00fcre kald\u0131\u011f\u0131n\u0131 g\u00f6sterir. E\u011fer bu s\u00fcre uzun ise sorun yok. Ama k\u0131sa ise bu datan\u0131n devaml\u0131 olarak cache \u00fczerinden diske aktar\u0131ld\u0131\u011f\u0131n\u0131 g\u00f6sterir. Bu da biraz daha memory ihtiyac\u0131na en iyi ipucudur. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,16],"tags":[],"_links":{"self":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/454"}],"collection":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/comments?post=454"}],"version-history":[{"count":1,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/454\/revisions"}],"predecessor-version":[{"id":455,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/posts\/454\/revisions\/455"}],"wp:attachment":[{"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/media?parent=454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/categories?post=454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datarebus.com\/index.php\/wp-json\/wp\/v2\/tags?post=454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}