PiedPiper70
Registered User.
- Local time
- Today, 13:34
- Joined
- Oct 21, 2012
- Messages
- 115
Just upsized from Access FE/BE to Access FE and SQL Server 2014 BE. Never done this before but all seemed to go smoothly after some weeks of planning. And help from this forum. Went live yesterday.
Today about 100 Terminal Services users logged on this morning and all are moaning about speed, which is significantly slower than Access only. We haven't made any changes to the FE.
One of the key features of the system is the display of a multi-tab form which reads data in from about 10 different tables, and it's this which is annoying them the most. It used to take 1 to 2 seconds to populate the entire form and display it - it's now between 8 and 10!!
This performance drop from Access to SQL Server is completely unexpected. As I write, the hardware guy is looking into that side of things as a matter of urgency. So we don't know whether this sudden drop in performance is software or hardware related.
From the software point of view, can anyone please offer any assistance in any changes I can make, and quickly. I know this is a big ask but I'm under a lot of pressure here.
Any help really appreciated - and I do mean that. And the simpler the better as we are totally new to SQL Server. More info available if needed.
Thanks
Dave
Today about 100 Terminal Services users logged on this morning and all are moaning about speed, which is significantly slower than Access only. We haven't made any changes to the FE.
One of the key features of the system is the display of a multi-tab form which reads data in from about 10 different tables, and it's this which is annoying them the most. It used to take 1 to 2 seconds to populate the entire form and display it - it's now between 8 and 10!!
This performance drop from Access to SQL Server is completely unexpected. As I write, the hardware guy is looking into that side of things as a matter of urgency. So we don't know whether this sudden drop in performance is software or hardware related.
From the software point of view, can anyone please offer any assistance in any changes I can make, and quickly. I know this is a big ask but I'm under a lot of pressure here.
Any help really appreciated - and I do mean that. And the simpler the better as we are totally new to SQL Server. More info available if needed.
Thanks
Dave