Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to one SQL box is slow but not another

Status
Not open for further replies.
DonS100

DonS100

Programmer
Dec 4, 2001
104
US
Hello, I've just starting moving SQL Server 2000 databases to a new SQL Server. The databases are using a front-end Access 97 application which the user picks which database to use.

Yesterday, when the application linked to the new server it was running slow but linking to databases that were still existing on the old server were fine. I made some changes to the new box last night but it didn't appear to help.

Overnite both SQL boxes were rebooted and the application works quickly against the new server but now runs slow against the old SQL server. I didn't make any changes to the old SQL server.

Any clue what would influence only allowing the application to work fine against one server at a time?

Thanks

Don
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
471
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
407
CodeWell
CodeWell
TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
301
TheBugSlayer
TheBugSlayer
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
327
dgillz
dgillz
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
328
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top