Solved

Connection to SQL 2008 Super slow

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to check mis-spellings in a select SQL 2 37
SQL Job Hung 17 35
SCOM to SQL port 14xx failed? 1 29
Split string into 3 separate fields 5 18
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

679 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