Index_P

P

PAE (Physical Address Extensions), 66567, 678

page files

defined, 660

physical memory limits and, 66061

size and location, 67074

Windows disk requirements and, 144

page frame number (PFN), 667

parallel SCSI, 1045

parallel striped backup device, 44850

parity, 11819

partitions, documenting, 538

passwords

account, 530, 64041

KillPwd utility, 645

not using blank or weak, 640

NULL, 645

resetting, 536

server cluster, 19193

patches. See also service packs

reading documentation, 58182

testing prior to rollout, 581

Perceived downtime, 78, 80

Perfmon (System Monitor), 704, 70914

performance. See also monitoring

availability technology comparison table, 7980

counters, 9496

files and filegroups, 126

hotfixes, 625

indexes, 91

locking hints, 9293

metrics, 590

Network-Attached Storage, 99100

physical disks, 9397

SANs and, 101

service packs, 625

trade-offs, 89

permissions

file and registry, 645

SQL Server 2000 upgrade, 59091

xp_cmdshell, 645

personnel. See staff

PFN (page frame number), 667

Physical Address Extensions (PAE), 66567, 678

physical disk performance counters, 9496

physical fragmentation, 65455

physical memory

accessing, 663

bits of, 658

limits, 66061

pilot test, 611

planning

backups , 44

capacity. see capacity planning

change plans, 42

communication plan, disaster recovery, 554

contingency plans, 4243

database maintenance. see Database Maintenance Plan

disaster recovery, 534

failover clusters, 21112

implementation window, 4344

Microsoft.com case study, 52829

server clusters, 15670

WAN failure, 27

point-in-time recovery, 49697

ports

failover clusters and, 219

networking and, 599

remote Network Load Balancing, 201

security of, 644

server clusters and, 165

postmortem meetings, following deployment, 48

power supply

data center best practices, 2527

data center growth, 23

grounding , 21

Preliminary Steps wizard page, 150

prevention, 4, 45

primary keys, database replication, 348

primary server

changing, 316

Database Maintenance Plan and, 323

demoting, 31113

log shipping and, 6769, 7576

Network Load Balancing on, 2034

@primary_server, 316

switching back to, 278, 339

transactional replication and, 7576

priorities, network

changing, 175

configuring, 18182

private networks (heartbeat)

changing network priority, 175

cluster communication configuration, 16970

cluster communication requirements, 16768

connectivity, 176

defined, 55

network cards for, 17275

Network Load Balancing, 58

procedure cache, 596

processes

as barriers to availability, 18

monitoring blocked, 721

standardization, 48

processors

32-bit vs. 64-bit, 14142

documenting, 538

server cluster design and, 520

upgrades and, 59698

Windows servers and, 14041

production, 4145

change plan, 42

change request form, 45

contingency plans, 4243

environment, Microsoft.com case study, 529

implementation team, 43

implementation window, 4344

planning implementation twice, 44

release readiness review, 45

testing implementation, 4445

production server design, 606

Profiler/Trace Core, 71821

project teams

assembling, 67

availability technology selection, 7374

DBA team, 3032

guiding principles, 78

implementation team, 43

proof of concept, 611

PSS. See Microsoft Product Support Services (PSS)

public networks

cluster communication configuration, 169

connectivity, 176

network cards for, 17172

network priority, 175

virtual servers, 55

Publishers

backing up, 36566

disaster recovery, 37172

publication database, 366

separating from Distributors, 35658

server cluster design, 520