Mid
of February Microsoft announced the release of SQL Server vNext CTP 1.3. Below
is the list of some of the key enhancements done on database engine
- Indirect checkpoint performance improvements.
- Cluster-less Availability Groups support added.
- Minimum Replica Commit Availability Groups setting added.
- Availability Groups can now work across Windows-Linux to enable cross-OS migrations and testing.
- Temporal Tables Retention Policy support added,
- Online non-clustered columnstore index built and rebuild support added
One thing which surprised me is by default you get a set
of trace flags enabled globally. SQL Server vNext CTP 1.3 we have 7 trace flags enabled by default whereas in CTP 1.2 we'll get 6.
 |
| Click on the image for better readability |
Have you used the below listed trace flags?
Can you
share your thoughts on the comments section about these traces flags?
T835
T2563
T3105
T5504
T6529
T8020
T8415
In the next blog post we will see how to set trace flag on SQL startup parameter on Linux.
Cheers,
Naveen
Trace Flag 8020 - SQL Server uses the size of the working set when SQL Server interprets the global memory state signals from the operating system.
ReplyDeleteI really liked your Information. Keep up the good work. AZ-220: Microsoft Azure IoT Developer
ReplyDelete