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.




19718 posts

Uber Geek
+1 received by user: 5939

Trusted
Lifetime subscriber

Topic # 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


  Reply # 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?


8030 posts

Uber Geek
+1 received by user: 388

Trusted
Subscriber

 
 
 
 


Infrastructure Geek
4057 posts

Uber Geek
+1 received by user: 195

Trusted
Microsoft NZ
Subscriber

  Reply # 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 »

Orcon announces new always-on internet service for Small Business
Posted 18-Apr-2019 10:19


Spark Sport prices for Rugby World Cup 2019 announced
Posted 16-Apr-2019 07:58


2degrees launches new unlimited mobile plan
Posted 15-Apr-2019 09:35


Redgate brings together major industry speakers for SQL in the City Summits
Posted 13-Apr-2019 12:35


Exported honey authenticated on Blockchain
Posted 10-Apr-2019 21:19


HPE and Nutanix partner to deliver hybrid cloud as a service
Posted 10-Apr-2019 21:12


Southern Cross and ASN sign contract for Southern Cross NEXT
Posted 10-Apr-2019 21:09


Data security top New Zealand consumer priority when choosing a bank
Posted 10-Apr-2019 21:07


Samsung announces first 8K screens to hit New Zealand
Posted 10-Apr-2019 21:03


New cyber-protection and insurance product for businesses launched in APAC
Posted 10-Apr-2019 20:59


Kiwis ensure streaming is never interrupted by opting for uncapped broadband plans
Posted 7-Apr-2019 09:05


DHL Express introduces new MyDHL+ online portal to make shipping easier
Posted 7-Apr-2019 08:51


RackWare hybrid cloud platform removes barriers to enterprise cloud adoption
Posted 7-Apr-2019 08:50


Top partner named at MYOB High Achievers Awards
Posted 7-Apr-2019 08:48


Great ideas start in Gisborne with hackathon event back for another round
Posted 7-Apr-2019 08:42



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.