我的标签 排序: 自定义 | 博文数⬇ | 标签名

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