Post reply

Enterprize manger not responding!!

  • June 23, 2010 at 1:25 am

    #97386

    Hi,

    i have SQL Server 2000 installed on Windows 2003 Server machine. once i expand the tree of instance nodes or specific db sub-nodes it's not responding. i tried out changing the option of auto close and auto shrink to off and installed SP4. this solve for some time but it get hanging again at last.

    one thing i noticed also, is when i installed SP4 and restart the severer i query the version in Query analyzer and got 8.00.194 meaning there is Sp installed at all !!

    any help please ?

  • June 28, 2010 at 6:24 am

    #1185669

    Doesn't sound right.

    Try and connect remotely from your PC (using Enterprise Manager) and see if it is still not responding (there may be an issue with MMC on the server).

    It's worth trying to install SP4 again and check the logs- looks like your previous install had some issues...

  • June 28, 2010 at 6:32 am

    #1185677

    Remember one of the design annoyances in Enterprise Manager was that when it starts, it iterates thru and opens every database....so if your server has a lot of databases, it takes a long time to open...it seems locked up, but in reality it is gathering the info from each database.

    setting autoclose to false helps a lot on all your databases, and of course you can connect with Query Analyzer instantly.

    SSMS gets the list of databases from master, but doesn't opens the database until you expand it, so it loads much faster.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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