M

(MACH) token, 134

mail

Database Mail

account for, 130, 131

architecture of, 127–128

archiving, 133

configuring, 81, 129–133

default settings for, 75

definition of, 127

enabling, 129, 130

security of, 129

troubleshooting, 142

upgrading to, 66

SQL Mail

compared to Database Mail, 127

configuring, 81

default settings for, 75

migrating to, 66

Management Objects, 90

management processor (MP), 347

Management Studio

Activity Monitor, 92–95, 404

actual execution plan, viewing, 462

backup execution using, 607–612

configuring SQL Server using, 87–90

creating projects, 321–322

database reports in, 86–87

executing sqlcmd program from, 332–334

filtering objects using, 90

log shipping

deploying, 634–637

removing, 649

logs, displaying, 91

managing SSIS packages, 163–164

post-install configuration using, 42

processing SSAS databases, 192–194

recovering database using, 617–620

Server Properties screen, 87–89

server reports in, 85–86

viewing SSIS event logs with, 156

viewing XML Showplan using, 427–428

manual failover, database mirroring, 549, 565–566

MARS (Multiple Active Recordsets), SQL Native Client used by, 5

master database

backing up, 7, 601–602

definition of, 6–7

objects in, 7

specifying at startup, 83

master servers (MSX), 138–141

master.dbo.sp_add_log_shipping_primary_database procedure, 638

master.dbo.sp_add_log_shipping_primary_secondary procedure, 638

master.dbo.sp_add_log_shipping_secondary_database procedure, 638

master.dbo.sp_add_log_shipping_secondary_primary procedure, 638

master.dbo.sp_help_log_shipping_monitor procedure, 639

max server memory option, 401

MAXDOP (max degree of parallelism), 400

MDAC (Microsoft Data Access Components)

upgrading to SQL Server 2005 affected by, 65

using new features with, 5

memory

bottlenecks, resolving, 416–417

CLR integration's usage of, 291

configuration scenarios for, 359–362

displaying information about, 87–88

dynamic memory configuration on X86, 392–395

index creation memory option, 401–402

lock pages in memory, enabling, 394

max server memory option, 401

min memory per query option, 401

minimum configuration warning regarding, 49

monitoring usage of, 93, 414–417, 438

NUMA systems, 345

page faults, 356

page file, 355–356

performance considerations for, 345, 354–362

physical address space, 355

physical memory (RAM), 354

reserving additional memory at startup, 83

scalability and, 13

setting minimum and maximum for, 42, 65

64-bit system configuration for, 359

32-bit system configuration for, 357–359

tuning, 389–395

virtual address space, 357

VMM, 355

memory node, 391

memory usage counters, Performance Monitor, 414–417

memory-friendly applications, 395

Merge Agent, replication using, 531

merge join, 464–465

merge replication, 530, 541

messages, exchanging between applications. See Service Broker

Microsoft Data Access Components (MDAC)

upgrading to SQL Server 2005 affected by, 65

using new features with, 5

Miller, Chad (Raymond James Financial), 706

min memory per query option, 401

minimal mode, enabling at startup, 83

mirror database

definition of, 548

snapshots on, 589–590

mirror server

definition of, 548

preparing for failover, 579–583

mirror with stripe, 368

mirroring. See database mirroring

model database

backing up, 602

changes to, 6

definition of, 7

MOLAP (Multidimensional OLAP), 202

money data type, 10, 11

monitor server, for log shipping, 630, 632

monitoring. See also performance

with Activity Monitor

active connections, 92–93

definition of, 92, 404

disconnecting processes, 93

lock information, viewing, 94–95

CLR integration, 290–292

database mirroring

using Database Mirroring Monitor, 572–577

using SQL Profiler, 577

using System Monitor, 570–572

database, with DMFs and DMVs, 433–438

DDL triggers, 325, 329

disk activity, 408–414

with DMFs and DMVs, 433–438

events

event notifications for, 417, 431–433

reasons for, 417–418

SQL Trace for, 418–431

goals for, 403–404

index fragmentation, 497–498

index usage, 435–437

locks, 93–94, 434

log shipping, 638–641

memory usage, 93, 414–417, 438

processes, 92, 95–97

processor usage, 406–408

queries, 437–438

replication, 544–545

server, with DMFs and DMVs, 433–438

Service Broker, 267–268

SSAS, 198–201

SSIS, 156–158

tools for, 404

MP (management processor), 347

MS TPC-B Benchmark Kit, 378

msdb database

backing up, 7, 602

definition of, 7

msdb_dbo.sp_add_log_shipping_alert_job procedure, 638

msdb.dbo.sp_add_schedule procedure, 638

msdb.dbo.sp_attach_schedule procedure, 638

msdb.dbo.sp_update_job procedure, 638

msdb.dbo.sysmail_delete_log_sp procedure, 133

msdb.dbo.sysmail_delete_mailitems_sp procedure, 133

MsDtsSrvr.ini.xml file, 150–151

msmdsrv.ini file, 183

msmdsrvr.exe program, 183

(MSSA) token, 134

mssqlsystemresource.mdf file, 6

MSX (master servers), 138–141

multi-core systems

licensing for, 16

performance considerations for, 351–353

planning requirements for, 20

Multidimensional OLAP (MOLAP), 202

multinodes clusters, 661–662

Multiple Active Recordsets (MARS), SQL Native Client used by, 5

multiple instances of SQL Server, 28–29

multiprocessor systems

counters for, 406

licensing for, 16

Multiprotocol, 65

multiserver administration

event forwarding, 136

master servers, 138–141

target servers, 138–141

token replacement, 133–136

using WMI, 136–138