L

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