Sql 2005 on EMC celerra or clarion

Sql 2005 on EMC celerra or clarion

Post by QUZyb2 » Fri, 29 Jul 2005 21:05:04


Hi,
we have many DB that are sql2000. The hope is to unify them to one strong
server connected either by SAN to EMC clarion cx700 , or , thru NAS to the
same disks thru celerra ns702. In the process there will be an upgrade to sql
2005.
Has anyone done anything similar and can share experiance ?
Do you have links to relevant white papers since what I found is relevant
only to Netapp.
Thank you
 
 
 

Sql 2005 on EMC celerra or clarion

Post by TWlrZSBFcH » Fri, 29 Jul 2005 22:32:04

Hi

NAS is not supported.
http://www.yqcomputer.com/ ;en-us;304261

SAN is, but direct attached SAN (SCSI, Fiber etc)

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.yqcomputer.com/

Blog: http://www.yqcomputer.com/

 
 
 

Sql 2005 on EMC celerra or clarion

Post by QUZyb2 » Fri, 29 Jul 2005 22:46:15

Thank you ,
I will look further into the SAN configuration
 
 
 

Sql 2005 on EMC celerra or clarion

Post by Wojtek Gar » Sat, 30 Jul 2005 03:27:46

Hi,
Not only direct attached, iSCSI on LAN works as well. Set it up myself on
NetApp FAS.

Cheers
Wojtek
 
 
 

Sql 2005 on EMC celerra or clarion

Post by QUZyb2 » Sat, 30 Jul 2005 14:51:03

Hi,
Can you give me some technical details such as size of the databases and
transactions per time.
Did you do any performance comprisign with your former system?
Thanks for the answer.
Natan
 
 
 

Sql 2005 on EMC celerra or clarion

Post by Wojtek Gar » Mon, 01 Aug 2005 02:59:46

Hi,

the data size is about 250 GB. Our system is of rather static nature,
definitely it is no classic OLTP. The typical wueries are reads by id with
joining 3 up to 6 big tables (each 50+ mln records).

However, I did performance comparison between our current setup
(DirectAttachedStorage, RAID5) and the new one (SAN via iSCSI through 1GB
LAN). The results were AFAIR 100% to 300% better, it was big improvement.

--
Cheers,
Wojtek
 
 
 

Sql 2005 on EMC celerra or clarion

Post by U2NvdHR » Wed, 08 Feb 2006 06:31:47

Hello, how did you split the drives for the improved performance?

Thanks,
Scottt