Post reply

Application performance issues

  • March 11, 2004 at 11:13 am

    #152070

    Hi,

    Is any one can through some ideas how to deal with this issue.

    I have application which is running some times but some it will have sole performance i.e., some queries run fine some times, but some times when we run it takes some time.

    Can you please help me out.

    Venkatesh


    venkatesh

  • March 12, 2004 at 2:40 am

    #498456

    A question formulated like this is very difficult to answer.

    You have to check a lot of parameters while you app is running slowly:

    • deadlocks
    • all other database activities
    • do you have any other application installed on the same box as your sqlserver?
    • If yes is ths running at that time? (Could it cause the problem?)
    • file autogrow/autoshrink
    • number of active users
    • CPU/memory utilisation
    • cache hit ration
    • waits
    • fragmentation's status
    • ...

    As you can see there is a lot of possibilities why something is performing poorly.

    Also you have to check if this is EXACTLY the same code (SP or T-SQL) running slowly or just an another. In this case check the plan if you are using the apropriate indexes



    Bye
    Gabor

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

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