Showing posts with label storage. Show all posts
Showing posts with label storage. Show all posts

Thursday, February 16, 2012

Capacity Planning for OLTP Database Server

Is there any decent documentation for estimating storage, memory, and CPU reqirements for new SQL Server databases?IMHO... nothing that is too great.
However, Compaq and Dell both have SQL sizing tools on thier www site that
you might want to review...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Charlie Duffy" <charles.t.duffy@.verizon.com> wrote in message
news:90A54F85-2D52-457A-9E8A-95A3AD5B509A@.microsoft.com...
> Is there any decent documentation for estimating storage, memory, and CPU
reqirements for new SQL Server databases?
>

Capacity Of SQL Server

Hi,

Could you please advise below:

1. storage capacity of SQL server in terms of :

a) No. of records

b) In terms of memory

2. Licencing fees for 1 pc for single user

Thanks

Amir

From SQL Server 2005 Books Online online:

Maximum Capacity Specifications for SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

Features Supported by the Editions of SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

Editions and Components of SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms144275.aspx

Memory:

Hardware and Software Requirements for Installing SQL Server 2005

http://msdn2.microsoft.com/en-us/library/ms143506.aspx

Licensing

http://www.microsoft.com/sql/howtobuy/default.mspx

1.a Number of records is determined by storage capacity

|||

Hi carpe cras,

I got my answer, thank you so much for your help!

Amir