Search

SSMS tries to access disconnected network drives when in the Save File As wizard by Paul Randal

Closed
as Won't Fix Help for as Won't Fix

88
0
Sign in
 to vote
Type: Bug
ID: 651176
Opened: 3/13/2011 12:52:44 PM
Access Restriction: Public
1
Workaround(s)
3
User(s) can reproduce this bug
When saving files using the Save File As wizard, the underlying code is trying to connect to disconnected network drives. This results in extremely poor performance when using a slow network connection.

This behavior has been confirmed by many people, but I could not find a Connect item on it.

Every other application does NOT try to access disconnected network drives. Please fix this.

Thanks
Details (expand)
Product Language
English

Version

SQL Server 2008 SP1

Category

Tools (SSMS, Agent, Profiler, Migration, etc.)

Operating System

Windows 7 (all editions)
Operating System Language
US English
Steps to Reproduce
Create a network drive, e.g. in your home network.

Go online using a slow network connection that cannot see the disconnected network drive.

Open SSMS and try to save file. Navigate around the directory hierarchy and it will take multiple seconds between each click, with the Save File As box going white and unresponsive in between.

The problem disappears if the disconnected network drive is removed.
Actual Results
It takes multiple seconds between each directory navigation.
Expected Results
Directory navigation does not take multiple seconds.

Platform

X64
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 6/23/2011 at 6:08 AM
Hi Paul,

Thanks for reporting this issue.

We are sorry that you are experiencing this performance issue. SSMS 2008 SP1 uses Visual Studio 2005 Shell and we leverage File Save functionality provided to us by Shell.
This behavior is not directly controlled by us.

I have found related msdn connect issue which was logged against Visual Studio Shell team.
(Though this issue is reported for 2008 Shell, the same applies for Visal studio 2005 Shell)
http://connect.microsoft.com/VisualStudio/feedback/details/114463/slow-file-save-when-recent-files-projects-on-a-network-drive

I am going to close this issue as Won't Fix for now, if you have any concerns please feel free to re-open this issue.

Thanks,
Kamal
Posted by Microsoft on 3/13/2011 at 7:47 PM
Hi,

Thank you very much for your feedback. We will look into it and get back to you as appropriate.

Thanks,
Microsoft SQL Server
Sign in to post a workaround.
Posted by ozamora on 3/14/2011 at 12:51 PM
As per Paul, the only workaround is to remove the network drives altogether.
© 2012 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement