Win7 SLOW first connection to local MSSQL 2008 free

I have a classic ASP application, the first page that loads takes forever to connect to the locally installed MS SQL 2008 free RC2 edition. This only happens from this Win7 computer that has a fresh install.
Once I log in the second page loads faster, then it all loads real fast. If I log out and back to the first page now it loads super fast and only if I stop browsing it is fast. IF i stop browsing after about one minute and i try to go back and browse it again turns slow to connect.

Any config issues ?  Been doing research and tried a few things with no luck. I already tried turning off the windows firewall and uninstalled my Norton antivirus with no luck.
AleksAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
Applications like MSSQL and IIS and ASP and ASP.NET appear to get unloaded from RAM when they're not used for a while.  The slow response (I believe) is because they're not in memory when you first request them after a period of non-use.  I don't believe that it is because of a problem but just the way they and Windows work.
0
 
AleksAuthor Commented:
And Even on the ODBC (32 bit) the connection is still slow, not 30 secodns but a good 5 -7 seconds to connect.
0
 
AleksAuthor Commented:
It runs just fine in another computer with the exact same specs, so even though the above may be true this is no reason to hang for 30 seconds when it first connects to the database.
any other page that does NOT have connection to the database comes up immediately even when loaded the first time.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
I have yet to find two computers that after being used for a while were exactly the same.  But it may give a you a basis for comparison.  Take a look at the programs and processes running on the two computers and see what the differences are.  Also take a look at RAM usage.
0
 
AleksAuthor Commented:
I ended up reinstalling sql 2008 BUT with 32 bit and now works just fine, apparently 64 bit creates trouble.
0
 
Dave BaldwinFixer of ProblemsCommented:
Good, thanks for the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.