How to understand and find bottlenecks review Performance

staggerlee

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/0470176393/ref=s9_simh_gw_p14_d0_i1?pf_rd_m=ATVPDKIKX0DER&pf_rd_s=center-2&pf_rd_r=1RM3TM7BES914XAQAM1H&pf_rd_t=101&pf_rd_p=470938631&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

RobertKaucher

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

staggerlee

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?

RobertKaucher

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.