Solved

Connection to SQL 2008 Super slow

Posted on 2011-03-17
4
415 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

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…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

839 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