Sites Microsoft


Released: Microsoft.Data.SqlClient 5.0 Preview 1

Publié le 11 mars 2022 sur MS Tech Community
 

Microsoft.Data.SqlClient 5.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two or three preview releases in …

Windows のバージョンアップにより SQL Server 関連のパフォーマンスカウンターが表示されなくなる現象について

Publié le 8 mars 2022 sur SQL Server Support Blog
 

こんにちは、 SQL Server サポートチームです。   今回は SQL Server 関連のパフォーマ …

Capture a Call Stack Without Generating A Dump

Publié le 3 mars 2022 sur MS Tech Community
 

Warning (Beta): The RVA feature set is in rollout and subject to change and limitations.   XEvent and other outputs (errorlog, sqldump*.txt, …) contain call stack outputs.  Some of these outputs are easy to symbolize while others are more d …

SQL 2016 – It Just Runs Faster: XEvent Linq Reader

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server 2016 improves the XEvent Linq reader scalability and performance.    The XEvent UI in SQL Server Management Studio uses the XEvent Linq reader to process the events for display. …

SQL 2016 – Leverages On Demand MSDTC Startup

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc trans, etc.)   Prior to SQL Server 2016 the MSDTC service must be running (started) prior to any SQL Server …

SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities.  Prior to SQL Server 2016, increasing the size of the pool required you to enable a startup trace flag.   SQL Server 2016 …

SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to significantly improve scale and performance.   SQL Server 2016 development efforts continued focusing on the AlwaysOn log sh …

SQL 2016 – It Just Runs Faster: AlwaysOn Parallel Compression / Improved Algorithms

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compression design.  Improved compression algorithms Parallel compression of log block data  Compression can be performed faster, using l …

SQL 2016 – It Just Runs Faster: AlwaysOn Log Transport Reduced Context Switches

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   The AlwaysOn log transport uses a SQL Broker based design to send and receive messages between the primary and secondary replicas.    Studying the transport behavior revealed various improvement opportu …

SQL 2016 – It Just Runs Faster – BULK INSERT Uses Vector Instructions (SSE/AVX)

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector instructions.   The vector based approach allows the bulk data to be processed faster.   For example, when i …

SQL 2016 – It Just Runs Faster: Column Store Uses Vector Instructions (SSE/AVX)

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server’s Column Store feature is designed to accommodate large amounts of data and associated compression capabilities.  Microsoft studied numerous data layouts associated with column store and the CPU …

SQL 2016 – It Just Runs Faster: Multiple Log Writer Workers

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server 2016 introduces multiple log writer workers to the engine.    For many years the log device was limited by the capabilities of spinning media and hardware caches.    The a …

SQL 2016 – It Just Runs Faster: Larger Data File Writes

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   SQL Server uses WriteFileGather for the vast majority of data file write requests.   The logic is to consolidate dirty pages into a single I/O request.   For example page 1:13 and 1:12 are dir …

SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   There are two(2) distinct checkpoint paths provided starting with SQL Server 2014, referred to as Automatic and Indirect.   The vast majority of documentation today highlights the behavior of automatic (classic) …

SQL 2016 – It Just Runs Faster: SOS_RWLock Redesign

Publié le 1 mars 2022 sur MS Tech Community
 

Moved from: bobsql.com   The SOS_RWLock is a synchronization primitive used in various places throughout the SQL Server code base.  As the name implies the code can have multiple shared (readers) or single (writer) ownership.  …


Pages :