Solved

Win7 SLOW first connection to local MSSQL 2008 free

Posted on 2011-03-20
6
541 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

947 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now