Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Win7 SLOW first connection to local MSSQL 2008 free

Posted on 2011-03-20
6
Medium Priority
?
579 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
[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
  • 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 84

Accepted Solution

by:
Dave Baldwin earned 2000 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 2000 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 84

Expert Comment

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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

704 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