MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
Latch Waits/sec counter, 234
latches, 118–119
monitoring, 119–121
resolving issues, 121–122
latency, replication, 480
baselines, 513
transactional, 477
verifying, 501, 501
Lazy Writes/sec counter, 232
left outer joins, 407–409, 407, 409
Lefter, Cristian, 114
level of privileges, 561–563
Level zero only option, 462
linked lists, 102, 102
linked servers, 456–458, 457
for delegation, 468–469, 468
distributed queries, 469–474, 470, 472–473
implementing, 458–464, 461, 463
login mappings, 464–468
on named instances, 467–468
Local Service account, 558
Local System account, 558
@locallogin parameter, 466
@location argument, 459
Lock Requests/sec counter, 233
Lock Timeouts (timeout > 0)/sec counter, 233
Lock Timeouts/sec counter, 233
Lock Wait Time (ms) counter, 233
Lock Waits/sec counter, 233
locked doors with access codes, 524
lockouts, service accounts, 562–563, 562–563
locks
Activity Monitor for, 132, 132
architecture, 122–123, 126–132
compatibility, 129–131
counters for, 133
database options, 138
deadlocks. See deadlocks
DMVs, 134–137, 137
escalation, disabling, 139
event classes, 240–241
hints, 139–140
isolation levels, 123–126, 138
issues, 137–138
request modes, 128–129
request status, 132
system stored procedures, 134
system tables, 137
Locks by Object view, 29
Locks by Process view, 29
Log File Viewer, 28, 28
log files. See logs
Log Files tab, 14, 14
Log Flush Wait Time counter, 238
Log Flush Waits/sec counter, 232
Log Reader Agent (logread.exe), 175, 480
log shipping, 172–173, 173
logical integrity checks, 301–304
logical operation of query plans, 83
Logical Scan Fragmentation statistic, 312
Login Properties dialog box, 576, 576
LOGINFO command, 51
logins
authentication, 575–578, 576
configuring, 204–205
enabling or disabling, 581
event auditing, 582, 582
mappings, 464–468
server, 578–580
Logins/sec counter, 232
Logon Total counter, 231
Logouts/sec counter, 232
logread.exe (Log Reader Agent), 175, 480
logs
for deadlocks, 143–146
in debugging, 385
instance performance, 27–28, 28
restoring, 200–201
in security, 525, 533
SSRS, 346–347
stored procedures, 114–115
transaction
backups, 184–185, 191–193
restoring, 200–201
lookups, fuzzy, 377, 426
lost data, recovering, 205