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

x
?
Solved

Win7 SLOW first connection to local MSSQL 2008 free

Posted on 2011-03-20
6
Medium Priority
?
582 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:Aleks
  • 3
  • 3
6 Comments
 

Author Comment

by:Aleks
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:Aleks
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
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:Aleks
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

A quick guide on how to use Group Policy to create a custom power plan and set it active on Windows 7.
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Suggested Courses

886 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