We've been running a clustered system with 1200+ databases for some time now.
SQL Server is 2005 Entreprise running on 32-bit (upgrade from SQL 2000)
Since we upgraded our SSMS ( Only the SSMS, not the Database-Server ) from 2005 to 2008, loading all the databases takes 10-15 minutes. Before on the same server but with SSMS 2005 it took 30 seconds max and you did see them appear while they were loading.
Now it's like before in the Entreprise Manager where it took 10-15 minutes too.
It looks like next to doing a catalog, he also opens every database.
I've disabled IntelliSense to no effect.
Is this a known issue and is there a solution for?
PS : SSMS is still SP0, will install SP1 in a few weeks.