Friday, March 23, 2012

New sql server setup

Hello all,
I am new to MSSQL, our compnay is going to be converting our current
pervasive database to mssql. It is my resposibility to setup the new
hardware.
I heard mention that for performance it is best to split up the drives that
all the data is on. We willl be purchasing a new HP MSA30 disk shelf that
holds 14 drives and I was wondering how it would be best to setup the disks
that will be going in the msa30.
We will also be putting this on a clustered server.
On which Operating system you are planning to build cluster?
you will require shared disk for clustering, read more from below links: -
http://www.microsoft.com/technet/pro...a05ac9cb4.mspx
http://sql-server-performance.com/sq...stall_main.asp
http://sql-server-performance.com/clustering_intro1.asp
"Romualdt" wrote:

> Hello all,
> I am new to MSSQL, our compnay is going to be converting our current
> pervasive database to mssql. It is my resposibility to setup the new
> hardware.
> I heard mention that for performance it is best to split up the drives that
> all the data is on. We willl be purchasing a new HP MSA30 disk shelf that
> holds 14 drives and I was wondering how it would be best to setup the disks
> that will be going in the msa30.
> We will also be putting this on a clustered server.

No comments:

Post a Comment