Wednesday, March 28, 2012

RAID Configuration for SQL Server ...

Hi,
We are rolling out an ERP application from MS across our
organisation. And we are using MS SQL Server as the back
end. In this regard, I have few queries -
a) What would be the optimum RAID configuration for the
SQL Server database? Can someone point me towards any
guide?
b) Still we are in the initial stage of our roll out. So
we are not too sure about the growth of database. Is
there any tools available for estimating the size of
database?
Thanks in advance,
Harish MohanbabuHi
You may want to check out the book "SQL Server 2000 Performance Tuning
Technical Reference" which talks about this in some depth ISBN 0-7356-1270-6
Also you may want to browse the site:
http://www.sql-server-performance.com/
Such as:
http://www.sql-server-performance.com/ultimate_sql_server.asp
The topic "Estimating the Size of a Database" in books online should help
you decide how big the data may get:
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cre
atedb.chm::/cm_8_des_02_2h45.htm
John
"Harish Mohanbabu" <anonymous@.discussions.microsoft.com> wrote in message
news:067c01c3cdfb$2d441db0$a101280a@.phx.gbl...
> Hi,
> We are rolling out an ERP application from MS across our
> organisation. And we are using MS SQL Server as the back
> end. In this regard, I have few queries -
> a) What would be the optimum RAID configuration for the
> SQL Server database? Can someone point me towards any
> guide?
> b) Still we are in the initial stage of our roll out. So
> we are not too sure about the growth of database. Is
> there any tools available for estimating the size of
> database?
> Thanks in advance,
> Harish Mohanbabu|||Thanks for your kind and quick reply ....
>--Original Message--
>Hi
>You may want to check out the book "SQL Server 2000
Performance Tuning
>Technical Reference" which talks about this in some
depth ISBN 0-7356-1270-6
>Also you may want to browse the site:
>http://www.sql-server-performance.com/
>Such as:
>http://www.sql-server-
performance.com/ultimate_sql_server.asp
>The topic "Estimating the Size of a Database" in books
online should help
>you decide how big the data may get:
>mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
20Server\80\Tools\Books\cre
>atedb.chm::/cm_8_des_02_2h45.htm
>John

No comments:

Post a Comment