H

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