We are running an application that uses a SQL database. Users are complaining the application runs slow. For example to just start the application it takes between 40 and 50 seconds.
We have a standalone dedicated SQL 2008 server with plenty of horse power and its not overloaded.
The clients are running on powerful terminal severs as well. Again with plenty of horse power and resources.
during the 40 to 50 second delay both the application server and the SQL server are not busy at all. In fact utilization is extremely low.
As a test I installed the application on an older server using the exact same data only this time the application and the SQL server are running on the same machine. And now bam!! it runs so fast. start up is less the 2 seconds.
Does this mean I have problems or the application itself is the problem when opening a database on a remote server?
I have tested everything I can think of such as disabling antivirus with no luck so far.
Application support says while it would be faster running the SQL locally we should not be seeing such a huge difference but they have no real ideas on how to fix. they mostly talk about resources which I have plenty of.
Thanks in advance for your help....