Solved

Connection to SQL 2008 Super slow

Posted on 2011-03-17
4
385 Views
Last Modified: 2012-05-11
I just setup a new computer with SQL 2008 and an ASP application. When i open internet explorer to open the 'login' page of this application, it takes over a minute for it to be displayed. I have the same application installed in many other computers and the page comes up instantly.
This is in a win7  IIS7  computer.  What could cause the connection to be so slow to the local SQL ?
0
Comment
Question by:amucinobluedot
  • 2
  • 2
4 Comments
 
LVL 15

Accepted Solution

by:
gplana earned 500 total points
ID: 35159812
Does your page has images ? If so, maybe they are very big, so when you execute the page locally they load quick, but when you execute the page remotelly they load slowly because of its size.

Maye if you put the code of the page we can look deeper...
0
 

Author Comment

by:amucinobluedot
ID: 35159998
Nop, that is not the problem, same page in IIS6 or in different computer works just fine. it is the connection to the database what seems to take forever.
0
 
LVL 15

Assisted Solution

by:gplana
gplana earned 500 total points
ID: 35161080
Could you put a minimal code which reproduces the issue ? Maybe it's a locking problem...
0
 

Author Comment

by:amucinobluedot
ID: 35176667
The problem is NOT the code, it is the same code I have in the other computer with the same version of Windows 7 installed and the same version of MS SQL 2008 installed. Furthermore, it only hangs at the beggining, once I log into the application the first pages load slow, then it speeds up and afterwards its just fine. If i stop working and go back or log out and restart windows and go back then it goes back to hanging for a minute.
Has something to do with the connection to the database. Although if I connect from the SQL Enterprise console the connection is super fast. It is only from ASP application trhough the ODBC that its slow.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

760 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

21 Experts available now in Live!

Get 1:1 Help Now