As part of migrating SPS 2001 to SPS 2003, I'm interested
in how to setup requirements for the SQL server backend.

Can anyone tell me if there is a way to calculate the SQL
server database requirement for SPS 2003 based on the
current database size for SPS 2001?

I know that under SPS 2001 there are 2 databases being
used to store the data wss.mdb and wss.stm. Should the
size of either or both be taken into consideration to
help calculate what disk space will be needed for SQL
server? If not, what can be used to come up with an
estimate?

I need an estimate to see if the current server capacity
for SQL server being used by other projects will be
sufficient to handle the additional load from SPS
2003.Also do you see any problem with the SPS 2003 SQL
server backend being placed on a shared server?

Thanks again for your help.

Re: SPS 2001WSS to SPS 2003 SQL Server by Stephen

Stephen
Mon Oct 27 10:08:49 CST 2003

According to the Capacity Planning Guide:
http://www.microsoft.com/sharepoint/assistance/SPScapacity.asp

The computer running SQL Server must have sufficient disk space to store 200
percent of the total size of all documents stored within the portal site.
Each search server must have sufficient disk space to store 50 percent of
the total size of all documents included in the portal site index. Each
index server must have sufficient disk space for 25 percent of the total
size of all documents included in the indexes on that server.

-Stephen

"WG" <anonymous@discussions.microsoft.com> wrote in message
news:072d01c39ca2$a9011000$a001280a@phx.gbl...
> As part of migrating SPS 2001 to SPS 2003, I'm interested
> in how to setup requirements for the SQL server backend.
>
> Can anyone tell me if there is a way to calculate the SQL
> server database requirement for SPS 2003 based on the
> current database size for SPS 2001?
>
> I know that under SPS 2001 there are 2 databases being
> used to store the data wss.mdb and wss.stm. Should the
> size of either or both be taken into consideration to
> help calculate what disk space will be needed for SQL
> server? If not, what can be used to come up with an
> estimate?
>
> I need an estimate to see if the current server capacity
> for SQL server being used by other projects will be
> sufficient to handle the additional load from SPS
> 2003.Also do you see any problem with the SPS 2003 SQL
> server backend being placed on a shared server?
>
> Thanks again for your help.



Re: SPS 2001WSS to SPS 2003 SQL Server by WG

WG
Mon Oct 27 12:44:33 CST 2003

I reviewed the Capacity Planning Guide you pointed out
and I have one question. They give an example of being
able to use a single server setup for SPS 2003.

With the single server setup, are both SPS 2003 and SQL
Server loaded on the same server?

Thanks.
WG
>-----Original Message-----
>According to the Capacity Planning Guide:
>http://www.microsoft.com/sharepoint/assistance/SPScapacit
y.asp
>
>The computer running SQL Server must have sufficient
disk space to store 200
>percent of the total size of all documents stored within
the portal site.
>Each search server must have sufficient disk space to
store 50 percent of
>the total size of all documents included in the portal
site index. Each
>index server must have sufficient disk space for 25
percent of the total
>size of all documents included in the indexes on that
server.
>
>-Stephen
>
>"WG" <anonymous@discussions.microsoft.com> wrote in
message
>news:072d01c39ca2$a9011000$a001280a@phx.gbl...
>> As part of migrating SPS 2001 to SPS 2003, I'm
interested
>> in how to setup requirements for the SQL server
backend.
>>
>> Can anyone tell me if there is a way to calculate the
SQL
>> server database requirement for SPS 2003 based on the
>> current database size for SPS 2001?
>>
>> I know that under SPS 2001 there are 2 databases being
>> used to store the data wss.mdb and wss.stm. Should the
>> size of either or both be taken into consideration to
>> help calculate what disk space will be needed for SQL
>> server? If not, what can be used to come up with an
>> estimate?
>>
>> I need an estimate to see if the current server
capacity
>> for SQL server being used by other projects will be
>> sufficient to handle the additional load from SPS
>> 2003.Also do you see any problem with the SPS 2003 SQL
>> server backend being placed on a shared server?
>>
>> Thanks again for your help.
>
>
>.
>