sqlserver20xxscalabilityenhancements-全文預(yù)覽
【正文】 tools and features for building and managing applications Diagnostic tool to aid in various debugging scenarios ? Command line ssbdiagnose External activation ? Not all postprocessing can be run in SQL Server (. too intensive, security concerns, existing code) ? NT Service listens for notifications to launch and monitor processes Mar2022 23 Microsoft Developer amp。 Platform Evangelism Data Compression: Example Syntax For Partitions Create a partitioned index with different pression settings on various partitions (unspecified partitions will use NONE) ? CREATE CLUSTERED INDEX ClustIDX ON MyTable (Col1) ? WITH (DATA_COMPRESSION = ROW ON PARTITIONS (1), ? DATA_COMPRESSION = PAGE ON PARTITIONS (2 TO 4 ) ) Modify a single partition’s pression setting, with only that partition being rebuilt ? ALTER INDEX ClustIDX ON MyTable ? REBUILD PARTITION = 1 WITH (DATA_COMPRESSION = NONE) Modify one or more partitions, with all partitions being rebuilt (unspecified partitions retain their current pression setting) ? ALTER INDEX ClustIDX ON MyTable ? REBUILD WITH (DATA_COMPRESSION = NONE ON PARTITIONS (1)) Mar2022 16 Microsoft Developer amp。 Platform Evangelism PAGE Compression: Prefix Compression For each column, a value is chosen that allows space reduction and stored in a pression information structure (CI) The inrow values are replaced with indicators of full or partial matches with the value in the CI Note that the largest value for each column is stored in the CI The process uses bytelevel parisons across all data types Mar2022 11 Microsoft Developer amp。 Platform Evangelism DEMO Estimating Space Savings Mar2022 7 Microsoft Developer amp。 Platform Evangelism Module Overview Data Compression (Enterprise Edition) Service Broker Enhancements Query Optimizer Enhancements Partitioning Enhancements (Enterprise Edition) Mar2022 3 Microsoft Developer amp。 2022 Microsoft Corporation. All rights reserved. Microsoft, SQL Server, Office System, Visual Studio, SharePoint Server, Office PerformancePoint Server, .NET Framework, ProClarity Desktop Professional are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual panies and products mentioned herein may be the trademarks of their respective owners. Mar2022 2 Microsoft Developer amp。 Platform Evangelism Data Compression: What Can Be Compressed? A whole heap A whole clustered index A whole nonclustered index A whole indexed view Single partitions of partitioned tables and indexes ? Different partitions can have different pression settings System tables cannot be pressed How do you choose what/when to press? Mar2022 6 Microsoft Developer amp。 Platform Evangelism Data Compression: PAGE Compression Page pression does three things: ? ROW pression ? Column value prefix pression ? Column value dictionary pression When pressing a page, these three operations are done in the order listed above Details of page pression can be found in Books Online ??Page Compression Implementation? in BOL index Mar2022 10 Microsoft Developer amp。 Platform Evangelism Data Compression: Enabling and Disabling Compression can be enabled by specifying pression ROW or PAGE through: ? CREATE TABLE or CREATE INDEX ?ALTER TABLE … REBUILD (new syntax) ?ALTER INDEX … REBUILD ? Data Compression Wizard in SSMS Compression can be disabled by specifying pression NONE through: ?ALTER TABLE … REBUILD ?ALTER INDEX … REBUILD ? Data Compression Wizard in SSMS Both can be done ON
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1