Solved

Connection to SQL 2008 Super slow

Posted on 2011-03-17
4
431 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
[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
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

632 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