Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

Connection to SQL 2008 Super slow

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
Aleks
Asked:
Aleks
  • 2
  • 2
2 Solutions
 
gplanaCommented:
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
 
AleksAuthor Commented:
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
 
gplanaCommented:
Could you put a minimal code which reproduces the issue ? Maybe it's a locking problem...
0
 
AleksAuthor Commented:
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now