Post reply

SSMS Taking too much time to expending the list

  • March 16, 2010 at 2:11 am

    #217803

    Hi,

    I have a instance having aroud 600 Databases.

    When I connect using SSMS on the local machine then expend the Databases node is take so much time to expend. But when I try to same on another SSMS (another machine) it expends very quickly.

    I am trying it by 1. User localhost & windows Authentication, 2. Server IP & windows Authentication, 3. Server IP & SQL Authentication.

    Please suggest if someone facing the issue or having the solution

    Ram
    MSSQL DBA

  • June 15, 2010 at 1:19 am

    #1180225

    Hi All,

    I find out the solution and root cause it.

    Please find the solution as attachment.

    Ram
    MSSQL DBA

  • June 15, 2010 at 2:27 am

    #1180253

    Thanks for sharing the info 🙂

  • June 24, 2010 at 1:38 am

    #1184354

    Dude,

    Thank you very much to share such issues with solutions

    I Really Appreciate Your Effort.

    Keep Posting

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

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