適用於:SQL ServerAzure SQL 資料庫Azure SQL 受控執行個體 作業系統工作排程 執行緒是作業系統可以執行的最小處理單位,可讓應用程式邏輯分成數個同時執行路徑。 當複雜應用程式有許多可同時執行的工作時,執行緒就很實用。 作業系統執行應用程式的執行個體時,會建立一個稱為處理序的單位來管理這個執行個體。 處理序有...
SQL Server 数据库引擎可处理对多种数据存储体系结构(例如,本地表、已分区表以及分布在多个服务器上的表)执行的查询。 以下部分介绍了 SQL Server 如何处理查询并通过执行计划缓存来优化查询重用。执行模式SQL Server 数据库引擎可使用两种不同的处理模式处理 Transact-SQL 语句:...
分頁是SQL Server 中資料儲存的基本單位。 範圍是八個實體連續分頁的集合。 範圍可以協助系統有效地管理頁面。 本指南說明所有 SQL Server 版本中用於管理分頁與範圍的資料結構。 了解頁面與範圍的架構對於設計和開發有效執行的資料庫很重要。分頁與範圍SQL Server 中資料儲存的基本單位是分頁。 資料庫中配置給資料檔...
For more information about clustered indexes, see Create clustered indexes and the SQL Server index architecture and design guide.Nonclustered indexesStarting with SQL Server 2016 (13.x), in Azure SQL Database, and in Azure SQL Managed Instance, you can create a nonclustered index on a table ...
For more information, see the SQL Server and Azure SQL index architecture and design guide.If a table is in a transactional replication publication, you can't disable an index that is associated with a primary key constraint. These indexes are required by replication. To disable such an index...
For more information, see the SQL Server and Azure SQL index architecture and design guide.If a table is in a transactional replication publication, you can't disable an index that is associated with a primary key constraint. These indexes are required by replication. To disable such an index...
Transaction log logical architectureThe SQL Server transaction log operates logically as if the transaction log is a string of log records. Each log record is identified by a log sequence number (LSN). Each new log record is written to the logical end of the log with an LSN that is higher...
Transaction log logical architectureThe SQL Server transaction log operates logically as if the transaction log is a string of log records. Each log record is identified by a log sequence number (LSN). Each new log record is written to the logical end of the log with an LSN tha...
Client Architecture From an architectural standpoint, the SQL Server Relational Server component doesn't really concern itself with where a client is running. In fact, if you are running your application on the same box where SQL Server is running, it's the same client/server model, as far ...
SQL Server Azure SQL 数据库 Azure SQL 托管实例 Azure Synapse Analytics Analytics Platform System (PDW) Windows 虚拟内存管理器 提交的地址空间区域由 Windows 虚拟内存管理器 (VMM) 映射到可用的物理内存。 有关不同操作系统所支持的物理内存量的详细信息,请参阅介绍Windows 版本的内存限制的 Windows 文档。