question

Tim avatar image
Tim asked

Need Advice for SAN Management

This has been an interesting week. First I was informed I needed to attend a meeting with vmware to discuss migrating some of our SQL environment to VM. We will start with DEV and QA. I posted a question on here and you all got me prepared for my meeting with vmware. I was able to walk in to the meeting an appear as if I knew a thing or two about SQL in a vm environment. Now for the second part. Today my boss calls me in his office and explains to me how the current SAN admin is over worked and can really only spend 40 - 50 percent of their time working on our SAN environment. Someone else used the phrase that they are a SAN provisioner, not a SAN administrator. My boss then explained that he would like for me to start working with the SAN admin and become a back to them. Baby steps in the beginning with the intention that I can perform the entire job. I take that as really great news for me. I get to learn a new valuable trade. From reading many SQL books, blogs, and posts on here it seems many of you also work a lot with SAN's more so than just having your databases on them. For those of you who know a great deal, where did you start? I know RAID technology very well and understand the basic's of SAN technology with the different types of disk and the concept of LUNS, but other than that, I am completely lost. Does anyone know of good blogs, white papers, easy reading books, etc. Your help is greatly appreciated. I have about two weeks before this info is made public and work and before I will be working with our current SAN provisioner. :) While I am at it having everyone think about SAN, who uses what. We use Hitachi but I understand there are lots of vendors out there, Hitachi, EMC, EMD, etc.
san
10 |1200 characters needed characters left characters exceeded

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

Matt Whitfield avatar image
Matt Whitfield answered
Your single most important point of call is again [Brent Ozar][1]. He did some excellent [presentations at SQLBits][2] - well worth checking out. [1]: http://www.brentozar.com/ [2]: http://sqlbits.com/Speakers/Brent_Ozar/Default.aspx
2 comments
10 |1200 characters needed characters left characters exceeded

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

Thanks, I will read over it this weekend.
0 Likes 0 ·
+1 for Brent Ozar. Top bloke, highly respected, knows the area inside out.
0 Likes 0 ·
DaniSQL avatar image
DaniSQL answered
I am in a similar situation like you. we just set up a new SAN and its not live yet. I am trying to learn beyond the basics and how to administer and optimize SAN(But with out much love and support from the management like you=). I agree with @Matt that Brent Ozar is your guy to introduce yourself to the technology. He is SQL Server, SAN and Virtualization guy and have plenty of [articles][1] and videos on the subject. He is even [developing an immersion class][2] in 2011 and if your company afford it, go check'em out. I am planning to catch one of his classes when he come to east coast. [Denny Cherry][3] is also an expert on SQL Server, SAN and Virtualization and make sure you check out his work too. Also dont forget to check your vendors documentation since each SAN's implementation is different. I know [EMC has a bunch of resources][4] regarding Sql Server on their SAN. [1]: http://www.brentozar.com/sql/sql-server-san-best-practices/ [2]: http://www.brentozar.com/archive/2010/10/planning-sqlskills-immersion-events/ [3]: http://twitter.com/#!/mrdenny [4]: http://powerwindows.wordpress.com/2010/05/18/emcs-most-popular-microsoft-sql-server-documents/
3 comments
10 |1200 characters needed characters left characters exceeded

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

@DaniSQL I too am on east coast. Well, not on the coast but a few hours drive to the Atlantic, or head south a few hours to the Gulf. I don't think my company would reject sending me to Brent's training since he is heavily into SQL, VM, and SAN which is the direction my company is putting me in. My wife thinks I am crazy taking all this on, but for me, it is a huge opportunity. She see's the benefit as well though, once I have access to all the tools, when she needs a new server, or san storage I can provide that too instead of just SQL data. Oh, I guess I should mention we work at the same company. :)
1 Like 1 ·
Looks like you have a hell of a team around you:-)
0 Likes 0 ·
Its a great company, like all though, we have our good days and bad. I have been with them for 12 years. I have done everything from Sys Eng, to Sys Admin, now DBA for the past two years. I guess now I will get into VM and SAN. When at the PASS Summit I will see if I can find some of the Brent Ozar coolaid. The more I read his stuff the more impressed I get.
0 Likes 0 ·

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.