Mitchel's Forums

Subject: How to lean-out SQL Server
Prev Next
You are not authorized to post a reply.

AuthorMessages
barryzUser is Offline
New Poster
New Poster
Posts:2

08/12/2008 8:59 PM  

I've seen many posts on DotNetNuke.com that DNN does not support MySQL or other databases - because scripts would need to be created for each module.  So... we're stuck with Sql Server Express (1 Gig of Memory and a .mdb size of 4 GB) or use the full-blown SQL Server.
My question is: 
If you're only using IIS, DNN  and Sql Server to host websites, what parts of SQL Server can be turned off?? 
Hopefully a lot... to speed up the delivery of the web pages.
Is there a .vb script / exe or something available that would make it easy to turn off all the un-needed parts/services?
Even a List would be nice.

BarryZ

 

Mitchel SellersUser is Offline
Site Admin/Owner
Guru
Guru
Posts:5607

08/13/2008 8:24 PM  
Barry,

From a performance standpoint many sites are just fine running on SQL Server Express edition, there are not many options with it that can be turned off.

Really the optimization is in the database structure, and the calling code, reducing any un-necessary DB calls.

-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

3Essentials is my recommended Shared Hosting Provider

This site is hosted on a VPS from HostMySIte.com

Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!

To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs
barryzUser is Offline
New Poster
New Poster
Posts:2

08/14/2008 10:17 AM  

So I understand that... SQL Server Express, with less overhead than SQL Server 2005, is as lean as it's going to get... to simply push out DNN websites.  OK.

Regarding the 1MB memory limitation and the 4GB max .mdb size:
I have three .mdb files hosting approx 30 websites.  The sizes of the .mdb's are:  128MB, 35MB, 65MB
The reason that they were split among multiple .mdb's was when newer versions of DNN were installed, they were first installed into a separate .mdb, then the other .mdb's were updated.
How does the 1MB memory limitation apply to multiple .mdb's?
Would it be better to have all 30 websites in one large .mdb?
... or would it be better & easier down the road if each website had it's own .mdb for backups purposes?
... There are times when an Administrator messes-up their website and only their website needs to be restored to the previous backup.  I'd rather not affect all other websites.

Can multiple instances of Sql Server Express be run?  Each with their 1MB memory limitation?
The W2K3 computer has 4GB of memory.

I also understand that you can tell IIS that each .mdb or even each Website can be in a separate IIS Application Pool, but I haven't gotten that deep yet.

Thanks for the advice.
BarryZ

 

Mitchel SellersUser is Offline
Site Admin/Owner
Guru
Guru
Posts:5607

08/18/2008 12:53 AM  
Barry,

The SQL Server 1Gb memory limit is a per instance limitation if I remember correctly. With databases that small you will most likely not run into issues, as it is really a limitation on the memory that can be used to process and serve queries.

You can separate websites into multiple application pools that will isolate them from other applications, but that is the ONLY reason to do so, isolation.

-Mitchel Sellers
MCITP, MCPD, MCTS
Director of Development
IowaComputerGurus Inc.

View Mitchel Sellers's profile on LinkedIn

3Essentials is my recommended Shared Hosting Provider

This site is hosted on a VPS from HostMySIte.com

Mosso is my recommended cloud computing provider. Use reference code REF-ICG to get $100 off your second month!

To get Guaranteed DNN Support check out our affordable DNN Technical Support Programs
You are not authorized to post a reply.
Forums >Development Discussion >DotNetNuke > How to lean-out SQL Server



ActiveForums 3.7