M


mail system security, 532

maintaining databases

database consistency checks. See database consistency checks

database maintenance plans, 324335, 325335

exam essentials, 351

job dependency diagrams, 320321

multiserver administration, 321322, 322

Reporting Services. See SQL Server Reporting Services (SSRS)

review questions, 352358

SQL Server Health and History tool, 322324

summary, 350351

tasks, 294296

maintenance plans

Replication Monitor for, 504505

SSIS packages, 375

management personnel for data assessment, 401

manual updates, 566

mappings, login, 464468

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, 2223, 4244

Memory Consumption report, 25, 26

Memory Grants Pending counter, 238

Memory Subsystem for baselines, 230

MEMORYSTATUS command, 44

Merge Agent (replmerge.exe), 175, 479480

Merge Join transforms, 377

merge replication, 175, 478

conflicts, 506508, 507508

multiple master approach, 432433, 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, 545546

MIRROR TO clause

BACKUP DATABASE, 190

BACKUP LOG, 191

mirroring

database, 172

RAID, 166168, 167168

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, 119121

physical servers. See physical server monitoring

for quality data, 403

replication. See Replication Monitor

in security, 533

tools, 222224

MOVE option, 197

moving

reportserver database, 349, 349

SSIS packages, 382383

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, 432433, 432

peer-to-peer replication, 433434, 433

multiple package versions, 361

multiserver administration, 321322, 322



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net