(MACH) token, 134
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