Connection to SQL Server 2008 R2 Database Server is SLOW

Posted by AbeP on Server Fault See other posts from Server Fault or by AbeP
Published on 2014-05-31T05:55:28Z Indexed on 2014/05/31 9:30 UTC
Read the original article Hit count: 453

Filed under:

windows-server-2012

|

sql-server-2008-r2

|

slow-connection

|

database-connection

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!

© Server Fault or respective owner

Related posts about windows-server-2012

Can't upgrade Windows Server 2012 Essentials to Windows Server 2012 R2 Essentials

as seen on Server Fault - Search for 'Server Fault'
So today was RTM of Windows Server 2012 R2 Essentials released. I immediately tried to do an in-place upgrade of an existing RTM 2012 Essentials to RTM 2012 R2 Essentials, but get: Windows Server 2012 Essentials cannot be upgraded to Windows Server 2012 R2 Essentials. You can choose to install… >>> More
Top 31 Favorite Features in Windows Server 2012

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Over the past month, my fellow IT Pro Technical Evangelists and I have authored a series of articles about our Top 31 Favorite Features in Windows Server 2012. Now that our series is complete, I’m providing a clickable index below of all of the articles in the series for your convenience, just in… >>> More
Windows Azure: Announcing Support for Windows Server 2012 R2 + Some Nice Price Cuts

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Today we released some great updates to Windows Azure: Virtual Machines: Support for Windows Server 2012 R2 Cloud Services: Support for Windows Server 2012 R2 and .NET 4.5.1 Windows Azure Pack: Use Windows Azure features on-premises using Windows Server 2012 R2 Price Cuts: Up to 22%… >>> More
A SpecTECHular follow-up: Windows Server 2012 #HyperV, #SysCtr 2012 and #Windows8

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Last week, I had the pleasure of presenting at the New Horizons SpecTECHular events (www.spectechular.com) in Cincinnati and Dayton OH. It was great meeting some very engaged IT Pros and discussing the new features of Windows Server 2012 Hyper-V, System Center 2012 / Private Cloud, and Windows 8… >>> More
Windows Server 2012 sera disponible en quatre éditions : Foundation, Essentials, Standard et DataCenter

as seen on Developper.com - Search for 'Developper.com'
Windows Server 2012 sera disponible en quatre éditions Foundation, Essentials, Standard et Datacenter, Microsoft dévoile les prix de l'OS Windows Server 2012, la prochaine version du système d'exploitation serveur de Microsoft sera officiellement disponible en quatre éditions : Foundation… >>> More

Related posts about sql-server-2008-r2

SQLAuthority News – SQL SERVER 2008 R2 Pricing

as seen on SQL Authority - Search for 'SQL Authority'
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing. Official site: What’s New in SQL Server 2008 R2 Editions Editions Per Processor PricingRetail Per Server Plus CAL PricingRetail Parallel Data Warehouse $57,498 Not… >>> More
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)

as seen on SQL Authority - Search for 'SQL Authority'
SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced… >>> More
SQLAuthority News SQL SERVER 2008 R2 Pricing

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I was recently asked question about SQL Server 2008 pricing. I have bookmarked official site here which lists the pricing.Official site: What’s New in SQL Server 2008 R2 EditionsEditionsPer Processor PricingRetailPer Server Plus CAL PricingRetailParallel Data Warehouse$57,498Not offered via Server… >>> More
Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative… >>> More
Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

as seen on SQL Blog - Search for 'SQL Blog'
Many people like me want (or need) to do their business intelligence development work on a laptop. As someone who frequently speaks at various events or teaches classes on all subjects related to the Microsoft business intelligence stack, I need a way to run multiple server products on my laptop with… >>> More