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/prodtechnol/windowsserver2003/library/ServerHelp/f5abf1f9-1d84-4088-ae54-06da05ac9cb4.mspx
http://sql-server-performance.com/sqlserver2000_clustering_install_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.sql

No comments:

Post a Comment