L


latency, 364

licensing, 16

Lightweight Pooling, 399

Linked Objects, SSAS, 75

load

defining, 377–378

tuning, 526–528

LOAD Database statement, 64

Load Transaction statement, 64

local server accounts, 28

local service accounts, 28

local system accounts, 28

lock granularity for indexes, 483

lock pages in memory, enabling, 394

locks, monitoring, 93–94, 434

Log Reader Agent, replication using, 531

log sequence number (LSN), 594

log shipping

as alternative to clustering, 656

architecture of, 629–630

backup and recovery affects on, 628–629, 647

backup and recovery for, 606

compared to database mirroring, 585

configuring, 632–633

database mirroring integrated with, 648

deploying

with Management Studio, 634–637

scenarios for, 627–629

with T-SQL statements, 638

as disaster recovery solution, 628–629

failover clustering integrated with, 648

monitor server for, 630, 632

monitoring, 638–641

network requirements for, 632

performance of, 650

primary server for, 629

processes used by, 631

removing, 649–650

replication integrated with, 648–649

as report database, 629

role changing between servers

planned failover, process for, 644–645

redirecting clients, 646–647

switching between servers, 645–646

synchronizing dependencies for, 641–644

unplanned role change, process for, 645

secondary server for, 630

support for, by SQL Server edition, 15, 632

system requirements for, 631–632

troubleshooting, 638–639, 641

upgrading to SQL Server 2005, 72, 650–652

as warm standby server, 628

logical scan fragmentation, 475

logical unit numbers (LUNs), 371–372

logins for SQL Server instance. See also accounts for SQL Server; users

authentication for, 293–294

BUILTIN\Administrators login, 301–302

conflicts between access rights, 300–301

creating, 294–300

disabling, 299

granting access to objects, 299

granting database rights, 297–298

passwords for, 295–296

server roles for, 297

T-SQL for, 300

unlocking, 299

logs. See also log shipping; transaction log

default location for, setting, 42, 89

deleting, 46

displaying in Management Studio, 91

for jobs, 108

mirroring, 21

physical drive configuration for, 21

space required for, 66

specifying at startup, 83

SQLDiag.exe program using, 101

for SSAS, 184

log_shipping_databases table, 651

log_shipping_monitor table, 651

log_shipping_monitor_alert table, 638

log_shipping_plan_databases table, 651

log_shipping_plan_history table, 651

log_shipping_plans table, 652

log_shipping_primaries table, 652

log_shipping_secondaries table, 652

loop join (nested loop), 462–463

LSN (log sequence number), 594

LUNs (logical unit numbers), 371–372



Professional SQL Server 2005 Administration
Professional SQL Server 2005 Administration (Wrox Professional Guides)
ISBN: 0470055200
EAN: 2147483647
Year: 2004
Pages: 193

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net