SQL performance problems.
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....
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....
ASKER
can you tell me how to check that please? Thanks
Edited that in -- please refresh me earlier comment :-).
ASKER
thanks no change
Idk what that means, "no change". It was set to "on", you've changed it to "off", and it's still slow? It wasn't set "on"?
ASKER
sorry speed is the same.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select * from sys.databases where is_auto_close_on = 1