Specifications

213
Theater view (PowerPivot Gallery), 204-205
Time Intelligence functions (PowerPivot), 193
TopK operation, 160
transaction logs
for MDS, 131-134
space allocation, 118
Transact-SQL functions, 143-144
troubleshooting failover clustering, 70
tumbling windows, 157-158
U
UCPs (Utility Control Points). See Utility Control Points
(UCPs)
UMDW (Utility Management Data Warehouse). See
Utility Management Data Warehouse (UMDW)
underutilization thresholds
default, 34
variance in, 85
underutilized instances, 91
Unicode compression, 10
union operations, 161
upgrading data-tier applications (DACs), 59-61
upgrading hardware online, 63
upgrading SQL Server
in-place upgrades, 16-17
side-by-side migration, 18-19
user-dened functions (UDFs), 161
Utility Administrator, 37
utility collection set account, specifying, 27, 30
Utility Control Points (UCPs), 21-22
capacity specications, 25
connecting to, 33-34, 89
creating, 26-29
disconnecting from, 34
enrollment of, 29
frequency of data collection, 23
managed instances, maximum number of, 29
msdb database, 25, 52
naming, 27
overview of, 4, 23
prerequisites for deployment, 25-26
report on creation of, 28
SQL Server edition required for, 26
validating, 28
snapshot windows, 158
software requirements, 15
sparklines, 176
Split function, 167
SQL Azure, 9
SQL Server editions, 11. See also specic editions
SQL Server instances. See instances; managed instances
SQL Server Management Studio, 49-51
SQL Server objects, 44-45
SQL Server PowerShell. See Windows PowerShell
SQL Server Utility. See also Utility Control Points (UCPs);
Utility Explorer
dashboard, 89-95
monitoring with, 89
overview of, 4, 21-23
Standard edition, 13
StreamInsight
aggregation functions, 159-160
core engine, 146
deploying, 149-150
development support, 146
event models, 147
event windows, 156-159
events, 147
as hosted assembly, 149
join operations, 161
ManagementService API, 163
overview of, 145
query objects, 163
as standalone server, 149-150
streams, 147
TopK operation, 160
union operations, 161
subscription views (MDS), 136
support for book, xix
Sysprep, 9
sysutility_mdw. See Utility Management Data
Warehouse (UMDW)
T
tables. See also PivotTables
calculated columns in, 199
exporting, 120
loading rows into, 122
measures in, 199-200
text box orientation in reports, 174
Utility Control Points