Post reply

Slow Database

  • June 23, 2009 at 9:41 pm

    #155867

    Hi all,

    We have two database one test and other live.

    Test database running fine but due to high transaction on live database it is running very slow.

    I also created New database L1 and transfer every data from live to L1 and make all required changes.

    After 15-20min condition is same again

    DB is running very slow.

    What might be the problem?

    Thanks,

    Neerav

  • June 23, 2009 at 9:54 pm

    #1014406

    You might have a lack of memory, slow disks, poor code, too hard to tell.

    I'd suggest that you start with looking at heavily run queries and trying to tune them. Try to add indexes if you don't have them.

    Look for memory pressure (http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/analyzingmemoryrequirementsforsqlserver/2498/)

  • June 23, 2009 at 10:03 pm

    #1014412

    hi steve,

    i have checked memory,disk as far as codes and query tuning are concerned.They are also working fine from the past 5-7years.

    This is only thing which is confusing me

    HELP!!!

    Thanks,

    NEerav

  • June 24, 2009 at 12:09 pm

    #1014832

    Check indexes fragmentation and make sure statistics are updated.

    MJ

  • June 24, 2013 at 4:49 am

    #1626728

    number of users working on that database so kill the users who r working long time and check the long running queries and apply proper indexes ,joins and increase the performance of query or execute query in sql server profiler,check the fragmentation,lack of update statistics,or size of the database is filled

  • June 24, 2013 at 4:53 am

    #1626731

    Please note: 4 year old thread.

    p.s. killing long running queries is incredibly bad practice, certainly not something that should be recommended without explaining all the problems doing so can cause

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 2, 2013 at 5:37 am

    #1629004

    hie monster,

    can u please tell me what are the steps to check when a database is running slow?

  • July 2, 2013 at 6:14 am

    #1629018

    Please post new questions in a new thread. Thank you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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