Solved

SQL performance problems.

Posted on 2014-10-31
7
146 Views
Last Modified: 2014-11-03
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....
0
Comment
Question by:Zoldy2000
  • 4
  • 3
7 Comments
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 40415901
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
 
LVL 2

Author Comment

by:Zoldy2000
ID: 40415906
can you tell me how to check that please?   Thanks
0
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 40415921
Edited that in -- please refresh me earlier comment :-).
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 2

Author Comment

by:Zoldy2000
ID: 40416235
thanks no change
0
 
LVL 69

Expert Comment

by:ScottPletcher
ID: 40419854
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
 
LVL 2

Author Comment

by:Zoldy2000
ID: 40419964
sorry speed is the same.
0
 
LVL 69

Accepted Solution

by:
ScottPletcher earned 500 total points
ID: 40420123
Likely not a SQL Server issue then.  Check the communications between the servers.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
t-sql splitting name column 5 40
SQL query to summarize items per month 5 52
Square brackets 4 38
SQL Query 3 48
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now