jeff711981

Member
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jeff711981

  • Rank
    Member
  1. You do want your SQL logs on a different set of disks than your data, though. Log writes are sequential whereas actual database access is going to be mostly random. When you mix small random I/O with large sequential I/O you typically see latency issues with your small random I/O due to the large sequential writes going on with the SQL logs.
  2. I'm one of two storage admins/engineers/architects at a rapidly growing SaaS company. We run MS SQL Server, and those OLTP databases are the foundation of our product. For the past 5 or 6 years, we've been using storage from one of the big names in the industry (one of the three I'm about to mention, in fact). However, we've run into some issues that have cost us down time, performance issues and lots of sleep. More than a few times, we've had vendors come in to talk about their products and they've never seen someone do some of the stuff we're doing, so we're a bit of an odd duck, going through some growing pains and my fellow storage team member and I are trying to set us up with a quality array that will take us into the next phase of our growth and beyond. (we no longer want storage to be the reason for any downtime - planned nor unplanned) We're considering replacing our existing storage array with something more robust and have met with each of these vendors to discuss these storage systems: Hitachi Data Systems VSP, EMC VMax, or NetApp FAS w/C-DOT. Something that's going to allow our storage environment to hit five 9's and will grow with us and avoid the big multi-million dollar fork lift upgrades every 5 years or so. I was wondering if anybody has an experience or strong opinion on any of those systems - anything ranging from how effective their support staff is to any "gotcha's" you've run into in day-to-day administration of any of those systems. We rely heavily on our own scripts that we've written in-house to automate tasks, so if anyone could comment on how either of those three platforms handle that sort of custom automation, that'd be great. Oh, also, we're almost exclusively fibre channel - we have a couple CIFS shares and NFS exports, but nothing so important that we couldn't simply attach a LUN to a Windows or Linux box to perform the NAS duties.