Post reply

Time outs

  • July 14, 2008 at 4:27 pm

    #193902

    database is indeed not a big. only 6.5 Giga now. I know programming is one of the issue in this scenario

    But users need immediate solution till programming will redefine.

    please suggest how I can tune up the database to give in time response. I already increased the timeout period. but still getting timeout.

  • July 15, 2008 at 10:47 am

    #843245

    You will have to find why it is timing out. (bad code, bottlenecks, no indexes, ...)

    Execute sp_who2 will show you a list of connections and if they are blocked. Sql Profiler can show you a list of sql commands passed to the server.

    For further details

    read

    http://www.sql-server-performance.com/articles/audit/perform_performance_audit_p1.aspx

  • July 15, 2008 at 10:59 am

    #843257

    There's no magical quick-fix for performance problems. You are going to have to find the poorly performing queries (run profiler for an hour or so and catch all the queries going to the server) and fix them. My guess is the problems are caused by bad code, bad indexing or both.

    Once you have the profiler trace, load it into a table and look for the 5 worst performing queries and fix them to run faster. Repeat the capture, identify, fix until performance is acceptable. Don't try to tune everything in one go.

    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 15, 2008 at 4:35 pm

    #843452

    Thanks for advise.

    How to apply sql profiler on table and what contents to select.

    Pl advise

  • July 15, 2008 at 5:23 pm

    #843460

    You may want to refer to sys.dm views and functions for example sys.dm_exec_query_stats from BOL

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eb7b58b8-3508-4114-97c2-d877bcb12964.htm This reports among other items the Total elapsed time, in microseconds, for completed executions of this plan.

    Querying this and other sys.dm views and functions might yield you the data you need in the shortest period of time.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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