SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Networked Storage
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mr_mist
Grunnio

United Kingdom
1870 Posts

Posted - 10/15/2003 :  09:18:22  Show Profile  Visit mr_mist's Homepage  Reply with Quote
Hello


Does anyone have any experiences, good or bad, or using networked storage systems to hold their SQL databases?

We are experiencing one or two space and reliability issues with our SQL Server PCs and one of the suggestions to filter down is that we purchase a 5000 pound storage array with some 3TB of disk in it.

The thing itself sounds quite nice, but I've not used one before so can't offer any real advice as to if it would be useful.

Does anyone run their databases off networked storage? Does it work? Can it even be done? I'm sure whenever I've tried to attach a DB from a remote share it has not shown up in the list of drives. Do dedicated network storage systems work around this somehow?

-------
Moo. :)

Merkin
Funky Drop Bear Fearing SQL Dude!

Australia
4970 Posts

Posted - 10/15/2003 :  11:25:47  Show Profile  Visit Merkin's Homepage  Reply with Quote
You are lucky my memory is good today

http://www.sqlteam.com/item.asp?ItemID=128



Damian
Go to Top of Page

MichaelP
Jedi Yak

USA
2489 Posts

Posted - 10/15/2003 :  12:50:17  Show Profile  Visit MichaelP's Homepage  Reply with Quote
Might I suggest an EMC CX400 or CX600. They are nice and Fibre attached vs Network attached. They are NOT cheap for 3TBs, but they are fast and nice to work with.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 10/15/2003 :  14:43:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
We use Compaq's EVA solution. It is very fast. We have been pretty happy with it. We use it on all of our production servers.

Tara
Go to Top of Page

mr_mist
Grunnio

United Kingdom
1870 Posts

Posted - 10/16/2003 :  03:26:29  Show Profile  Visit mr_mist's Homepage  Reply with Quote
Thanks for the input guys and girls. Do those of you that do use these things use them for read/write DBs as I see the article suggests read only.

-------
Moo. :)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 10/16/2003 :  12:21:04  Show Profile  Visit tkizer's Homepage  Reply with Quote
Our systems are mostly writes to the database. When we moved to the EVA solution, we did not see ANY performance degradation with writes. We are very happy with this solution. The only problem is the expense. We are out of ports on it, so we can't add any more servers to it. The cost of this is very expensive.

Tara
Go to Top of Page

MichaelP
Jedi Yak

USA
2489 Posts

Posted - 10/16/2003 :  13:36:37  Show Profile  Visit MichaelP's Homepage  Reply with Quote
We've not gotten our EMC box in yet, but I've seen one in action. You can configure the arrays pretyt much however you like, so you can tune it as needed for your setup. They are certainly not cheap though. A low end box with not too much storage will set you back $35-40K (Based on EMC CX200). An EVA solution is about $100K +
If you need 3TB's of data, you'll probably need something along these lines though. 3Tb's will probably set you back about $100-150K depending on how you setup your arrays etc.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 10/16/2003 :  14:11:15  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yeah, we needed several TB of storage space. We've got several databases that are over 75GB.

Tara
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000