Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Speed issue of a .NET Application using Windows SQL Server 2008

We have noticed an issue while using Windows SQL Server 2008 on a Computer running Windows 10.

With a specific configuration, we found that .NET applications using the Windows SQL Server 2008 will run about 10x slower.

Under these specific settings, your .NET applications will run about 10x slower:

  1. Your computer is installed with Windows 10
  2. Your have Windows SQL Server 2008 installed and .NET applications are using the server.
  3. The SQL Server is installed with the Default Instance Name.
  4. The .NET application is started as a User (rather than selecting Run as Admin) under an Admin account.

Under these settings, we noticed that .NET applications will run about 10x slower.

In order to avoid this, you can:

  1. Run the .NET application in Compatibility mode for Windows 7/8
  2. Run the .NET application as an Administrator (Select Run as Admin)
  3. Change the Instance name from the default instance name

This post first appeared on Xpress Software, please read the originial post: here

Share the post

Speed issue of a .NET Application using Windows SQL Server 2008


Subscribe to Xpress Software

Get updates delivered right to your inbox!

Thank you for your subscription