SQL Server Hardware Choices Made Easy.pdf

(2625 KB) Pobierz
727092929 UNPDF
High Performance SQL Server
SQL Server Hardware
Choices Made Easy
Glenn Berry
ISBN: 978-1-906434-72-4
727092929.001.png
SQL Server Hardware
Choices Made Easy
Glenn Berry
First published by Simple Talk Publishing, 2011
Copyright Glenn Berry 2011
ISBN: 978-1-906434-72-4
The right of Glenn Berry to be identiied as the author of this work has been asserted by him in accordance
with the Copyright, Designs and Patents Act 1988.
All rights reserved. No part of this publication may be reproduced, stored or introduced into a retrieval
system, or transmitted, in any form, or by any means (electronic, mechanical, photocopying, recording or
otherwise) without the prior written consent of the publisher. Any person who does any unauthorized act in
relation to this publication may be liable to criminal prosecution and civil claims for damages.
This book is sold subject to the condition that it shall not, by way of trade or otherwise, be lent, re-sold, hired
out, or otherwise circulated without the publisher's prior consent in any form other than which it is pub-
lished and without a similar condition including this condition being imposed on the subsequent publisher.
Edited by Tony Davis
Technical Review by Denny Cherry
Cover Image by Andy Martin
Typeset & Designed by Matthew Tye & Gower Associates
Table of Contents
Introduction ................................................................................................................................ v
Server processors and related hardware .........................................7
1 Know your workload type, Part 1 ...................................................................................... 7
2 Don't economize on the CPU ........................................................................................... 9
3 More cores, fewer sockets… ............................................................................................. 10
4 Don't dismiss hyper-threading (Intel processors) ......................................................... 12
5 Don't focus just on speed: cache size is very important ..............................................14
6 Use the High Performance power option ......................................................................16
7 Use "turbo boost" technology...........................................................................................18
8 Carefully evaluate the motherboard and associated chipsets .................................... 22
9 Two x 2-sockets is usually better than one x 4-socket ................................................ 24
10 Optimize memory capacity ............................................................................................. 26
11 Use 64-bit hardware, operating system and SQL Server ............................................ 28
12 Understand SQL Server licensing restrictions ............................................................. 29
13 Use the built-in hardware discovery tools .................................................................... 30
14 Get to know your hardware intimately with CPU-Z ....................................................34
15 No RDP access? Investigate hardware using sys.dm_os_sys_info .............................36
16 Analyze the TPC-E benchmarks ......................................................................................38
17 Perform your own benchmarks with Geekbench .........................................................41
18 For OLTP server workloads, consider Intel Xeon X5690 (July 2011) ..........................43
19 For DSS/DW server workloads, consider AMD Opteron 6180 SE or Intel E7 Series
(July 2011) .............................................................................................................................45
20 Keep track of the major processor vendors ................................................................... 47
Desktop and laptop processors and related hardware ................51
21 $2,000 buys a very capable dev/test system ................................................................... 51
Intel Socket 1366 .............................................................................................................. 52
Intel Socket 1155 platform ...............................................................................................53
Storage choices ................................................................................................................ 54
22 For a laptop, choose a Sandy Bridge processor (July 2011) ........................................... 55
Coniguring the disk subsystem ................................................... 59
23 Know your workload type, Part 2 ...................................................................................60
24 Attached storage: for magnetic drives choose SAS or SATA ...................................... 62
25 Start planning to incorporate SSDs ................................................................................63
26 Use the correct RAID level, ideally RAID 10 ................................................................. 64
27 High-performance DAS is a reality ................................................................................ 67
28 Maximize spindle count and I/O channel performance ............................................. 68
29 Use CrystalDiskMark to measure I/O capacity ............................................................ 72
30 Build resilience into your system ................................................................................... 74
Appendix A: Recommended Intel and AMD processors .............. 76

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin