Connection to SQL Server 2008 R2 Database Server is SLOW
- by AbeP
The database server is a VM running SQL Server 2008 R2 on top of Windows Server 2012, 24GB RAM allocated and 2TB of disk space.
Overall, the database connections are very slow and one thing that stands out is that the connection to the database server via SSMS takes 5-10 seconds.
On other much less powerful servers, it takes 1-2 seconds.
The VM is technically way more powerful than other machines, but the connection to the server is too slow.
So, my guess is the issue is network related, but any clues on where I should be looking?
Thanks!