Index

Note to the Reader: Throughout this index boldfaced page numbers indicate primary discussions of a topic. Italicized page numbers indicate illustrations.

A

access control

in change control, 540–542, 540–541

locked doors, 524

to services, 559–561

accessible data, 402

accounts, service, 557–558

auditing, 562

level of privileges, 561

lockouts, 562–563, 562–563

selecting, 558–559

Acquired lock event class, 133

actions, documenting, 400

Active Temp Tables counter, 232

ActiveX controls, 492

ActiveX Script task, 373

Activity Monitor utility

instance performance, 29–30, 30

locks, 132, 132

Activity reports, 27

ad hoc distributed queries, 471

Add Counters dialog box, 7, 8, 13, 13

Add Filter page, 483, 483

administrators

auditing, 586–588, 586–588

workstations, 526

Advanced Tuning Options dialog box, 74, 74

AFTER DML triggers, 264–266, 265

age of passwords, 577

Agent History Clean Up job, 504

Agent Profiles page, 509

Agent Security page, 484–485, 484

agents

monitoring, 500

profiles, 508–511

replication, 175, 478–480

Aggregate transforms, 376

alerts, 242

condition, 250–253, 251–252

event, 246–250, 246, 248–250

replication, 494–498, 495–497

SQL Server Agent for, 242–246, 244–245

WMI event, 253–262, 254, 258

alias data types, 443–444

All Blocking Transactions reports, 49

ALL_CONSTRAINTS option, 300

All Transactions reports, 48, 49

ALLOCATION_ UNIT resource, 127

Allow inprocess option, 462

ALTER DATABASE statement

DML triggers, 264

emergency mode repairs, 208

recovery model, 180

redundancy checks, 425

repair operations, 303

snapshot isolation, 125

statistic updates, 112

ALTER INDEX statement, 105–108, 110

ALTER LOGIN statement, 581

ALTER permission, 579

ALTER TABLE statement, 493

ALTER TRIGGER statement, 493–494

Analysis Services Execute DDL task, 373

Analysis Services Processing task, 373

Analysis Services subsystem, 560

Analysis tools for quality data, 403

ANSI transaction isolation levels, 124

antivirus signatures, 531

APPLICATION resource, locks for, 127

application roles, 585

approximate numeric data types, 441

Article Issues page, 506, 506

Article Properties dialog box, 508, 508

articles, replication, 174, 475, 483, 506, 506, 508, 508

Articles page, 483

assessment, data, 400–401

asymmetric encryption, 571–572

attachable subscriptions, 492

Audit transforms, 376

auditing

login events, 582, 582

permissions, 557–559

server administrators, 586–588, 586–588

server-level, 574

service access, 559–561

service accounts, 562

authentication

SQL Server, 575–578, 576

Windows, 575, 577

AUTO_CREATE_STATISTICS option, 88

Auto-Param Attempts/sec counter, 234

AUTO_UPDATE_STATISTICS option, 88

AUTO_UPDATE_STATISTICS_ASYNC option, 114

automatic operations

monitoring requirements, 221

SSRS, 336–338, 337

updates, 566

autonomy in replication, 480

availability in replication, 480

Available Bytes counter, 22

Available Mbytes counter

baselines, 230

thresholds, 236

Average Latch Wait Time (ms) counter, 234

Average Wait Time (ms) counter, 233

Avg. Bytes Free per Page statistic, 313

Avg. Disk Bytes/Read counter, 231

Avg. Disk Bytes/Write counter, 231

Avg. Disk Queue Length counter, 23, 236–237

Avg. Disk Read Queue Length counter, 230

Avg. Disk Sec/Read counter, 23

Avg. Disk Sec/Write counter, 23

Avg. Disk Write Queue Length counter, 230

Avg. Page Density (full) statistic, 313

Avg. Pages per Extent statistic, 312