DB size for WSS

Could someone please elaborate on what the DB size should be kept at (each
contenent DB), for each Virtual Server?

Is there a best practice?

david
Tue Aug 16 15:25:07 CDT 2005

marc
SQL can handle large data volumes if setup correctly...I think it is more a
case of your setup rather than the size.
tips:
1. Put your txn logs on a mirrored drive
2. Put your data logs on a raid 5 drive
3. Set your txn log file growth to 2Gb which stops the txn logs getting
overmanaged.
4. Install sql on a separate box if possible and set cpu and ram to sql
managed
5. Have a good backup/restore policy.

hope this helps


"Marc McMahon" wrote:

> Could someone please elaborate on what the DB size should be kept at (each
> contenent DB), for each Virtual Server?
>
> Is there a best practice?
>
>
>

Marc
Wed Aug 17 11:12:49 CDT 2005

Thanks.


"dave nixon" <david.nixon@danix-consulting.com> wrote in message
news:B0954504-C179-4A09-B33C-66E4F635B989@microsoft.com...
> marc
> SQL can handle large data volumes if setup correctly...I think it is more
> a
> case of your setup rather than the size.
> tips:
> 1. Put your txn logs on a mirrored drive
> 2. Put your data logs on a raid 5 drive
> 3. Set your txn log file growth to 2Gb which stops the txn logs getting
> overmanaged.
> 4. Install sql on a separate box if possible and set cpu and ram to sql
> managed
> 5. Have a good backup/restore policy.
>
> hope this helps
>
>
> "Marc McMahon" wrote:
>
>> Could someone please elaborate on what the DB size should be kept at
>> (each
>> contenent DB), for each Virtual Server?
>>
>> Is there a best practice?
>>
>>
>>

AC
Wed Aug 17 12:31:01 CDT 2005

Yes... there's a page on MSDN that discusses capacity planning and
guidelines they recommend. Don't have the URL... sorry!

In addition, I'd check out Joel Olson's presentation from TechEd USA this
year about Microsoft's internal "guidelines" for capacity planning. This is
a webcast he did prior to TechEd... not sure if it's the same.
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032272759&EventCategory=5&culture=en-US&CountryCode=US

--
-AC [MVP MCMS]
http://www.andrewconnell.com
http://www.andrewconnell.com/mvp


"Marc McMahon" <marcm@hotmail.com> wrote in message
news:udByBHnoFHA.3312@tk2msftngp13.phx.gbl...
> Could someone please elaborate on what the DB size should be kept at (each
> contenent DB), for each Virtual Server?
>
> Is there a best practice?
>