Friday, February 17, 2012

Execution Plan Creation: Freezing of SQL Server 2005 Management Studio Application

From time to time...while using SQL Server 2005 Management Studio Application the entire application will 'freeze' during some specific activities. Primarly this happens while using the GUI Tool to rebuild all of the indexes or when you are having SQL Server also create the execution plan of a set of queries while executing the queries.

It happens consistently and on several different machines here in the office.

Is a new version of the Management Studio tool planned for a release in the next few months What can be done now to get around the problem?

Thank you.

...cordell...

Management Studio isn't supposed to block user input even when queries are running, so any long freezes would be a defect. Could you please file a defect report for this on http://connect.microsoft.com? Defects reported on the connect site go directly into the team's defect tracking system so we don't lose any information. Customer reported issues have additional weight when we are prioritizing future work.

How frozen is Management Studio? Does it come back after a while, or is it hung forever? If it comes back, how long does it take before it becomes responsive again?

Other than service packs, I'm not aware of any new releases of Management Studio planned before the next major SQL Server release.

As for workarounds, I know it would be less than ideal, but if you know Management Studio is going to be unresponsive for a while, you could start a second instance of Management Studio so you can keep working while the first one is blocked.

Hope this helps,
Steve

No comments:

Post a Comment