Why does having an active MS-SQL Server Database intermittently suspend the loading sequence of non-systems software at startup? Even with my Max-IOPs drive, it still hangs for a minute 3 out of every 4 or so system start-ups. This isn't an error, this much I know. It is simply a by-product of activity that I have never looked deeper into and am really curious as to the cause.

 

**posting here before stackoverflow**

Don't know much about it but found this which may be helpful :- http://www.virtualobjectives.com.au/sqlserver/ssms_slow.htm

That actually makes sense, because the only programs it affects at startup are programs that want to connect to the internet. It does look as though it is searching for something.

 

But that is SSMS, not the server itself.

 

I've never had issues with SSMS . . .

 

Meh, I'll go post on MSDN. The gurus should have an answer.

If the attachment seems relevant then the following from Microsoft might be useful:- http://support.microsoft.com/kb/822219

Edited February 9, 201213 yr by TonyMcC

Well I posted a thread on MSDN, so maybe they can give me the low down, with a bit of smackdown. Thanks for taking a boo TonyMcC!