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

mail system security, 532

maintaining databases

database consistency checks. See database consistency checks

database maintenance plans, 324–335, 325–335

exam essentials, 351

job dependency diagrams, 320–321

multiserver administration, 321–322, 322

Reporting Services. See SQL Server Reporting Services (SSRS)

review questions, 352–358

SQL Server Health and History tool, 322–324

summary, 350–351

tasks, 294–296

maintenance plans

Replication Monitor for, 504–505

SSIS packages, 375

management personnel for data assessment, 401

manual updates, 566

mappings, login, 464–468

Mars Deadlocks counter, 232

master servers (MSX), 322

MaxBCPThreads parameter, 509

MAXDOP query hint, 91

MBSA (Microsoft Baseline Security Analyzer), 565

MEDIAPASSWORD option, 192–193

memory

for locks, 123

performance object counters

baselines, 230

thresholds, 236

troubleshooting, 22–23, 42–44

Memory Consumption report, 25, 26

Memory Grants Pending counter, 238

Memory Subsystem for baselines, 230

MEMORYSTATUS command, 44

Merge Agent (replmerge.exe), 175, 479–480

Merge Join transforms, 377

merge replication, 175, 478

conflicts, 506–508, 507–508

multiple master approach, 432–433, 432

Merge transforms, 377

Message Queue task, 374

message types in Service Broker, 276

METADATA resource, locks for, 128

Microsoft Baseline Security Analyzer (MBSA), 565

Microsoft.Jet.OLEDB.4.0 provider, 462

Microsoft Update, 566

migration scripts, 545–546

MIRROR TO clause

BACKUP DATABASE, 190

BACKUP LOG, 191

mirroring

database, 172

RAID, 166–168, 167–168

Missing Column Statistics event class, 240

missing indexes, 79

Missing Join Predicate event class, 240

missing updates, 565

Mobius Management Systems, Inc., 399

money data type, 441

monitoring, 222

automatic, 221

component selection for, 222

latches, 119–121

physical servers. See physical server monitoring

for quality data, 403

replication. See Replication Monitor

in security, 533

tools, 222–224

MOVE option, 197

moving

reportserver database, 349, 349

SSIS packages, 382–383

MSDAORA provider, 462

MSDASQL provider, 462

MSrepl_commands table, 479

MSrepl_transactions table, 479

MSRS 2005 Web Service object, 343

MSRS 2005 Windows Service object, 343

MSSQLServer service, 559

MSX (master servers), 322

multi-instance clusters, 171, 171

Multicast transforms, 377

multiple copies, single maintenance approach, 427–428

multiple master approach

merge replication, 432–433, 432

peer-to-peer replication, 433–434, 433

multiple package versions, 361

multiserver administration, 321–322, 322