x

SQL Server cluster with shared storage

What are people's experiences of running a SQL Server cluster with shared storage?

more ▼

asked Oct 12, 2009 at 12:10 PM in Default

Melvyn Harbour 1 gravatar image

Melvyn Harbour 1 ♦♦
1.4k 18 20 22

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Very good. The systems I made at the last company I worked for were incredibly reliable, we used a variety of SANs mostly from HP (MSA1000 I think), IBM or EMC/Dell (who you can get to cut their prices by 50% virtually all the time).

The only time there was a problem was when there was a drive failure in one of the arrays, and the ops guys hadn't noted down the right serial number from the chassis. So they decided to pull it out of the rack mid operation. Which would have been OK, if they had screwed the data connector in at the back. So basically half of the array disappeared, which SQL Server didn't like very much. Then it turned out the backups hadn't been tested. Because they'd forgotten to take any (!).

I am so glad I don't work there any more.

more ▼

answered Oct 12, 2009 at 12:18 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.5k 61 65 87

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x346
x93
x30

asked: Oct 12, 2009 at 12:10 PM

Seen: 2741 times

Last Updated: Oct 15, 2009 at 05:47 AM