Index

Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

Previous Chapter

Appendix D: In-Memory OLTP Migration Tools

Index

A

Administration and monitoring tasks

execution statistics

in-memory OLTP transactions

memory-optimized tables

Resource Governor

classification process

internal and default resource pools

recovery process

Autocommitted transactions

B

C

Checkpoint file pairs (CFPs)

ACTIVE checkpoint file

database creation

dbo.HKData table

forcing CHECKPOINT

in TOMBSTONE state

log backup and garbage collection

memory-optimized table

sys.db_dm_xtp_checkpoint_files view

UNDER CONSTRUCTION

Commit dependency

Cross-container transactions

autocommitted transactions

incompatible transaction isolation levels

SNAPSHOT isolation

transaction levels

D, E, F

Data-loading process

ACTIVE CFP state

CHECKPOINT process

INSERT and DELETE

IN TRANSITION TO TOMBSTONE state

MERGED SOURCE CFP state

MERGE TARGET state

PRECREATED CFP state

REQUIRED FOR BACKUP/HA state

TOMBSTONE state

UNDER CONSTRUCTION CFP state

Deployment and management

administration and monitoring tasks

hardware components

I/O performance

Dusty corners scan

G

Garbage collection process

BeginTs and EndTs timestamps

cooperative and scalable

data management views

DELETE operation

dusty corners scan

idle worker thread

idxLinkCount element

memory-optimized table

memory statistics

idle worker thread cycle

SELECT operation

summary statistics

UPDATE operation

GetRow() method

H

hash table lookup

sys.dm_db_xtp_hash_index_stats

index seek operation

test tables creation

Hash indexes vs. nonclustered indexes

point lookup performance

tables creation

I, J, K

Idle worker thread

8,060-byte maximum row size limit

case-insensitive collections

INSTEAD OF triggers

Picture and Description columns

SplitData function

unique and foreign key constraints

cost/benefits analysis

data management views

checkpoint operations

garbage collection

memory usage statistics

object and index statistics

transaction management

engine architecture

Enterprise Edition feature

extended events

importing batch of rows

memory-optimized table type

Table, TVP and stored procedures

Management Data Warehouse

memory-optimized tables

ETL performance

nonclustered indexes

query parallelism

scan performance

stored procedures, execution time

UPDATE performance

with on-disk temporary objects

mixed workloads

performance counters

performance improvements

session/object state-store

dedicated storage/cache

ObjStoreDataAccess class

ObjStoreService class

ObjStoreUtils class

replicate content

scalability issues

Session Store implementation

SQL Server 2014 Management Studio

In-Memory OLTP objects

database creation

latches (see Latches)

memory-optimized tables

durability setting

natively complied stored procedure

nonclustered indexes

performance counters

T-SQL stored procedure

wait statistics

InterlockedCompareExchange mechanism

L

performance counters

transaction log

wait statistics

M

Management Data Warehouse

data collection sets

Memory Optimization and Native Compilation Advisors

menu configuration

procedure-Level statistics

security configuration

server and database

success confirmation

Table Contention Analysis report

Table-Level statistics

Transaction Performance Analysis Overview report

Usage Analysis report

Memory-optimized tables

availability groups

BeginTs timestamp

halloween effect

EndTs timestamp

native complication

vs. on-disk tables

clustered index

nonclustered index

data distribution

DBCC SHOW_STATISTICS statement

execution plans

nested loop join algorithm

supported data types

Memory pointers management

data modifications and concurrency

InterlockedCompareExchange function

Merge Policy Evaluator

Mixed abstract tree (MAT)

N

Native compilation

interop mode performance comparison

delete operations

select operations

test tables creation

update operations

stored procedure (see T-SQL stored procedure)

date/time functions

error functions

NEWSEQUENTIALID

query surface area

string functions

Nonclustered indexes

Bw-Tree indexes

index scan operations

index seek operations

execution plans

index key column

on-disk table creation

sys.dm_db_xtp_index_stats view

O

Optimistic concurrency

P, Q

Pareto principle

Pessimistic concurrency

Phantom Read phenomenon

Pure imperative tree (PIT)

R, S

T, U, V

Transaction isolation levels

concurrency phenomena

memory-optimized table

Phantom Read phenomenon

REPEATABLE READ

Non-Repeatable Reads

optimistic concurrency

pessimistic concurrency

REPEATABLE READ

Transaction logging

in-memory OLTP transaction

on-disk table modification

Transaction processing

data modification operations

insert operation

memory-optimized tables

validation phase

T-SQL stored procedure

object creation

write/write conflict

query optimizer

W, X, Y, Z

Write-ahead logging (WAL)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

3.12.166.255