Solved

IIS with SQL 2008 R2 (local) running slow

Posted on 2014-03-04
11
727 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

808 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