Post reply

Novice SQL DBA : Perfmon & SAN

  • January 2, 2011 at 7:06 am

    #388537

    Hi All,

    I'm just about to take responsibility for my first production SQL 2008 box, that I suspect will be SAN-attached.

    Have you any suggestions on the questions I should ask my SAN admin to ensure it's set up properly wrt the SAN?

    Also, what sort of things do you put in place to alert you if memory/disk starts getting hit hard or if a SQL Job starts failing?

    I have some ideas of my own but would welcome any direct suggestions or articles you could point me to.

    Many thanks

    Paul J

  • January 2, 2011 at 11:45 am

    #1268312

    Questions are too broad, Paul. I wouldn't know where to start.

    As far as SAN goes, however, I doubt you'll have any say in how it is set up. SAN is expensive, there are older models, newer models, you'll likely be stuck using whatever is there at the moment. So, don't concern yourself with SAN and instead focus on things which solely you can improve.

    Answers to your questions also depend on the box you are supporting - transactions for operational systems or data warehouse?

  • January 2, 2011 at 2:55 pm

    #1268327

    Paul

    Can I recommend you start by reading Brent Ozar's series on running SQL Server on a SAN and SAN best practices http://www.brentozar.com/sql/sql-server-san-best-practices/

    Hope it helps and good luck

    Gethyn Elliswww.gethynellis.com

  • January 2, 2011 at 3:12 pm

    #1268329

    Many thanks, Gethyn: I heard some of Mr O's sessions at SQLBits and it's already on my list.

    Excellent to have it recommended as well, though.

    Cheers

    Paul J

  • January 2, 2011 at 3:18 pm

    #1268333

    No problem Paul, BrentO knows his SAN stuff. There is an MCM video(s) on storage SAN Performance etc. Maybe start with the blog series first though.

    Gethyn Elliswww.gethynellis.com

  • January 2, 2011 at 3:22 pm

    #1268336

    Excellent. Will do.

    Thanks again

    Paul J

  • January 3, 2011 at 2:08 pm

    #1268671

    I STRONGLY recommend that you get a performance tuning mentor on board for a few days to help you set things up properly and teach you some of the MANY MANY things you need to know to be responsible for a production SQL Server.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • January 3, 2011 at 2:16 pm

    #1268676

    Thanks, Kevin. Certainly will if I can!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply