Index
A
ACID, 397
Analyzing peak load data, 446
application usage, 446
anomaly views, 447
capacity planning, 446
observations, 447
performance, 446
SLA, 448
third party monitoring, 446
transaction monitor, 448
virtual IP, 446
weekend analysis, 449
configuration, 455
assesment, 456
capture settings, 456
database properties, 457
sp_configure, 456
validation, 456
virtual log files, 457
perfmon, 449
disk sec/read, 452
hyperlink to support, 451
line view, 451, 453
logical disk counters, 452
performance analysis of logs, 450
reiewing line view, 454
report, performance analysis of logs, 450
report view, 452
report view review, 454
review, 449
time slices, 450
with PAL review, 453
perfmonmax server memory, 450
SQL, 458
analsis behaviour, 459
clustered key, 461
current activity, script, 459
extraction, transformation and load (ETL), 460
identifying to tune, 461
indexes, 460
I/O performance, 458
observations, 459
reporting databases, 460
traces, 458
transactional databases, 460
unique blocking chains, 460
usage statistics, 460
Apache Sqoop, 409
Association for Computing Machinery (ACM, 20
Atomicity, consistency, isolation, durability (ACID), 397
Auditing, 221
application logs, 232
creating T-SQL, 226
database audit specification, 230
define, 226
event alerts, 232
database backup, 233
database creation, 233
error number, alert, 233
new page, 234
Windows application log, 232
fn_get_audit_file, 231
in SQL server, 224
filtering, 225
log failures, 225
rollover files, 225
server level, 225
user defined, 225
query, 231
server audit, 226
Corp_Audit, 229
T-SQL, 226
server audit file creation, 227
specifications, server audit, 228
Automating administration, 235
tasks, 263
backups and restores, 267
database integrity, 269
index maintanence, 269
monitoring, 264
statistics maintanence, 270
tools, 235
dynamic management views (DMVs), 237
monitoring performance, 235
PowerShell, 262
SQL server agent, 238
B
Backups and restores, 375
automating on groups, 386
log backups, 386
T-SQL scripts, 388
availability group setting, 376
SQL server availablility, 377
enabling backups, 383
location, 383
performing, 383
priority, 384
removing replicas, 384
failover clustering service, 376
recovery on groups, 391
restored data, 392
Windows server, configure, 376
Boyce-Codd normal form, 23
Business bubble, indexing, 191
data integrity, 193
description, 193
foreign key index, 195
foreign key query, 194
unindexed foreign keys query, 193
description, 191
index business usage, 191
C
Checklists, 136
daily checklists, 136
automate, 136
backups, 136
integrity, 137
security, 137
SQL server jobs, 137
longer term items, 137
audits, 137
patches, 137
SQL server, 138
Cloud-computing, 293
Clustered Key, 461
Common Language Runtime (CLR), 144
Community Technology Preview (CTP), 397
Compliance, 221
health insurance portability and accountability act (HIPAA), 223
data, 223
health and human services (HSS), 223
protected health information (PHI), 223
transactions, 223
Sarbanes-Oxley (SOX), 221
committee of sponsoring organizations(COSO), 222
database actions, 223
information systems audit and control association (ISACA), 222
internal controls, 222
regulated data, 223
reports, 222
securities and exchange commision (SOC), 222
Compression, 335
database, what and how, 337
creation of object, 337
objects by partition, 337
rebuild a heap, 337
editions and support, 336
fragment and log
COMMIT TRAN, 357
create DB, 356
LOP_COMPRESSION_INFO, 358
transaction log, 356
page, 341
applying, DBCC IND, 343
applying dictionary compression, 345
column prefix, applying, 344
data on disk, 345
dictionary compression, 342
structure, reaarange, 342
row, 338
compressed record, 341
create and insert, data records, 338
data records, 338
DBCC IND, 339
internal data records, 340
transaction levels, SQL server, 340
working with, 346
allocation units, 347
data types, allocation, 348
fragment and log, 355
IN_ROW_DATA, 348
LOB_DATA, 350
pattern usage, 354
scan and update DB, 352
sp_estimate_data_compression_savings, 355
sp_MSforeachtable, 347
configuration management database (CMDB), 433
Continuation of operations planning/Disaster recovery (COOP/DR), 335
Control Objectives for Information and Related Technologies (COBIT), 222
D
database administrator (DBA), 429
Database architecture
infrastructure, 294
authorization, 294
DoS attacks, 294
instances, 294
replication topology, 295
security, 294
instance availability and failover, 295
physical servers, 295
Database Console CommandDs (DBCCs), 315
Database design for performance, 17
requirements, 18
implementation non-specific, 19
waterfall method, 18
table structure, 20
history, 20
normal database vs. extraordinary one, 21
physical models, 33
relational database management systems (RDBMS), 21
relational model, 20
testing the design, 40
Database Engine Tuning Advisor (DTA), 170
Database utility, 135
checklists, 136
automation, 136
daily checklists, 136
longer term items, 137
data collection, 143
AlwaysOn feature, 156
business indicator key management, 156
common language runtime (CLR, 144
dynamic management views (DMV), 144
error logs, 148
extended stored procedure, 143
failed jobs, 152
fragmenting index, 149
indexes, 149
mirroring database, 154
performance of stored procedure, 151
processor, 146
sp_Cycle_Errorlog, 149
SQL server reporting services (SSRS), 153
storage, 144
sys.dm_exec_query_stats, 151
system tables, 143
layouts, 138
creating utility, 140
data storage, 138
referential integrity, 140
schemas, 140
table structure, 141
using data, 158
automating, data collection, 158
error handling and archives, 158
job task, 159
scheduling data collection, 159
Data capture, peak load, 436
application performance, 444
application profiling, 444
guidelines, 444
profiler and attributes, 445
transactional activity, 444
data collector
manual, 437
monitoring applications, 439
object counters, 439
performance counter, 438
set creation, 437
stop condition, 443
dat collector
scheduling, 443
performance gathering, 436
counter, 438
data collector, 436
dependency, 436
metrics, 436
monitoring, 439
object counters, 439
perfmon, 436
principles, 436
scheduling, 443
stop condition, 443
Data Definition Language (DDL), 275
Data referential integrity (DRI), 140
data-tier application (DAC), 310
Data warehouse (DW), 362
Dedicated Administrator Connection (DAC), 13
Default Trace, 108
Denial of Service (DoS), 294
Devise, plan, 462
technologies, 462
tune plan, 462
workload options, 462
Distributed partition view (DPV), 333
Dynamic Management Functions (DMFs), 71
Dynamic management objects (DMOs), 163
environment bubble
column uniqueness, 166
equality columns scenario, 166
inequality columns scenario, 167
missing index information, 163
missing index query columns, 164
performance impact, 163
recommendations, 165
Dynamic management views, 71
physical performance queries, 87
database engine tuning advisor, 89
dm_db_missing_index_details, 88
dm_db_missing_index_groups, 88
dm_db_missing_index_groups_stats, 88
index, partitioned, 92
missing indexes, 87
partition statistics, 92
row partitions, 93
tables, 91
table scans vs. index scans, 90
tuning gains, 90
unused index, 91
process basics, 71
joining processes, 74
naming, 72
related views, 72
tuning DBs, 74
varbinary hash values, 73
variable length, 73
system tuning, 93
active queries, 94
OS processes on DB server, 96
performance, 93
read tables, 98
request availability, 94
sessions and percentage, 93
thread ID matching, 95
transactional snapshot, 97
virtual table, 98
wait types, 95
tuning, 74
accuracy, 79
avg time vs. no. of executions, 86
blocking session, 77
challenging queries, 81
connected sessions, 75
counts, execution, 81, 86
current requests, 77
demo, current requests, 76
dm_exec_connections, 74
dm_exec_query_plan, 79
dm_exec_query_stats, 80
dm_exec_requests, 75
dm_exec_sql_text, 79
executing requests, 75
inspection, 85
lock escalation, 77
locking escalation demo, 78
performance of CPU, 85
performance optimization, 82
performance scripts, 80
physical reads, 87
query, SQL statements, 83
read data, 87
reports of performance, 84
retrieve connections, 74
SQL performance, 78
terminology divergence, 82
XML plans, 82
Dynamic management views (DMV, 439
Dynamic management views (DMV), 237
Dynamic Management Views (DMV), 324
Dynamic management views (DMVs), 1
Dynamic Management Views (DMVs), 144, 304
E
Environment bubble, indexing, 162
analysis performance, 188
DTA analysis report list, 190
XML input file configuration, 188
database preparation, 186
cloning, 186
PowerShell, 186
Server Management Objects (SMO), 186
description, 162
missing indexes identification, 162
attributes, 162
DMOs, 163
plan cache, 168
recommendation, 162
sample workload, 184
workload collection, 171
extended events, 175
SQL Trace session, 171
F
Failover cluster instance (FCI), 282
Federations, SQL database, 300
data types, 303
features, 301
limitations, 303
root database, 300
scenario, 302
ALTER FEDERATED, 302
creating federation, 303
FEDERATED ON, 302
split, 303
schema changes, 304
T-SQL changes, 301
commands and views, 302
statements, 301
user interface, 304
Firewalls, 298
Fluid dynamics. See SQL server data movement
G
Globally unique identifier (GUID), 278
Gotchas. See Hidden performances
H
Hadoop implementation, 396
Hashing, 298
Hidden performances, 43
predicates, 43
b-tree, 46
cases, 46
causes, 49
clustered index, 58
conversion, 56
data types, 52
define, 43
evaluating functions, 55
executing index seek, 47
executing key lookup, 50
execution plans, 44
function, 54
implicit conversion, 57
index architecture, 46
inefficient cluster, 59
key lookup, 51
no, 57
nvarchar, 57
optimal indexes, 45
OrderDate, 47
OrderStatus, 47
scan, index, 48
secondary filter, 48
subtotal index, 50
usage of index, 51
residuals, 59
actual joins, 64
build and probe, 63
hash joins, 62
hash, without, 64
join operator, 61
join residual, 60
joins, hash, 62
many-to-many join, 61
mismatched data types, 63
non-equality joins, 64
partial join, 60
queries, 60, 64
spills, 65
accurate estimation, 66
hash warnings, 67
inaccurate estimation, 66
memory grant, 65
RAID array, 69
SAN, 69
solid state drives (SSD), 69
splitting TempDB, 69
SQL profiler, 67
TempDB, 68
tuning, 68
Histogram, 117
event counter, 117
event file, 117
event Tracing for Windows, 117
pair matching, 117
ring buffer, 117
Host bus adapter (HBA), 332, 434
I
Implement changes, 3
document creation, 7
environment mapping, 3
CMD, 4
msdb database, 4
SQLPING, 4
SQL server agents, 4
sysprocesses view, 4
future steps, 15
limits, 12
address range, 13
DFF, 12
local connections, 13
logging and resource control, 15
logon trigger, 13
logon triggers, 12
parsing IP address, 13
PBM, 15
RACF, 12
SERVER STATE, 14
SNA, 12
sys.dm_exec_connections, 13
trigger, LOGIN, 14
WSRM, 15
new environment, 5
editions, 6
features, 5
naming, 6
patching, 6
privileges, 6
SQL server versions, 5
reporting, 10
system-management procedure, 7
EXECUTE, 10
maning and placement, 7
stored procedure, 8
table creation, 8
user creation, 7
web server, 7
version, 11
compatility enabling, 11
exception handling, 11
Indexing, 161
business bubble, 191
data integrity, 193
description, 191
index business usage, 191
environment bubble, 162
description, 162
missing indexes identification, 162
workload evaluation, 170
Information Systems Audit and Control Association (ISACA), 222
input/output operations per second (IOPS), 362
Internet Information Services (IIS), 432
Internet protocol (IP), 294
I/O, 313
access to data, 324
disk stalls, 324
dm_os_wait_stats, 326
DMV, 324
OLTP, 324
query, 325
rebuild, 327
resultant data, 325
server activity, 327
SPIDs, 327
statistics of usage, 328
sys.dm_os_schedulers, 328
T-SQL query, 326
backup changes, 322
change in time, 323
fault tolerance, 323
middle tier servers, 324
RAID levels, 323
shared disk, 324
SLA, 324
code or disk, 321
considerations, 315
database console commands (DBCCs), 315
disk reads, 316
IOP, 316
key performance indicators, 316
OLTP, 317
type, 317
database environments, 313
data set, 322
environmental considerations, 331
backup compression, 333
compression, 333
data compression, 333
distributed partition view, 333
host bus adapter, 332
partititon elimination, 333
serialized, 332
SOLIQ test, 332
workload, 332
initiatives, 314
counters, 314
performance monitor, 314
monitoring, 314
counters, 315
logical unit number, 315
storage subsystem, 315
query addressing, 328
AdventureWorksDW2008R2, 328
compression and rebuild, 331
criteria, where, 330
data cache, 328
FactInternetSales, 329
GROUP BY, 329
index creation, 330
messages tab, 329
reads, 329
SET STATISTICS IO ON, 328
sp_help output, 330
STATISTICS IO, 330
tactics, 317
counters, 318
data collector, 319
data type, 320
disk read and write, 317
logical disk, counters, 321
logs, 318
read and write, 318
size, 319
TempDB usage, 323
J
JDBC, 57
Jobs,SQL server, 137
K
Key Business Indicator (KBI), 156
L
Landing pad, 346
Local area network (LAN), 21
Logical unit number (LUN), 315
M
Maintenance plan, SQL server
database integrity, 257
report options, 258
tasks order, 256
Maintenance plans, SQL server, 254
tasks in wizard, 255
Managing releases
change request, 198
concerns, 199
ineffective process, 198
process overview, 199
documents, 207
notes, 208
plans and plan templates, 212
repository, 219
request records, 207
processes, 197
ineffective, 198
Microsoft SQL server 2012, 336
Microsoft SQL Server 2012, 375
Microsoft’s Team Foundation Server, 206
N
Normal database vs. extrordinary one, 21
normalization, 22
applications, 23
(Semi-) formal, 22
Normalization, 22
applications, 23
columns, 24
complex problems, 23
entire key dependency, 29
key, single expression, 31
uniqueness, table/row, 26
(Semi-) formal, 22
Boyce-Codd normal form, 23
fifth normal form, 23
first normal form, 22
fourth normal form, 23
O
Online Transactional Processing (OLTP), 324
Online transaction processing (OLTP), 362
P, Q
Performance Analysis of Logs (PAL), 450
Performance guidelines. See Guidelines
Physical model, 33
constraints, 36
address table, 38
domain tale, 39
keys, 37
SQL server constraints, 37
datatypes, 34
approximation, 34
character, 35
data type precedence, 36
indexes, 35
precise, 34
indexing, 39
foreign keys, 40
uniquness, 39
Policy-based management (PBM), 15
Policy Based Management (PBM), 201
PowerShell, 262
automate, 263
drive space, 263
launching, 263
Processor utility
databases, 146
Public Company Accounting Oversight Board (PCAOB), 222
R
RAID array, 69
Redundant array of independent disk or disks (RAID), 323
Relational database management system (RDBMS), 395
Relational database management systems (RDBMS), 21
Relational Model, 20
Releases documents
notes
code evaluation, 210
date tracking, 209
evaluation, 210
hand off, 210
information, 208
name, 209
performance, 211
plan, 209
plan creation, 210
receive and analyse, 209
requested plan, 209
review plan, 210
rollback, 210
sample, 208
testing, 211
plans and templates, 212
activities, 214
change requirement, 216
comparison tool, 218
developers questions, 214
generic information, 212
information, synopsis, 213
questions, 214
Red Gate SQL tool, 218
replication, 216, 218
report generation, 218
snapshot generation, 218
steps, 217
synopsis, 212
Requested change, releases, 198
developers, 205
environment, 203
database, 204
multiple development, 204
preproduction, 204
production, 203
quality assurance, 204
testing, 203
goals, 200
architect/design, 202
change in controll, 200
churn, 202
evaluation, 203
executions, 202
naming, 202
performance, 201
policy based management (PBM), 201
practices, 201
risk reduction, 200
T-SQL statement, 201
processes, 205
process overview, 199
rollback, 207
versions, 206
PowerShell, 206
third party tools, 206
Resource Access Control Facility (RACF), 12
S
Sarbanes-Oxley (SOX), 221
Secure Sockets Layer (SSL), 298
Security identifiers (SIDs), 260
Server selection and sizing, 361
database server, 373
Dell servers, 366
comparisons, 368
PowerEdge R320, 366
POwerEdge R420, 367
PowerEdge R520, 367
PowerEdge R620, 367
PowerEdge R720, 368
PowerEdge R720xd, 368
PowerEdge R820, 368
form factor, 364
I/O vs. blade servers, 365
processor socket, 365
rack mounted servers, 365
rack units, 364
server size, 365
tower servers, 365
licensing cost, 373
memory selection, 372
AMD servers, 372
business intelligence, 372
flash storage, 372
prices, ECC DDR3, 372
RAM processing, 373
settings, 372
SQL server, 372
SSAS, 372
model selection, 370
core licenses, 371
DIMMs, 371
E5-2693 and 2643, 371
Intel Xeon E5-2690, 371
licensing, 371
processor kit, 370
series, Intel Xeon E5, 371
socket based, 370
processor count, 366
PCI-E, 366
physical count, 366
storage subsystem, 366
two-socket server, 366
server vendor, 364
first tier, 364
socket server, 364
various organizations, 364
vendors, 364
SQL server 2012, 362
enterprise edition factors, 362
vendor selection, 369
AMD, 369
HP, 369
in Fujitsu, 369
Intel, 370
TPC-E benchmark, 369
workloads, 369
workload, 361
DMV and DMF, 362
instances, 362
IOPS, 362
query optimizer, 362
single threaded, 362
SLA, 431
Solid State Drives (SSD), 69
SQL 2008, 299
SQL Datababase
SQL server Vs. SQL database
size of databases, 299
SQL Database, 293
architecture, 294
federations, 296
infrastructure, 294
instance availability and failover, 295
instance phases, 295
physical servers, 295
costs, 311
dynamic management views, 304
federations, 300
data types, 303
distributuion names, 300
fan-out, 303
features, 300
FederationCust, 301
identity, 303
in SQL database, 301
isolated schema, 304
limitations, 303
merge, 303
root database, 300
scenario, 302
T-SQL changes, 301
user interface, 304
instance, 294
instance costs, 311
one size fits all, 293
services, 308
BACPAC, 310
data-tier application (DAC), 310
import/export, 310
Windows Azure SQL Data Sync, 309
Windows Azure SQL Reporting, 308
SQL server Vs. SQL database
backups and restores, 299
portal functions, 297
security, 298
SQL database management portal, 297
SQL server management studio, 297
T-SQL support, 299
versions, 299
Windows Azure management portals, 297
troubleshooting, 304
dashboard, 306
DMVs, 304
executions, 305
SQL Database Management Portal (SDMP), 297
SQL network interface (SNI), 346
SQL performance analyzes, 458
analysis behaviour, 459
instances, 459
I/O performances, 458
observations, 459
clustered key, 461
extraction, transformation and load (ETL), 460
indexes, 460
transactional databases, 460
usage statistics, 460
reporting databases, 460
traces, 458
unique blocking chains, 460
SQL server, 377
database list, 378
AdventureWork2008R2, 378
AOTest, 378
MirrorMe, 378
enabling availability, 377
properties for group, 382
SQL Server, 235
implementing changes, 3
viewpoints, 2
SQL Server 2012, 137, 153, 299
SQL server agent, 238
alerts, 247
errors and severity levels, 247
event alert, 247
performance conditions, 248
responses, 250
setting options, 251
WMI events, 249
job
DMV queries, 242
notifications, 246
options, set up, 244
run set up, 242
scheduling job, 244
setting up schedule, 245
set up, 243
job properties, 241
jobs
activity monitor, 241
creating DBAInfo and monitoring, 240
logs, 265
failed jobs, 266
long-running jobs, 266
operators, 239
plans
creating, 254
tasks, 252
SQL server integration services
IfObjectExists, 260
login options, 260
package execution, 262
task editor, 260
transfer logins, 261
transfer tasks, 259
SQL Server Analysis Services (SSAS), 372
SQL server and developers, 1
SQL server data movement, 271
choosing deployment, 288
decision factors, 288, 289
data consistency, 290
AlwaysOn, 291
bulk copy process, 292
ETL processing, 291
log shipping, 291
mirroring, 291
recovery, 290
redundancy, 290
data replication, 271
disaster recovery, 272
globalization, 272
hardware failure, 273
overnight processing, 273
reporting needs, 272
soultions, 273
advantages, mirroring, 281
AlwaysOn, 282
AlwaysOn failover, 285
asynchronous transaction, 281
availability groups, 283
benefits, transactions, 275
bulk copy process, 287
clustering scenarios, 286
ETL processing, 286
ETL using SSIS, 286
failover benefits and limits, 285
failover clustering, 284
groups, 282
limits and benefits, BCP, 287
log backups, 278
log readers, 275
log shipping, 279
merge, 276
mirroring database, 280
peer-to-peer, 276
replication, 274
replication, merge, 277
scenarios, replication, 278
snapshot, 274
synchronous transaction, 281
transactional replication, 274
SQL server DBA
architecture, 396
as data architect, 405
data flow, 406
Hadoop, 405
Mapreduce, 405
big data, 395
archives, 426
business cases, 426
business intelligence, 425
business rules, 427
discovery, 427
nonrelational dataset, 426
sources, 425
streaming data, 426
unstructured, 426
data for analytics, 406
Hadoop, 407
noninteractive, 406
PowerView, 406
process steps, 406
data types, 396
data with Hadoop, 397
cluster, 397
code, 398
CTP, 397
data nodes, 398
framework, 397
framework, MapReduce, 402
hardware, 404
HDFS, 397
HDFS dataset, 399
job, MapReduce, 402
key-value pairs, 403
map function input, 400
MapReduce, 397
MapReduce, nucleus, 398
output, map function, 401
tasks, 399
work flow, MapReduce, 400
Hadoop, 396
in Microsoft, 427
mapred-site.xml, 400
nonrelational, big data, 396
using Hadoop, 407
AdventureWorks, 409
Azure CTP, 410
commands, Hive, 418, 424
data practice, 408
datasets browsing, 412
data transfers, 409
ecosystem, 409
environment, 410
extract, data filter, 413
HDFS, export, 415
Hive, 416
Hive and excel, 419
HiveQL, 416
import and export, 408
import data flow, 412
JavaScript, 420
ODBC Hive setup, 420
Pig, 423
role, 407
script in Hadoop, 422
Sqoop arguments, 411
Sqoop import, Azure, 413
Sqoop jobs, 410
SQL Server Integration Services, 259, 296
SQL Server Integration Services (SSIS), 252
SQL server management studio (SSMS), 340, 377
SQL Server Management Studio (SSMS), 207, 297
SQL Server Reporting Service, 296
SQL server reporting services (SSRS), 135, 153
SQL Server Reporting Services (SSRS)
mirroring, 154
ReportServerTempDB, 153
rpt, schema, 153
SQL server Vs. SQL database
backups and restores, 299
copy and restore operations, 300
operations, 299
business edition, 299
maximum size of databases, 299
portal functions, 297
security, 298
authentication, 298
features in SQL DBs, 298
firewall, 298
hashing, 298
mechanisms, 298
object-level, 298
SSL, 298
size of databases, 299
T-SQL support, 299
versions, 299
SQL 2008, 299
SQL server 2012, 299
web edition, 299
Windows Azure management portals, 297
SQL Trace, 101
architecture, 101
event notification, 110
catalog views, 111
service broker architecture, 111
extended event, 114
actions, 116
event life cycle, 118
event tracing for windows, 115
grouping, 118
health session, 121
histogram. See Histogram
.NET provider, 123
predicates, 115
types and maps, 116
user interface (UI). See User interface
file provider, 107
infrastructure, 101
rowset, 103
.NET SMO object model, 105
server profiler, 103
trace properties, 104
Storage
data utility, 144
file sizes, 144
free space information, 145
storage area network (SAN), 69, 431
Storage area network (SAN), 21, 335
Structure of table
data accessing, 21
relational database management system, 21
sys.fn_hadr_backup_is_preferred_replica, 383
T
Table Structure, database utility, 141
archive tables, 142
data tables, 141
health tables, 141
Tabular data stream protocol, 346
Tabular Data Stream (TDS), 294
Tasks
backups and restore
database recovery model, 268
database restores, 268
database integrity, 269
monitoring automation
drive spaces, 267
file limits, 267
space in disk, 267
SQL server agent log, 265
SQL server error log, 264
Windows Event Viewer, 264
scheduled datbase utility, 159
Tools, automation, 235
dynamic management views (DMVs), 237
memory configuration, 237
query, CPU time, 237
view sessions, 238
monitoring performance, 235
buffer manager, 236
data collector, 236
PowerShell, 262
automating, 263
launch, 263
using to check space, 263
SQL server agent, 238
alerts, 247
creating DBAInfo and monitoring, 240
DMV queries, 242
job activity monitor, 241
job properties, 241
job set up, 243
notifications, 246
operarors, 239
options, set up, 244
plans, 252
run set up, 242
scheduling job, 244
setting up schedule, 245
SQL server integration services (SSIS), 259
Troubleshooting, 304
dashboard, 306
query performance, 307
sys.dm_exec_query_stats, 306
view of query performance, 307
DMVs, 304
execution plans, 305
CPU cost, sort, 306
symbols, 305
T-SQL, 241
T-SQL scripts, 388
log backups, 391
SQL agents, 388
table creation, 390
T-SQL statements, 294
Tuning, 429
analyzing data, 446
application usage, 446
perfmon, 449
peak load
analysis services (AS), 434
applications, 435
assesment performance, 433
capturing data, 436
data configuration, 434
define, 429
IIS, 432
infrastructure, 434
integration services (IS), 434
project fillings, 432
project team, 430
reporting services (RS), 434
requirement analysis, 431
scenarios, 432
servers, 434
storage, 434
topology, 433
transactional volume, 431
planning devise, 462
sample plan, 462
technologies, 462
workloads, 462
spills, 68
Tuning spills, 68
U
User interface (UI)
event creation, 126
profiler UI, 130
session creation, 125
v
virtual IP (VIP), 446
Virtual log files (VLF), 457
Virtual log files (VLFs), 358
W
Waterfall method, 18
Windows Azure Management Portal, 297
Windows Azure SQL Database. See SQL Database
Windows Azure SQL Data Sync, 309
management portal, 309
member databases, 309
synchronization errors, 309
Windows Azure SQL Reporting, 308
management portal, 308
Windows failover clustering service (WFCS), 376
Windows Management Instrumentation Query Language (WQL), 249
Windows Management Instrumentation (WMI), 146
Windows Server Failover Cluster (WSFC), 282
Windows System Resource Manager (WSRM), 15
WMI event, 247
Y, Z
Yet Another Performance Profiling (YAPP) method, 1