Results 1 to 3 of 3

Thread: SQL Server slow

  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Unanswered: SQL Server slow

    Hi,

    I am having a problem accessing my sql server database using either Enterprise Manager or Query Analyser. It is awfully slow. Each time I click to expand a database in Enterprise Manager it takes about 25mins to do anything. I was running a DTS package yesterday which failed and have had this problem since. If I access the database via my app everything seems to be running at a normal speed. If I go to my task manager the sql server process is using up 750MB of memory and 750MB of virtual memory??

    Has anyone seen this and know how to fix it???

    Thanks in advance

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    did you try rebooting the client?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2005
    Posts
    3

    Solved

    Thanks for the reply Brett. I seemed to have just sorted out the problem. I managed to get into Query Analyzer and found a process that was chewing up all the memory. Not too sure how it got there but I suspect it may have been some sort of transaction that was rolling back as it was still there after a reboot. Managed to kill the process and then drop the database and instantly everything came back to us.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •