New answers tagged sql-server-2008
I thought I would post my experience with this issue. Symptoms - SQL Server 2008 R2, on Dell machine, suddenly suffered huge performance degradation. User applications became very slow when performing queries. Activity monitor would start - but the above process timeout error would occur if you tried to open the process list. Restored backups of the ...
Just delete (rename) registry key: HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server via (http://blog.dotsmart.net/2012/01/04/solution-for-package-microsoft-sql-management-studio-package-failed-to-load)
@Oskar, We have a very similar VMware based SQL Server setup and had this same issue however for us this freeze up would happen only for the very first remote connection made since the last time the Server had restarted. It mattered not what user we used to connect or if we used RDP or VMware's on remote connectivity. The very first remote login attempt ...
C can only be expanded onto part of the same drive. In fact, C can only be expanded onto contiguous free space on the same drive. Todd Wilcox is right that Windows Server 2012 shouldn't take 250 GB of space. It sounds like you might have SQL Server installed on C, and perhaps your databases are getting large. If so, you can easily move your databases ...
Top 50 recent answers are included