Specifications

210
overutilized resources, 92
processor utilization, 96
underutilized resources, 92
viewing, 91
Managed Instances viewpoint (Utility Explorer), 95-100
management node, 114
management utilities. See Best Practices Analyzer (BPA);
SQL Server Utility
ManagementService API, 163
maps, 177-178
massively parallel processing (MPP), 9
master data, 125-126
Master Data Manager
areas in, 128-129
batch creation, 135-136
data maintenance with, 131
data stewards, 127
model deployment, 142
subscription view, creating, 136
Master Data Services Conguration Manager, 128
MDS (Master Data Services)
API, 127, 142-143
authentication, 127
authorization, 138
business rules, 132-133
class library, 142-143
conguring, 128
data stewards, 127
database, 128
as development platform, 142
exporting master data, 136-137
exibility of, 126
importing master data, 135
installing, 127
locking data in, 139-140
master data hub, 126
overview of, 125
permissions, 138
tables in, 135
transaction logs, 131-134
Transact-SQL functions, 143-144
versioning, 127-128, 137-138
Web services API, 143
measures (PivotTables), 199-200
members (MDS), 129-130
memory, upgrading online, 63
memory requirements, 14
Microsoft Assessment and Planning Toolkit, 75
Microsoft Press support Web site, xix
Microsoft SQL Azure, 9
I
importing master data, 135
indicators in reports, 176-177
InniBand network, 110, 112
in-place upgrades, 16-17
input adapters, base classes, 151
installing MDS (Master Data Services), 127
instances. See also managed instances; SQL Server
instances
enrolling, 29-32
utilization, monitoring, 91
validating, 31
viewing, 91
Integration Services, 123
InteractiveSize property (reports), 172
Internet Explorer requirement, 15
interval event model, 147
J
join operations, 161
L
Landing Zone node, 114
linked documents, 205
linked tables, 193
LINQ expressions, 155
Live Migration. See also Hyper-V
benets of, 87-88
conguring virtual machines for, 79-82
implementing, 75
initiating, 83
overview of, 64, 72
load activity, monitoring, 122
look-and-feel properties, 169-170
Lookup function, 166
LookupSet function, 168
M
managed instances. See also instances; SQL Server
instances
global policies for, 34
health status of, 91
maximum number of, 29
importing master data