Post reply

SQL Server running slow(disk io )

  • July 27, 2011 at 7:54 am

    #254358

    Hi,

    I have SQL Server 2008 which is running on Windows server 2008 R2 enterprise edition(64 bit).It has 72GB of ram.

    SQL Server configuration :

    Min server memory : 0

    Max Server memory :46080

    But when i monitor CPU utilization from Task manager it is aroung 20-25(Avg),SQLSERVR.EXE is using 46GB of memory.

    I am using SP_WHO4 to monitor sessions.I have noticed that DISK IO for Running queries is high.

    I have some of the observation from perfmon.they are as given below(all are AVGvalus for certain period of time) :

    % Disk time= above 5

    % Disk read time =Above 8

    % Disk write time = 0.624

    Avg disk queue lenght = 02147

    Do i need to increase max server memory in case to avoid performance problem??

    THANKS,

    Akshay

  • July 27, 2011 at 9:08 am

    #1359359

    What is your disk configuration? Where does the Log and Data file reside? By increasing the memory, it might give you a small respite to the sluggishness of the server but it will come back when it has to do reads and writes to your DB. That is why I asked about your disk configuration.

    -Roy

  • July 27, 2011 at 1:03 pm

    #1359618

    in order to determine if its a Disk or Ram issue check, Page life expectancy, min requirements is 500. This tells you that the pages are staying in the buffer for 5 min., 1,000 sec would be even better(10 min).

    But anything less then 500 you need more RAM, if its high and you are still experiencing slowness then you need to refer to the thread above and start looking at DISK.

  • July 27, 2011 at 1:06 pm

    #1359620

    456789psw (7/27/2011)

    in order to determine if its a Disk or Ram issue check, Page life expectancy, min requirements is 500. This tells you that the pages are staying in the buffer for 5 min., 1,000 sec would be even better(10 min).

    But anything less then 500 you need more RAM, if its high and you are still experiencing slowness then you need to refer to the thread above and start looking at DISK.

    500 sec = 8 minutes 20 sec

    1000 sec = 16 min 40 sec

  • July 27, 2011 at 1:33 pm

    #1359629

    correct sorry its actually 300 sec..is the standard

  • July 28, 2011 at 3:17 am

    #1359876

    Hi,

    I have searched for PLE counter in perfmon.can you please suggest me where i can locate that counter??

    Thanks

    Akshay

  • July 28, 2011 at 3:21 am

    #1359879

    Hi Roy,

    My DB files(mdf.ldf)is located on local drive.Does LDF file size make any impact on DML& DDL operations????

    Because ldf file size for each of the database is above 100GB.

    Thanks

    Akshay

  • July 28, 2011 at 5:34 am

    #1359951

    aksh.2411 (7/28/2011)

    Hi Roy,

    My DB files(mdf.ldf)is located on local drive.Does LDF file size make any impact on DML& DDL operations????

    Because ldf file size for each of the database is above 100GB.

    Thanks

    Akshay

    Please read both of those and ACT quickly to solve your issue while it's still easy to fix!

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    http://www.sqlservercentral.com/articles/64582/

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply