We have a new installation of SQL Server 2005. The server doesn't have access to the internet and we've disabled the checks for certificate revocation but don't want to continue to do this as it is dangerous. But are still having these really slow start times (upwards of 60 seconds).
It's normally slow to open the first time after you start up your computer, but should get faster after that.
The reason is that it uses the .Net framework for some things, and that's probably the only .Net framework app you use on your machine. So the first time, all those assemblies (dlls) need to be loaded as well.
But this happens only once. From then on they're cached, and even if that cache is paged to disk the retrieval isn't too bad.
This might work...
- Download the Certificate Revocation List from: http://crl.microsoft.com/pki/crl/products/CodeSignPCA.crl
- Create a path on a local web server for /pki/crl/products and put the CRL there.
- Create an entry on the hosts file (C:\Windows\System32\Drivers\etc) to put crl.microsoft.com to the IP address of that local web server.
change your SQL Server Management Studio shortcut to have the nosplash switch at the end. This will prevent the SSMS Splash window from appearing on loading, which reduces loading time a bit.
the default would be:
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" /nosplash
Another way to really speed up SSMS opening is right-click the shortcut for it, choose properties. Change the Target to this:
"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" -nosplash
The change is the addition of the -nosplash flag at the end. This will speed you up quite a bit opening. I learned this trick at SQL Saturday.