We have the following installation :
4 companies, 2 databases (2x2 companies)
Each SQL DB is hosted on a different SQL Server.
SQL1 has 16 gb RAM
SQL2 has 4 gb RAM
Both SQL Servers runs :
Windows Server 2003 R2 SP2
Microsoft SQL Enterprise Manager V8.0
The Network cards are the same, with the same driver.
The users are balanced on 5 TSE servers.
The Database hosted on SQL1 has good response times directly on the server. It becomes very slow thgrough TSE. The SQL2 hosted DB has quite the sames response times on the SQL console and through the TSE.
We tried to backup and restore the DB from SQL1 to SQL2 and the response times were very good through TSE, so this doesn't come from the DB.
Do you have any idea of what could help ?
Incadea (Vertical solution for the automotive market based on Nav 2.60)
French speaking European/African/Indian Ocean countries.