Latest Builds of SQL Server v.Next - SentryOne Team Blog

Latest Builds of SQL Server v.Next

There is a Microsoft page that tracks new features and fixes in each CTP:

There is also a Linux version:

These documents list all of the minutiae, which is great! Gone are the days of secret CTPs and discovering new features on your own, though we have described before ways to compare CTPs to earlier versions, if you still want to do that:

You can download the latest CTP for Windows here, and Aaron described how to download the latest for Linux here.

CTP 1.3

CTP 1.3 came out Friday, February 17th. Latest @@VERSION:

Microsoft SQL Server vNext (CTP1.3) – 14.0.304.138 (X64)
  Feb 13 2017 16:49:12
  Copyright (C) 2016 Microsoft Corporation. All rights reserved.
  Developer Edition (64-bit) …

Some cool things here, including resumable index rebuilds, both cross-platform and cluster-less Availability Groups, retention policies for temporal tables, and a new dynamic management function for exposing statistics histograms.

CTP 1.2

CTP 1.2 came out Friday, January 20th. Latest @@VERSION:

Microsoft SQL Server vNext (CTP1.2) – 14.0.200.24 (X64)
  Jan 10 2017 19:15:28
  Copyright (C) 2016 Microsoft Corporation. All rights reserved.
  Developer Edition (64-bit) …

The only change I've discovered so far in this CTP is the addition of several performance counters relating to In-Memory OLTP (and these aren't mentioned in the docs above):

object_name counter_name
SQL Server vNext XTP Cursors Cursor deletes/sec
SQL Server vNext XTP Cursors Cursor inserts/sec
SQL Server vNext XTP Cursors Cursor scans started/sec
SQL Server vNext XTP Cursors Cursor unique violations/sec
SQL Server vNext XTP Cursors Cursor updates/sec
SQL Server vNext XTP Cursors Cursor write conflicts/sec
SQL Server vNext XTP Cursors Dusty corner scan retries/sec (user-issued)
SQL Server vNext XTP Cursors Expired rows removed/sec
SQL Server vNext XTP Cursors Expired rows touched/sec
SQL Server vNext XTP Cursors Rows returned/sec
SQL Server vNext XTP Cursors Rows touched/sec
SQL Server vNext XTP Cursors Tentatively-deleted rows touched/sec
SQL Server vNext XTP Garbage Collection Dusty corner scan retries/sec (GC-issued)
SQL Server vNext XTP Garbage Collection Main GC work items/sec
SQL Server vNext XTP Garbage Collection Parallel GC work item/sec
SQL Server vNext XTP Garbage Collection Rows processed/sec
SQL Server vNext XTP Garbage Collection Rows processed/sec (first in bucket and removed)
SQL Server vNext XTP Garbage Collection Rows processed/sec (first in bucket)
SQL Server vNext XTP Garbage Collection Rows processed/sec (marked for unlink)
SQL Server vNext XTP Garbage Collection Rows processed/sec (no sweep needed)
SQL Server vNext XTP Garbage Collection Sweep expired rows removed/sec
SQL Server vNext XTP Garbage Collection Sweep expired rows touched/sec
SQL Server vNext XTP Garbage Collection Sweep expiring rows touched/sec
SQL Server vNext XTP Garbage Collection Sweep rows touched/sec
SQL Server vNext XTP Garbage Collection Sweep scans started/sec
SQL Server vNext XTP IO Governor Insufficient Credits Waits/sec
SQL Server vNext XTP IO Governor Io Issued/sec
SQL Server vNext XTP IO Governor Log Blocks/sec
SQL Server vNext XTP IO Governor Missed Credit Slots
SQL Server vNext XTP IO Governor Stale Rate Object Waits/sec
SQL Server vNext XTP IO Governor Total Rate Objects Published
SQL Server vNext XTP Phantom Processor Dusty corner scan retries/sec (Phantom-issued)
SQL Server vNext XTP Phantom Processor Phantom expired rows removed/sec
SQL Server vNext XTP Phantom Processor Phantom expired rows touched/sec
SQL Server vNext XTP Phantom Processor Phantom expiring rows touched/sec
SQL Server vNext XTP Phantom Processor Phantom rows touched/sec
SQL Server vNext XTP Phantom Processor Phantom scans started/sec
SQL Server vNext XTP Storage Checkpoints Closed
SQL Server vNext XTP Storage Checkpoints Completed
SQL Server vNext XTP Storage Core Merges Completed
SQL Server vNext XTP Storage Merge Policy Evaluations
SQL Server vNext XTP Storage Merge Requests Outstanding
SQL Server vNext XTP Storage Merges Abandoned
SQL Server vNext XTP Storage Merges Installed
SQL Server vNext XTP Storage Total Files Merged
SQL Server vNext XTP Transaction Log Log bytes written/sec
SQL Server vNext XTP Transaction Log Log records written/sec
SQL Server vNext XTP Transactions Cascading aborts/sec
SQL Server vNext XTP Transactions Commit dependencies taken/sec
SQL Server vNext XTP Transactions Read-only transactions prepared/sec
SQL Server vNext XTP Transactions Save point refreshes/sec
SQL Server vNext XTP Transactions Save point rollbacks/sec
SQL Server vNext XTP Transactions Save points created/sec
SQL Server vNext XTP Transactions Transaction validation failures/sec
SQL Server vNext XTP Transactions Transactions aborted by user/sec
SQL Server vNext XTP Transactions Transactions aborted/sec
SQL Server vNext XTP Transactions Transactions created/sec
CTP 1.1
Microsoft SQL Server vNext (CTP1.1) – 14.0.100.187 (X64)
  Dec 10 2016 02:51:11
  Copyright (C) 2016 Microsoft Corporation. All rights reserved.
  Developer Edition (64-bit) …
CTP 1.0
Microsoft SQL Server vNext (CTP1) – 14.0.1.246 (X64)
  Nov 1 2016 23:24:39
  Copyright (c) Microsoft Corporation
  Developer Edition (64-bit) …

Comments ( 0 )

    Leave A Comment

    Your email address will not be published.