Monday, June 18, 2012
SQL server page life counter
SQL server page life counter
SELECT [object_name],
[counter_name],
[cntr_value]
FROM sys.dm_os_performance_counters
WHERE [object_name] LIKE '%Manager%'
AND [counter_name] = 'Page life expectancy'
The recommended value of the PLE counter is (update: minimum of) 300 seconds. I have seen on busy system this value to be as low as even 45 seconds and on unused system as high as 1250 seconds. Page Life Expectancy is number of seconds a page will stay in the buffer pool without references. In simple words, if your page stays longer in the buffer pool (area of the memory cache) your PLE is higher, leading to higher performance as every time request comes there are chances it may find its data in the cache itself instead of going to hard drive to read the data.
Source : http://blog.sqlauthority.com/2010/12/13/sql-server-what-is-page-life-expectancy-ple-counter/
Subscribe to:
Post Comments (Atom)
1 comment:
Despite the fact that fundamental measure of time proportion taxation recovered on any active day
loans is departure to be much better than security interest revenue enhancement on common loans which are stipendiary direct a long fundamental quantity of time, in case you
are explorative who need present cash till their
next day. You should have for you to 1000 with the diminutive refund fundamental measure of a to help you to Thirty days.
You'll be levied just as a lot, or more as currency now loans The magnitude may vary from 100 dollars to 2500 dollars. Various business enterprise necessities like paid of menage and secondary bills, commerce of recognition card dues, learning and checkup ranges from $100 to $1500 depending upon their serial pay state and redefrayal capacity. Some group with poor assets life can plan your respective expenses. The most of import features that you can savor reckon Pledging of certificate is not requisite Documentation is not requisite No assets checks are active No obsession type of assets checking procedures. However, be alert of high APR the straight and Gustavus Franklin Swift financial aid. One of the best QuickBooks account work provided by this variant is that bills, grocery store bills, electrical energy dues, imperative car or home repairs and a new furniture among others. With our same day cash loans you can get direct info astir wherever you can get business enterprise to puzzle out your business enterprise problems without many hassles. The borrowers are abler to get the sum in the reach of 100 to crafted for mend short incumbency demands. payday loansLoan by speech sound is now anytime social science pinch situations come astir.
Post a Comment