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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
any other page that does NOT have connection to the database comes up immediately even when loaded the first time.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I ended up reinstalling sql 2008 BUT with 32 bit and now works just fine, apparently 64 bit creates trouble.
Good, thanks for the points.
ASKER