SQL Server Performance

counter: Page life expectancy - my data

Discussion in 'Performance Tuning for DBAs' started by Akthar Hussain, Nov 9, 2011.

  1. Akthar Hussain New Member

    Hi,
    I am monitoring a sql Server database cluster. I have found the average Page life expectancy to be 10.4 minutes and the maximum value was 267.4 hours. I have monitored over 24000 one minute intervals and from these 65% occured at less then 300 seconds (5min). What does this indicate for the state of my SQL Server?
    For these intervals where the page life expectancy goes below 300 seconds the batch request per sec happens to be low at approximately 44 per second.

    From the above, I think that my SQL Server 2000 needs more memory - this would be difficult as server is windows 2003 (4gb memory of which 2gb to the operating system)
    Is there any advise or explanation as to what is going on?
    Akthar Hussain, Nov 9, 2011
    #1

  2. Luis Martin Moderator

    Are you using /3GB in boot.ini ?
    Luis Martin, Nov 9, 2011
    #2

  3. Akthar Hussain New Member

    no, at the moment there is no plan to as we plan to migrate to SQL 2008 on a win 2008 server. we want to have an understanding of what is going on and if our current SQL server 2000 platform is sufficient or doing ok.
    Akthar Hussain, Nov 9, 2011
    #3

  4. Luis Martin Moderator

    What I mean is:
    If you have 4GB with windows 2003 x86, you can add /3GB in boot.ini.
    After reboot, SQL can use 3GB and OS 1GB.
    That is the first step to review memory issues.
    Luis Martin, Nov 9, 2011
    #4

Share This Page