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