Solved

IIS with SQL 2008 R2 (local) running slow

Posted on 2014-03-04
11
729 Views
Last Modified: 2014-03-07
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 ?
0
Comment
Question by:amucinobluedot
  • 6
  • 4
11 Comments
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 125 total points
ID: 39905795
Do you have the option of switching to the SQL Native Client, rather than relying on ODBC?
0
 

Author Comment

by:amucinobluedot
ID: 39906529
No. I need to use ODBC
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 375 total points
ID: 39908295
You are not running SQL Server and IIS on the same server are you?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:amucinobluedot
ID: 39909693
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
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 375 total points
ID: 39911242
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
 

Author Comment

by:amucinobluedot
ID: 39911313
Where can I find this ?
0
 

Author Comment

by:amucinobluedot
ID: 39911342
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
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 375 total points
ID: 39911386
If you press the Windows key + Pause/Break it will show you how much memory SQL Server recognizes.
0
 

Author Comment

by:amucinobluedot
ID: 39912290
My mac keyboard doesn't have the windows key
0
 

Author Comment

by:amucinobluedot
ID: 39913066
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39914058
My mac keyboard doesn't have the windows key
I was referring to the server that has both IIS and SQL Server.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

679 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