How Do I resolve SSMS 'is busy" issue

  • Hi Folks

    I thought I had asked this before but cannot seem to find it.

    Anyway I am really getting frustrated with this "is busy" error everytime I save a Maint Plan in SQL Server 2005 (64-bit) on a 64-bit Windows 2003 R2 Server.

    Does anyone know how to resolve this issue ?

    Thanks

    Jim

  • Unfortunately it looks as though this is one of those things you just need to live with.

    This post from MSDN should provide a little more insight ...

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/11cd657e-c767-4d37-b0c2-793c2afe38aa

    I have also noticed this message when using the designer in BIDS and other Visual Studio environments. In my opinion it is better to be informed than just have things freeze up like the good old days of Enterprise Manager.

    ** EDIT ** Ignore my post. I missed that you were looking for a solution, not an explantion. Sorry ** EDIT **

  • What service pack are you running?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • This is an annoying bug (in my opinion) that has a non-traditional fix. If you are designing, which it sounds like you are and it hangs with the "busy" sign, right click the Sql server management studio in the Windows Task Bar. Thats it... It works for me when Sql server says its busy while editing a Diagram

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • Now that's an interesting fix... I'll have to remember it and see if it works the next time I come across that issue.

    I don't use the Designer much though, so rarely run across the problem.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • I can't explain it, as I stated, but I know it works.

    Some times we just don't need to ask why, just know that it works.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • Hi Brandie

    I am on SP3

    Jim

  • Thanks Everyone for the assist

    Jim

  • Jim,

    Did Chris's solution work for you? Or are you still having the problem?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • I was curious but didn't want to bother him. But now that you have asked, my curiousity is piqued.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • Hi Brandie

    have not tried it yet

    let me see and get back to you

    Jim

  • H IBrandie

    right-clicking on

    Sql server management studio in the Windows Task Bar

    DID NOT WORK for me doing these twp tasks

    made several MP changes and saved (most saved without busy message)

    made several rename changes of MP (about 50/50 getting busy msg)

    Jim

  • Okay, I'm going to ask again. What service pack (and version) of SQL Server are you running?

    EDIT: And how much RAM are you running on the machine you're working from? Also check the Paging File size. Post both here.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie

    Your previous question(s) were answered above but I will add it again as well as the other requests:

    OS:

    Microsoft Windows Server 2003 R2

    Enterprise x64 Edition

    Service Pack 2

    Quad-Core AMD Opteron

    Processor 2356

    2.30 GHz 16.0 GB of RAM

    SQL Server:

    SQL Server 2005

    Microsoft SQL Server Developer Edition (64-bit)9.0.4053 SP3

    SSMS settings:

    Minimum server memoey [in MB]: 12288

    Maximum server memory [in MB]: 12288

    Page File:

    Page File: Available: 24,576 MB

    Jim

  • JC-3113 (9/22/2010)


    Brandie

    Your previous question(s) were answered above but I will add it again as well as the other requests:

    You didn't have service pack in there. I was thinking it might be an SP issue (there was a maint. plan issue with SP1), but you're upgraded past that point. And it's not a paging file issue, which was my next thought.

    What do the plans that are "busy" have in common? Is there a specific task in each of them that's not in the plans that are saving correctly?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 1 through 15 (of 22 total)

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