+ Reply to Thread
Results 1 to 4 of 4
  1. Member staggerlee's Avatar
    Join Date
    Mar 2010
    Location
    UK - London
    Posts
    90

    Certifications
    Sec+, 70-432, 70-640, 70-642, 70-643
    #1

    Default How to understand and find bottlenecks review Performance

    Hi all,

    Just made an impressively n00b posting on the SAN guys thread to try and sort out SAN testing.

    Does anyone know any good books for looking at SQL hardware performance?

    Just got a copy of http://www.amazon.com/gp/product/047...pf_rd_i=507846

    As it mentions SQLio and SQISim.

    Also going to pick up this when its released!

    SQL Server Hardware by Glenn Berry
    SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. View Full Description

    Printed Book: Coming Soon
    Kindle Edition: Coming Soon

    Cheers

    S
    Last edited by staggerlee; 01-12-2011 at 10:21 PM.
    Reply With Quote Quote  

  2. SS -->
  3. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #2
    This is one of those areas where the answer to every question is literally "it depends." Have you looked at this book?

    Amazon.com: Professional SQL Server 2008 Internals and Troubleshooting (9780470484289): Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort: Books

    This next book is a must read. While it does not talk specifically about hardware these concepts are essential if you are going to really understand storage concepts beyond just knowing what MVPs or MCMs suggest and tell you.

    Amazon.com: Microsoft SQL Server 2008 Internals (Pro - Developer) (9780735626249): Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, Conor Cunningham, Adam Machanic: Books

    I also suggest that you watch these videos from the SQL Server MCM series:

    Storage Core Concepts
    Storage Guidelines
    DAS vs SAN Architecture
    Storage Testing and Monitoring
    Last edited by RobertKaucher; 01-13-2011 at 12:16 PM. Reason: Spelling error
    Reply With Quote Quote  

  4. Member staggerlee's Avatar
    Join Date
    Mar 2010
    Location
    UK - London
    Posts
    90

    Certifications
    Sec+, 70-432, 70-640, 70-642, 70-643
    #3
    Hi Robert,

    Thanks as always!

    Ive downloaded all the MCM vids so ill start taking a look, i saw that Ozar is the speaker for most of the storage stuff which is good as ive liked hes site and vids ive seen of him before. As for the book dont own but its been on my list of things to buy...

    With the new version of SQL coming out and our companies massive apparent need to be on the latest and greatest i was abit worried about spending the cash on more 2008 books. But think i need to just do the plunge and get into!

    Thanks for the help

    S

    ps ive not looked at 2011 yet but you have that your studying for the beta certs.. how are you finding it?
    Reply With Quote Quote  

  5. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #4
    Most of the storage internals have been very consistent since SQL Server 2000, so you are golden in that respect. The place where things are changing is really in processing - but even that is relatively stable, just that new ideas have been added to it. Parallel processing is an example. I would say 90% of the internals have been stable since 2005.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks