question

Chris shaw avatar image
Chris shaw asked

Your Experiance

I am curious as to what others experience is with the Dell EqualLogic is… I am faces with an odd situation, well that I am starting to think is more common then I originally consider. I am working with an organization that has some limitations on the amount of money that can be spent. Up to recently there was only one EqualLogic. So the Logs and the Data were on the same 14 spindles, with the addition of one more, I can now make a recommend that we move the logs on to a different set of spindles. Dell has mentioned over and over again that this is no longer an issue, but this is by technical sales staff, not SQL Server staff. So, is it better for me to go traditional setup with the Data on one set, and the logs on a different set. Or Do I trust Dell because I can’t test before I deploy and just daisy chain the 2 and end up with one 14 (old spindle count) + (24 new spindle count) Sure there is a lot of specific information that will end with an it depends, I was hoping for just an overall experience, general input that leads me to new ideas or understanding.
hard-disks
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
SirSQL avatar image
SirSQL answered
Given that the data (random) and log (sequential) have completely different disk access patterns you should absolutely have them on different spindles. Tack on top of that recoverability of your databases. You might have the need to create a tail log backup because of an issue or corruption. That Dell are doing that to you indicates to me that you need to get new service engineers or start researching new storage.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.