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....
LVL 2
Zoldy2000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott PletcherSenior DBACommented:
Make sure your dbs is set to "auto_close off".  You want this query to return zero rows:

select * from sys.databases where is_auto_close_on = 1
0
Zoldy2000Author Commented:
can you tell me how to check that please?   Thanks
0
Scott PletcherSenior DBACommented:
Edited that in -- please refresh me earlier comment :-).
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Zoldy2000Author Commented:
thanks no change
0
Scott PletcherSenior DBACommented:
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"?
0
Zoldy2000Author Commented:
sorry speed is the same.
0
Scott PletcherSenior DBACommented:
Likely not a SQL Server issue then.  Check the communications between the servers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.