Post reply

SQL Server running slow(disk io )

  • 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 7 posts - 1 through 8 (of 8 total)

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