Solved

Win7 SLOW first connection to local MSSQL 2008 free

Posted on 2011-03-20
6
552 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:amucinobluedot
  • 3
  • 3
6 Comments
 

Author Comment

by:amucinobluedot
ID: 35176838
And Even on the ODBC (32 bit) the connection is still slow, not 30 secodns but a good 5 -7 seconds to connect.
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 35177058
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
 

Author Comment

by:amucinobluedot
ID: 35177133
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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 500 total points
ID: 35177169
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
 

Author Comment

by:amucinobluedot
ID: 35263387
I ended up reinstalling sql 2008 BUT with 32 bit and now works just fine, apparently 64 bit creates trouble.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 35263444
Good, thanks for the points.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…

770 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