Post reply

troubleshoot slow response time in sql server 2000

  • January 31, 2011 at 6:39 am

    #230925

    Any easy way to find slow response time and long access to database??

  • January 31, 2011 at 7:00 am

    #1280393

    There is no real easy way. You will have to start looking at what bottlenecks are occurring. Is the server overloaded? Too much CPU/Memory/disk usage? Does the code run fast at different times and slow at others? Is there a network issue?

    Is everything slow or certain things?

  • January 31, 2011 at 7:04 am

    #1280402

    The CPU, Disk and Memory are all OK, so is the network 2

    Every month between 23 and 30, database access and response is very slow to and from the java application that is using a certain database.

    I have run a trace, but it doesnt show me too much

    Thanks

  • January 31, 2011 at 7:22 am

    #1280417

    You have to dig in further. What else is happening at that time? If you have a window, then focus there. What does the application do? Can you run that same code from SSMS at that time? Does it work well? Is a lot of data being requested and flushing the buffer pool?

    There won't be an easy way to do this, other than dig in and examine in detail what is happening on the server at that time.

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

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