IIS with SQL 2008 R2 (local) running slow

I have a simple ASP web application connected with a 32 bit ODBC to an SQL 2008 R2 Database.
The pages load incredibly slow, this happened to me once and I had to reinstall the SQL engine to the 32 bit instead of the 64 bit.
Is there a way to avoid doing this and basically run it in 32 bit to speed it up ?  It literally takes 20 seconds to load a page instead of half a second as it does on 32 bit versions of the SQL .. any ideas ?
LVL 1
AleksAsked:
Who is Participating?
 
Anthony PerkinsConnect With a Mentor Commented:
If you press the Windows key + Pause/Break it will show you how much memory SQL Server recognizes.
0
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
Do you have the option of switching to the SQL Native Client, rather than relying on ODBC?
0
 
AleksAuthor Commented:
No. I need to use ODBC
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Anthony PerkinsConnect With a Mentor Commented:
You are not running SQL Server and IIS on the same server are you?
0
 
AleksAuthor Commented:
I am, it is my development computer. And I had it like this before I re-formatted my computer and it worked just fine.
But now I have win 8 and it won't let me install the 32 bit version of SQL, only the 64 bit and its giving me problems :#
0
 
Anthony PerkinsConnect With a Mentor Commented:
I am, it is my development computer.
Then you will have to set the maximum memory SQL Server can use so that it is not competing with IIS.  How much memory do you have?
0
 
AleksAuthor Commented:
Where can I find this ?
0
 
AleksAuthor Commented:
Another thing is it takes a long time on the first few pages, over a minute each, then it speeds up and I can navigate through the system with no problem, if I stop for a minute or so and go back to navigating the pages it again takes over a minute to load the page  :(
0
 
AleksAuthor Commented:
My mac keyboard doesn't have the windows key
0
 
AleksAuthor Commented:
As it turns out if I install it using default instance (localhost) the issue above will happen. I reinstalled using this method a few times with the same results.
Then I installed using a NAMED instance, for example "SQL Express" and it works fine. Go figure !
0
 
Anthony PerkinsCommented:
My mac keyboard doesn't have the windows key
I was referring to the server that has both IIS and SQL Server.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.