We help IT Professionals succeed at work.
Get Started

SQL Server 2005 running VERY slowly on new hardware

337 Views
Last Modified: 2017-05-15
I've migrated a legacy (XP) SQL Server 2005 application to new hardware which it supposedly much faster than the previous implementation. Indeed, GUI response is clearly faster. However, SQL Server responses continually timeout.

The system was, and is running on XP with SQL Server 2005. The application is Access/VBA with SQL Server 2005 backend. The Access/VBA apps (.ade) can run locally on the XP, but more commonly they run from remote workstations and connect via network to the SQL Server host. Remote workstations are generally Windows 7.

As this is a legacy application, pretty much all of the tables accessed really reside on an SQL Server 2014 host where the new app replacing this legacy one resides. The tables are accessed via views on the 2005 server. For example:

CREATE view [dbo].[tblPaLaborClass] as
select memberType as laborClass, description, null as ts from [dbserver\MEMBERSLINK].hprs.dbo.memberTypes

The new platform was created by using Acronis Restore to copy an exact image from the old system to the new platform, so the XP version, SQL Server version, etc are supposedly identical. Even though the new system is apparently faster, yet queries via the Access/VBA app always timeout, whether local of remote. A remote query with Java takes 50 seconds to return -- which is too long for the Access/VBA app which simply gives a "Timeout expired" message after 30 seconds.

How can I figure out where the bottleneck is? I've been working on this for days.
Comment
Watch Question
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
Unlock 1 Answer and 22 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE