Post reply

Data tuning in SQL 2005

  • March 31, 2012 at 12:27 am

    #96713

    Sir/s,

    I'm using SQL 2005 and our Database size is 6.18 GB now and currently I'm facing problem of Timeout expired. Any quick tool which can release me from this error instantly. I'm also looking for Data tuning but not succeed. please help. we have 60 users connected to application and when this Timeout occurs, whole work stucks. I tried Shrinking and it works for 1-2 days and again the same problem occurs.

    Please Help

    Mukund

  • March 31, 2012 at 2:36 am

    #1467285

    Quick tool for you is to hire a professional who can help you identify performance problems and provide a solution.

    Alex Suprun

  • March 31, 2012 at 1:43 pm

    #1467336

    Alexander Suprun (3/31/2012)

    Quick tool for you is to hire a professional who can help you identify performance problems and provide a solution.

    There is no quick fix outside of hiring a professional to assess the problem and work through some resolutions.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 31, 2012 at 2:52 pm

    #1467345

    Shrinking is liable to make the problem worse, not better, as it severely fragments indexes.

    There's no quick fix, no magic switch or setting. Performance tuning is the process of finding the worst problems and fixing them, repeat until performance is acceptable.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

  • March 31, 2012 at 3:58 pm

    #1467354

    mukund.bklwh (3/31/2012)

    Sir/s,

    I'm using SQL 2005 and our Database size is 6.18 GB now and currently I'm facing problem of Timeout expired. Any quick tool which can release me from this error instantly. I'm also looking for Data tuning but not succeed. please help. we have 60 users connected to application and when this Timeout occurs, whole work stucks. I tried Shrinking and it works for 1-2 days and again the same problem occurs.

    Please Help

    Mukund

    Are you doing any nightly maintenance to the database? Which recovery model is your database using?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 9, 2012 at 1:35 pm

    #1470897

    this info is 2 handy

  • April 9, 2012 at 1:41 pm

    #1470905

    Definately look at the articles Gail references above in her post. You have a small database and not a whole lot of users.

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

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