|
性能调优培训
(26)
|
Transaction Log
(1)
|
Multi Version Concurrency Control
(1)
|
Buffer Latches
(1)
|
|
索引
(25)
|
Transaction Isolation Levels
(1)
|
Missing Indexes
(1)
|
bm
(1)
|
|
SQL Server 2014
(22)
|
TOP 100 PERCENT
(1)
|
Missing Index Recommendations
(1)
|
blocking chain
(1)
|
|
统计信息
(16)
|
TOP
(1)
|
MEMORY_OPTIMIZED_DATA
(1)
|
Blocking
(1)
|
|
SQL Server代理
(12)
|
tid
(1)
|
max worker threads
(1)
|
blocked process threshold
(1)
|
|
SQL Server安全
(11)
|
THREADPOOL Waits
(1)
|
Max Server Memory
(1)
|
Blocked Process Report
(1)
|
|
SQL Server 2012
(11)
|
thread starvation
(1)
|
Max Degree of parallelism
(1)
|
BCM
(1)
|
|
页
(11)
|
Temp Table Caching
(1)
|
lt
(1)
|
BCD
(1)
|
|
索引深入浅出
(11)
|
TDE
(1)
|
login&amp
(1)
|
Backward Clustered Index Scan
(1)
|
|
非聚集索引
(11)
|
TAKE OWNERSHIP
(1)
|
Login
(1)
|
B-Link Tree
(1)
|
|
事务日志
(10)
|
Table Scan
(1)
|
Log Fragmentation
(1)
|
Auto Growth operations
(1)
|
|
page
(9)
|
system_health
(1)
|
Locking/Blocking/Latching
(1)
|
Authorization
(1)
|
|
Hekaton
(9)
|
System R
(1)
|
Locking/Blocking
(1)
|
Auditing
(1)
|
|
SQL Server 存储
(8)
|
sysadmin
(1)
|
Locking
(1)
|
Atomic CAS
(1)
|
|
数据库设计
(8)
|
sys.symmetric_keys
(1)
|
Lock/Latch Free Data Structures
(1)
|
atch_released
(1)
|
|
索引设计
(7)
|
sys.fn_dblog
(1)
|
Lock-Free Data Structures
(1)
|
Asynchronous Resource Waiting
(1)
|
|
SQL Server 2016
(6)
|
sys.dm_tran_lockssys.dm_tran_locks
(1)
|
Lock Priority
(1)
|
Asymmetric Lock
(1)
|
|
执行计划
(6)
|
sys.dm_tran_locks
(1)
|
lock
(1)
|
Asymmetric Key
(1)
|
|
理解统计信息
(6)
|
sys.dm_os_wait_stats
(1)
|
Least Recently Used Policy (LRU)
(1)
|
Ascending Key Column Values
(1)
|
|
聚集索引
(6)
|
sys.dm_os_memory_nodes
(1)
|
LCK_M_S
(1)
|
amp
(1)
|
|
UNIQUEIDENTIFIER
(5)
|
sys.dm_os_loaded_modules
(1)
|
latch_acquired
(1)
|
ALTER
(1)
|
|
Non Clustered Index
(5)
|
sys.dm_exec_query_stats
(1)
|
Latch Coupling
(1)
|
Aggregation
(1)
|
|
Lock Escalations
(5)
|
sys.dm_exec_query_plan
(1)
|
Latch Contention
(1)
|
ADO.NET
(1)
|
|
性能调优
(5)
|
sys.dm_exec_input_buffer
(1)
|
Latch
(1)
|
AddWithValue
(1)
|
|
计划缓存
(5)
|
sys.dm_db_xtp_hash_index_stats
(1)
|
KP
(1)
|
ACID
(1)
|
|
Read Committed Snapshot Isolation (RCSI)
(4)
|
sys.dm_db_index_physical_stats
(1)
|
Key-Range Locking
(1)
|
作业活动监视器
(1)
|
|
MAXDOP
(4)
|
Symmetric Key
(1)
|
Key Range Locks
(1)
|
作业步骤
(1)
|
|
heap table
(4)
|
Super Aggregates
(1)
|
Key Range Locking
(1)
|
作业安全
(1)
|
|
Clustered Index
(4)
|
Stream Aggregate
(1)
|
k
(1)
|
左联接
(1)
|
|
Cardinality Estimation
(4)
|
Statistics
(1)
|
IX
(1)
|
最小化日志
(1)
|
|
重编译
(4)
|
Static
(1)
|
Iterator-Model
(1)
|
阻塞会话
(1)
|
|
直方图
(4)
|
Stale Statistics
(1)
|
Iterator Model
(1)
|
子系统
(1)
|
|
密度向量
(4)
|
sqlservr.exe
(1)
|
Iterator
(1)
|
资源等待
(1)
|
|
查询
(4)
|
sqlmin.dll
(1)
|
ISO_11179
(1)
|
转发记录
(1)
|
|
Table Variables
(3)
|
sqllang.dll
(1)
|
IS
(1)
|
主体
(1)
|
|
sys.indexes
(3)
|
sqldk.dll
(1)
|
Intra-Parallelism Deadlock
(1)
|
预写式日志
(1)
|
|
Serializable
(3)
|
SqlDbType.VarChar
(1)
|
INTERSECT ALL
(1)
|
右联接
(1)
|
|
Repeatable Read
(3)
|
SQL代理外部程序
(1)
|
INTERSECT
(1)
|
意向锁
(1)
|
|
Phantom Records
(3)
|
SQL代理错误日志
(1)
|
INT IDENTITY
(1)
|
许可
(1)
|
|
Parameter Sniffing
(3)
|
SQL Server Profiler
(1)
|
INSERT
(1)
|
虚拟日志文件
(1)
|
|
Optimistic Concurrency
(3)
|
SQL 2016
(1)
|
INNER JOIN
(1)
|
性能监视器
(1)
|
|
Memory Optimized Tables
(3)
|
Spreading
(1)
|
index tuning
(1)
|
行偏移数组
(1)
|
|
Filtered Statistics
(3)
|
Spinlocks
(1)
|
Index Seek
(1)
|
行开销
(1)
|
|
唯一聚集索引
(3)
|
Spinlock Contention
(1)
|
Index Reorganize
(1)
|
行级别安全
(1)
|
|
唯一非聚集索引
(3)
|
Spinlock
(1)
|
Index Rebuild
(1)
|
维护计划作业
(1)
|
|
统计信息的创建和管理
(3)
|
sp_helo
(1)
|
Incremental Statistics
(1)
|
完整恢复模式
(1)
|
|
索引碎片
(3)
|
sp_configure
(1)
|
In-Memory Storage
(1)
|
完整备份
(1)
|
|
日志备份
(3)
|
Sort（Top N Sort）
(1)
|
Impersonation
(1)
|
透明数据加密
(1)
|
|
临界点
(3)
|
Snapshot Isolation
(1)
|
IMPERSONATE &amp
(1)
|
统一区
(1)
|
|
会话列表
(3)
|
SMOs
(1)
|
IAM
(1)
|
统计信息作用
(1)
|
|
非唯一非聚集索引
(3)
|
Simple Parameterization
(1)
|
I/O Latency Statistics
(1)
|
统计信息检测
(1)
|
|
参数嗅探
(3)
|
Shema
(1)
|
I/O Latches
(1)
|
索引维护
(1)
|
|
表变量
(3)
|
Shared Table Lock (S)
(1)
|
Hash-Indexes
(1)
|
碎片日志
(1)
|
|
XTP
(2)
|
Shared Lock (S)
(1)
|
Hash Warning
(1)
|
随机I/O
(1)
|
|
WinDbg
(2)
|
SH
(1)
|
Hash Partitioning
(1)
|
顺序I/O
(1)
|
|
Wait Statistics
(2)
|
setupadmin
(1)
|
Hash Index
(1)
|
闩锁耦合
(1)
|
|
VLF
(2)
|
SET STATISTICS TIME ON
(1)
|
Hash Collision
(1)
|
数据页
(1)
|
|
Tipping Point
(2)
|
Set Statistics IO
(1)
|
Hash Bucket Count
(1)
|
数据文件结构
(1)
|
|
TempDb
(2)
|
Service Master Key
(1)
|
gt
(1)
|
数据库邮件
(1)
|
|
sys.dm_io_virtual_file_stats
(2)
|
serveradmin
(1)
|
Grouping
(1)
|
数据库审核规范
(1)
|
|
sys.dm_exec_sql_text
(2)
|
sequential I/O
(1)
|
GROUP BY GROUPING SETS
(1)
|
数据库角色
(1)
|
|
SQL on Linux
(2)
|
SELECT *
(1)
|
Group
(1)
|
数据库恢复
(1)
|
|
Sort Warnings
(2)
|
SELECT
(1)
|
Gather Streams
(1)
|
数据加密
(1)
|
|
Snapshot Isolation (SI)
(2)
|
Segment Skipped
(1)
|
FPS
(1)
|
书签查找
(1)
|
|
Shared Locks (S)
(2)
|
Segment Read
(1)
|
Forwarding Records
(1)
|
视图
(1)
|
|
Shared lock
(2)
|
securityadmin
(1)
|
Forward Clustered Index Scan
(1)
|
事务隔离级别
(1)
|
|
SGAM
(2)
|
security label
(1)
|
FOREIGN KEY
(1)
|
实体关系图
(1)
|
|
Resource Governor
(2)
|
Search Argument
(1)
|
Forced Parameterization
(1)
|
审核
(1)
|
|
Read Uncommitted
(2)
|
SCHEMA_AND_DATA
(1)
|
fn_dump_dblog
(1)
|
上下文
(1)
|
|
Read Committed
(2)
|
Schema Stability Lock (Sch-S)
(1)
|
fn_dblog
(1)
|
筛选器
(1)
|
|
Range Indexes
(2)
|
Schema Modification Lock (Sch-M)
(1)
|
FILESTREAM
(1)
|
弱类型数据
(1)
|
|
Query Memory Spills
(2)
|
Safe Execution Plan
(1)
|
FETCH
(1)
|
软件工程
(1)
|
|
Query Memory Grant
(2)
|
ROWS
(1)
|
extent
(1)
|
日志文件
(1)
|
|
Quantum
(2)
|
Row-Level Security
(1)
|
exponential backoff mechanism
(1)
|
日志链
(1)
|
|
Primary Key
(2)
|
ROW_NUMBER()
(1)
|
Exponential Back-off algorithm
(1)
|
日志监控
(1)
|
|
ownership chain
(2)
|
Row Versioning
(1)
|
exit criteria
(1)
|
日志过度增长
(1)
|
|
Non-Buffer Latches
(2)
|
Row Version Pointer
(1)
|
EXECUTE AS
(1)
|
任务
(1)
|
|
NOLOCK
(2)
|
Row Version
(1)
|
exclusive table lock
(1)
|
区
(1)
|
|
Natively Compiled Stored Procedures
(2)
|
Row Offset Array
(1)
|
Exclusive Lock (X)
(1)
|
勤奋写入器
(1)
|
|
Memory Optimized Table
(2)
|
ROLLUP
(1)
|
Exclusive Lock
(1)
|
强制计划
(1)
|
|
Lock Hierarchy
(2)
|
Role
(1)
|
Exclusive Latch
(1)
|
耦合度
(1)
|
|
Last Page Insert Latch Contention
(2)
|
RML
(1)
|
EX
(1)
|
内聚度
(1)
|
|
IOPS
(2)
|
Reverse index
(1)
|
Ever Increasing
(1)
|
内存中OLTP
(1)
|
|
Intent Locks
(2)
|
Resource Wait
(1)
|
ERD
(1)
|
内存优化数据
(1)
|
|
Instant File Initialization
(2)
|
Repeatable Reads
(1)
|
Entity Attribute Value model (EAV)
(1)
|
内存优化表
(1)
|
|
In-Memory OLTP
(2)
|
REFERENCES
(1)
|
EncryptByKey
(1)
|
默认架构
(1)
|
|
Histogram
(2)
|
Recovery Time Objective
(1)
|
Empty Grouping Set
(1)
|
密匙管理
(1)
|
|
Grouping Sets
(2)
|
Recovery Models
(1)
|
DT
(1)
|
轮询调度分配算法、比例填充算法
(1)
|
|
GAM
(2)
|
RECOMPILE
(1)
|
Domains
(1)
|
列出最耗资源的会话
(1)
|
|
Extreme Transaction Processing
(2)
|
Read/Update Deadlock
(1)
|
DML
(1)
|
乐观并发控制
(1)
|
|
Exclusive Locks (X)
(2)
|
RANGE
(1)
|
DMF
(1)
|
跨数据库所有权链接
(1)
|
|
DMV
(2)
|
random I/O
(1)
|
diskadmin
(1)
|
客户端统计信息
(1)
|
|
Density Vector
(2)
|
QUERYTRACEON
(1)
|
Dirty Reads
(1)
|
警报
(1)
|
|
DELETE
(2)
|
Query Store
(1)
|
Dirty Read
(1)
|
截断日志
(1)
|
|
Deadlocking
(2)
|
Profiler
(1)
|
Delta Stores
(1)
|
加密数据
(1)
|
|
DBCC IND
(2)
|
processadmin
(1)
|
Delete Bitmaps
(1)
|
加密密匙
(1)
|
|
Cycle Deadlock
(2)
|
Privilege
(1)
|
Defaults
(1)
|
计算列
(1)
|
|
CXPACKET
(2)
|
Principal
(1)
|
Dedicated Admin Connection
(1)
|
计划重用
(1)
|
|
CREATE RESOURCE POOL
(2)
|
PowerShell
(1)
|
DecryptByKey
(1)
|
计划
(1)
|
|
cost threshold for parallelism
(2)
|
Power Set
(1)
|
DEALLOCATE
(1)
|
即席SQL语句
(1)
|
|
Correlated Columns
(2)
|
Plan-Quality Regressions
(1)
|
Deadlocks
(1)
|
即时文件初始化
(1)
|
|
Column Store Indexes
(2)
|
Plan Regression
(1)
|
Deadlock Monitor
(1)
|
活动日志
(1)
|
|
Bw-Tree
(2)
|
Plan Cache Pollution
(1)
|
Deadlock Graph
(1)
|
混合区
(1)
|
|
Buffer Pool Extensions
(2)
|
PIVOT
(1)
|
DDL
(1)
|
恢复模式
(1)
|
|
Authentication
(2)
|
Pessimistic Concurrency
(1)
|
DCM
(1)
|
缓冲池
(1)
|
|
作业
(2)
|
Permission
(1)
|
dbcreator
(1)
|
合并联接
(1)
|
|
游标
(2)
|
Perfmon
(1)
|
DBCC WRITEPAGE
(1)
|
哈希索引
(1)
|
|
文件组
(2)
|
Partial Range Scan
(1)
|
DBCC PAGE
(1)
|
过滤统计信息
(1)
|
|
尾日志备份
(2)
|
parameterized SQL statements
(1)
|
DBCC CHECKTABLE
(1)
|
故障恢复
(1)
|
|
所有权链接
(2)
|
parallelism-aware
(1)
|
DBCC CHECKDB
(1)
|
工作者
(1)
|
|
死锁
(2)
|
Parallel Execution Plans
(1)
|
Database Maintenance Plans
(1)
|
工作流
(1)
|
|
简单恢复模式
(2)
|
PAL
(1)
|
Data and Delta Files
(1)
|
覆盖非聚集索引
(1)
|
|
检查点
(2)
|
PAGELATCH_EX
(1)
|
CUBE
(1)
|
服务器审核规范
(1)
|
|
架构
(2)
|
Page Life Expectancy
(1)
|
Cross-Database Ownership Chaining
(1)
|
服务器角色
(1)
|
|
基数计算
(2)
|
OVER()
(1)
|
CREATE TABLE
(1)
|
多服务器管理
(1)
|
|
覆盖索引
(2)
|
ostress.exe
(1)
|
CREATE DOMAIN
(1)
|
动态管理视图和函数
(1)
|
|
非唯一聚集索引
(2)
|
ORDER BY NEWID()
(1)
|
CREATE
(1)
|
调度
(1)
|
|
堆表
(2)
|
ORDER BY
(1)
|
Crash Recovery
(1)
|
代码签名
(1)
|
|
存储过程
(2)
|
or IMPERSONATE &amp
(1)
|
Cost Factor
(1)
|
代理账号
(1)
|
|
触发器
(2)
|
Optimize for Adhoc Workload
(1)
|
Cooperative Scheduling Wait
(1)
|
大容量日志恢复模式
(1)
|
|
步骤
(2)
|
OPTIMIZE FOR
(1)
|
Cooperative Scheduling
(1)
|
存储过程主体
(1)
|
|
本机编译的存储过程
(2)
|
OPEN
(1)
|
CONTROL
(1)
|
差异备份
(1)
|
|
9002
(2)
|
Online Index Rebuild Version Store
(1)
|
Constraints
(1)
|
查询处理图解
(1)
|
|
zero-initialization
(1)
|
Online Index Rebuild operations
(1)
|
conrinfo.exe
(1)
|
操作员
(1)
|
|
WITH CHECK OPTION
(1)
|
Offline Checkpoint Worker
(1)
|
Compiled Plan Stub
(1)
|
并行执行计划
(1)
|
|
Windows Performance Monitor
(1)
|
NUMA
(1)
|
compare_and_swap
(1)
|
表连接
(1)
|
|
Windowing Functions
(1)
|
NULL columns
(1)
|
Common Version Store
(1)
|
变长列聚集索引
(1)
|
|
WAITFOR DELAY
(1)
|
NULL bitmap mask
(1)
|
Common Ownership
(1)
|
变长列非聚集索引
(1)
|
|
Wait Type
(1)
|
NOTRUNCATE
(1)
|
ColumnStore Segments
(1)
|
备份自动化和验证
(1)
|
|
VIEW DEFINITION
(1)
|
NOT NULL columns
(1)
|
ColumnStore Index Insert (Clustered)
(1)
|
悲观并发控制
(1)
|
|
Version Store
(1)
|
Non-Unique Non-Clustered Index
(1)
|
CMPXCHG
(1)
|
安全对象
(1)
|
|
Vehicle Identification Number
(1)
|
Non-Unique Clustered Indexes
(1)
|
Clustered Key value
(1)
|
9481
(1)
|
|
user&amp
(1)
|
Non-Repeatable Read
(1)
|
Clustered Index Scan
(1)
|
610
(1)
|
|
User
(1)
|
Non-Clustered Indexes
(1)
|
Clustered Hash Index
(1)
|
2389
(1)
|
|
Update（U）Lock
(1)
|
Non-Clustered Hash Index
(1)
|
CLOSE
(1)
|
2388
(1)
|
|
Update Conflicts
(1)
|
Non-Blocking Algorithm
(1)
|
CheckPoint
(1)
|
2312
(1)
|
|
UPDATE
(1)
|
No-SQL
(1)
|
CHECK()
(1)
|
1222
(1)
|
|
UP
(1)
|
NC scan
(1)
|
CHECK_POLICY
(1)
|
1118
(1)
|
|
UNLOCK
(1)
|
Native Compilation
(1)
|
CHECK_EXPIRATION
(1)
|
1117
(1)
|
|
UNIQUE
(1)
|
Narrow
(1)
|
Cascading Deletes
(1)
|
1：n
(1)
|
|
Tuple Mover
(1)
|
n:n
(1)
|
busy wait
(1)
|
1：1
(1)
|
|
TRUNCATEONLY
(1)
|
Mutexes
(1)
|
bulkadmin
(1)
|
%%lockres%%
(1)
|
|
Transparent Data Encryption
(1)
|
MUST_CHANGE
(1)
|
Buffer Pool
(1)
|
