MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

B-trees (balanced trees), 94, 95, 102–103, 102

Back Up Database Task dialog box, 334, 334

Backup and Restore Events reports, 48

BACKUP DATABASE statement, 190–193

BACKUP LOG statement, 190–192

BACKUP SERVICE MASTER KEY statement, 573

backups

BACKUP DATABASE statement, 190–193

differential, 185–187

file and file group, 187–188

full, 183

maintenance plans, 326

partial, 188–189

restoring, 194–204

in security, 525–526

SSRS, 348–349, 348

strategy planning, 179–180

tail-log, 185

transaction logs, 184–185

balanced trees (B-trees), 94, 95, 102–103, 102

baselines, 225–226

database engine, 231–234

disk I/O, 230–231

establishing, 226–227, 229

memory, 230

network I/O, 231

processors, 229

replication performance, 513

Batch Requests/sec counter, 40, 234

batch_size option, 308

BatchCompleted event class, 242

BatchStarting event class, 242

BEGIN TRY/END TRY block construct, 114–115

benchmarks, 226

BIDS (Business Intelligence Development Studio), 361, 363–364, 364, 379

bigint data type, 440

binary data type, 442

binary strings, 442

bit data type, 440

BizTalk Server 2006 server, 404

Blob Bytes Read counter, 386

Blob Bytes Written counter, 386

Blob Files in Use counter, 386

Blocked Process Report event class, 240

bookmark lookups, 87

bottlenecks, 20, 23–24, 44–45

breakpoints, 385, 385

Browse for Objects dialog box, 497, 497

Buffer Cache Hit Ratio counter

baselines, 231

thresholds, 43, 237

Buffer Memory counter, 386

buffers, removing, 309–310

Buffers in Use counter, 386

Buffers Spooled counter, 386

Bulk Insert task, 373

BULK_LOGGED recovery model, 181–182

bulkadmin role, 580

Business Intelligence Development Studio (BIDS), 361, 363–364, 364, 379

business requirements

data assessment, 401

encryption, 570–574, 570

security, 526–527, 537–538

Bytes Received/sec counter, 231

Bytes Sent/sec counter, 231

Bytes Total/sec counter, 237