hardware
disk drives
bottlenecks, resolving, 413–414
configuration of, 21, 22–23, 27, 366–372
cost of, 367
isolation of, 369–370
monitoring activity of, 408–414
number of, 365–366, 367
planning requirements for, 21–24
RAID, 21, 23, 27, 368–369
speed of, 366
throughput of, 21–23
failure of, 592
memory
bottlenecks, resolving, 416–417
CLR integration's usage of, 291
configuration scenarios for, 359–362
displaying information about, 87–88
dynamic memory configuration on X86, 392–395
index creation memory option, 401–402
lock pages in memory, enabling, 394
max server memory option, 401
min memory per query option, 401
minimum configuration warning regarding, 49
monitoring usage of, 93, 414–417, 438
NUMA systems, 345
page faults, 356
page file, 355–356
performance considerations for, 345, 354–362
physical address space, 355
physical memory, 354
reserving additional memory at startup, 83
scalability and, 13
setting minimum and maximum for, 42, 65
64-bit system configuration for, 359
32-bit system configuration for, 357–359
tuning, 389–395
virtual address space, 357
VMM, 355
planning requirements for, 20–24
processors
bottlenecks, resolving, 408
cache, 349–350
configuring use of, 88
monitoring usage of, 406–408
multiprocessor systems, counters for, 406
multiprocessor systems, licensing for, 16
number of, performance considerations for, 345
number of, setting, 42
number of, used by SQL Server, 13
planning requirements for, 20
SMP (symmetric multi-processor), 353
types of, 347–348
Harinath, Sivakumar (Professional SQL Server Analysis Services with MDX), 181
hash join, 463–464
HBA (host bus adapter), 372
help. See support; troubleshooting
Henderson, Ken (PSS), 47
hidden tables, used by queues in Service Broker, 218
High Performance mode, database mirroring, 549, 559–560
High Safety mode, database mirroring, 549, 558–559
high-availability solutions. See also log shipping
backup and recovery for, 606
failover clustering
backup and recovery for, 606
definition of, 584
handling, 694–695
log shipping integrated with, 648
process for, 659–660
support for, by SQL Server edition, 15
upgrading, 72
transactional replication
backup and recovery for, 606
compared to database mirroring, 585
definition of, 530
implementing, 541
history table restore, 617
history tables for backups, 600–601
HOLAP (Hybrid OLAP), 202
host bus adapter (HBA), 372
host name, 93
Hot Add Memory, 392
hot backup server, as alternative to clustering, 656
hot memory addition, support for, 15
Hybrid DBA, 3
Hybrid OLAP (HOLAP), 202
hyperthreading, 345, 348–349