The hard disks should have nothing to do with it. I just checked my machine, and I have set the hard disks to be turned off after 20 minutes, and I never have the problem that Rich describes. True, I am not running SSMS 2008 R2, but the hard disks have nothing to due with the communication between SSMS and SQL Server. I do have the Sleep setting set to Never.
I think that as long as Rich works on the machine, the connection to SQL Server should stay alive.
I think it is worth checking the SQL Server errorlog when this happens. Is there a dump or some other message indicating that the connection has been lost? Also, check when SQL Server started - maybe something/someone restarts SQL Server? Furthermore, check the autoclose setting for the database.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment