How can we help you today? How can we help you today?

Slowness/Delay when modifying stored procedures in SSMS

I'm experiencing a long delay every time i do the following:

In the Object Explorer, I right click on a stored procedure and select modify.

The sp appears in the right as normal and then a sql prompt window pops up in the lower right of my screen that says saving snapshot.

The saving of the snapshot then takes anywhere from 5-15 seconds and i must wait for it to finish before i can do anything in SSMS.

This meant that yesterday when trying to modifying around 20 stored procedures i actually gave up and used a different machine because the delay made doing so on the machine with SQL Prompt unworkable.

thx.
r-
vreeland
0

Comments

1 comment

Sort by
  • Tilman
    Hi,

    Thanks for posting.
    The sp appears in the right as normal and then a sql prompt window pops up in the lower right of my screen that says saving snapshot.

    The saving of the snapshot then takes anywhere from 5-15 seconds and i must wait for it to finish before i can do anything in SSMS.

    The problem is 2 fold. a) it is caching the db everytime you open a query window, which of course is not necessary, b) it shouldn't freeze while saving the snapshot. Both these issues will be addressed in the final release.
    This meant that yesterday when trying to modifying around 20 stored procedures i actually gave up and used a different machine because the delay made doing so on the machine with SQL Prompt unworkable.

    Sorry about that. You can disable SQL Prompt via the Options dialog.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.