SQL 2016 – It Just Runs Faster: XEvent Linq Reader
Moved from: bobsql.com SQL Server 2016 improves the XEvent Linq reader scalability and performance. The XEvent UI in SQL Server […]
Moved from: bobsql.com SQL Server 2016 improves the XEvent Linq reader scalability and performance. The XEvent UI in SQL Server […]
Moved from: bobsql.com SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc trans, etc.) Prior […]
Moved from: bobsql.com SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities. Prior to SQL […]
Moved from: bobsql.com The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to […]
Moved from: bobsql.com SQL Server 2016 introduces two distinct changes in the AlwaysOn transport, compression design. Improved […]
Moved from: bobsql.com The AlwaysOn log transport uses a SQL Broker based design to send and receive […]
Moved from: bobsql.com SQL Server 2016 enhanced the bulk insert activities (BULK INSERT), leveraging the CPUs vector […]
Moved from: bobsql.com SQL Server’s Column Store feature is designed to accommodate large amounts of data and […]
Moved from: bobsql.com SQL Server 2016 introduces multiple log writer workers to the engine. For many years the […]
Moved from: bobsql.com SQL Server uses WriteFileGather for the vast majority of data file write requests. The logic is to […]
Moved from: bobsql.com There are two(2) distinct checkpoint paths provided starting with SQL Server 2014, referred to […]
Moved from: bobsql.com The SOS_RWLock is a synchronization primitive used in various places throughout the SQL Server […]
Moved from: bobsql.com The CMemThread waits (PWAIT_MEMTHREAD) can be a point of contention as machine sizes advance. The CMemThread object […]
Moved from: bobsql.com As hardware continues to expand and evolve SQL Server testing and customer reports have […]
In the last post, I talked about how Richie and I sketched out the goals of PollGab.com, the […]