Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




20049 posts

Uber Geek
+1 received by user: 6108

Trusted
Lifetime subscriber

# 136249 20-Nov-2013 13:48
Send private message

Hi There!

We have been asked to investigate a 3 Server SQL Cluster setup. We think Shared Storage is the way to go, though the customers preference is IBM x3550 1U Servers (We prefer HP).  We don't need a lot of storage, Maybe 1TB in total usable. 

the V2700 IBM SAN looks a possible choice, and it appears to be connected via SAS. Will this be fast enough for SQL? The Environment is website hosting with about 200 <1GB DB's.

We were looking at SQL 2012 Features for this.

Any comments appreciated. 

Create new topic
2091 posts

Uber Geek
+1 received by user: 849


  # 937929 20-Nov-2013 14:43
Send private message

That SAN appears to be Fibre Channel - according to the spec sheet on the IBM site.

In which case you want an FC Switch too. How important is redunancy? Then 2 switches.
Need FC HBAs for each server - 2 ports if you do two fabrics.
What are you doing for DR? Active/Passive + DR Mirror?
What edition of SQL?
What underlying OS? 2008R2 or 2012.

IO is down to type of disk, number of spindles and controller throughput. How many disks? What type/size of disks?
What are your IO requirements? You can have a 1TB DB with low IO requirements or a 1GB database with massive IO requirements.

More information required.

Budget?


8033 posts

Uber Geek
+1 received by user: 390

Trusted
Subscriber

 
 
 
 


Infrastructure Geek
4057 posts

Uber Geek
+1 received by user: 195

Trusted
Microsoft NZ
Subscriber

  # 938238 20-Nov-2013 21:54
Send private message

what's the problem you're trying to solve with the clustering? performance or redundancy?

what's the budget?

with three clustered sql servers and small amounts of data (1TB), a pair of SSD drives in RAID-1 for each box might be a possible solution.

make sure you look at "SQL Server Always On" technology too - its the new HA option with SQL 2012 and one that MSFT is using across datacenters since beta sql 2012: https://www.microsoft.com/en-us/sqlserver/solutions-technologies/mission-critical-operations/high-availability.aspx

enterprise class 800GB Intel SSD's run to $1500-$2000 each, 6 of them being $9000 to $12000. check this review: http://www.storagereview.com/intel_ssd_dc_s3500_enterprise_review

a SAN will normally set you back much more than that, and then you need to have fibre switches or 10Gbe interfaces to get good throughput. you'll need to get familiar with iscsi multipathing or fibre channel fabrics as well as understanding how to config/tweak the SAN you choose. you'll also get struggel to get the same IOPS of the SSD option.

depending on the goals - perf vs redundancy - perhaps you only need two clustered nodes with SSDs.




Technical Evangelist
Microsoft NZ
about.me/nzregs
Twitter: @nzregs


Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

WLG-X festival to celebrate creativity and innovation
Posted 22-May-2019 17:53


HPE to acquire supercomputing leader Cray
Posted 20-May-2019 11:07


Techweek starting around NZ today
Posted 20-May-2019 09:52


Porirua City Council first to adopt new council software solution Datascape
Posted 15-May-2019 12:00


New survey provides insight into schools' technology challenges and plans
Posted 15-May-2019 09:30


Apple Music now available on Alexa devices in Australia and New Zealand
Posted 15-May-2019 09:11


Make a stand against cyberbullying this Pink Shirt Day
Posted 14-May-2019 20:23


Samsung first TV manufacturer to launch the Apple TV App and Airplay 2
Posted 14-May-2019 20:11


Vodafone New Zealand sold
Posted 14-May-2019 07:25


Kordia boosts cloud performance with locally-hosted Microsoft Azure ExpressRoute
Posted 8-May-2019 10:25


Microsoft Azure ExpressRoute in New Zealand opens up faster, more secure internet for Kiwi businesses
Posted 8-May-2019 09:39


Vocus Communications to deliver Microsoft Azure Cloud Solutions through Azure ExpressRoute
Posted 8-May-2019 09:25


Independent NZ feature film #statusPending to premiere during WLG-X
Posted 6-May-2019 22:13


The ultimate dog photoshoot with Nokia 9 PureView #ForgottenDogsofInstagram
Posted 6-May-2019 09:41


Nokia 9 PureView available in New Zealand
Posted 6-May-2019 09:06



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.