?
Solved

SQL performance problems.

Posted on 2014-10-31
7
Medium Priority
?
155 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 69

Expert Comment

by:Scott Pletcher
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:Scott Pletcher
ID: 40415921
Edited that in -- please refresh me earlier comment :-).
0
Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

 
LVL 2

Author Comment

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

Expert Comment

by:Scott Pletcher
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:
Scott Pletcher earned 2000 total points
ID: 40420123
Likely not a SQL Server issue then.  Check the communications between the servers.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

752 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