Spatial queries performance improvements.Database cloning, which will copy the schema and metadata (without the actual data) for troubleshooting.Performance improvements when accessing XEL files in the XEvent Linq reader.Resource Governor query hints, which Microsoft said will provide increased granular control.Increased diagnostic tools in showplan XML.Consistency check performance improvements.Enhancements to dynamic management views (DMV), extended events, and query plans to provide additional monitoring capabilities.Improvements to change tracking and distribution agent cleanup were also made to avoid deadlock scenarios. Buffer pool usage has also been increased from the maximum 8TB to 128TB. On the scalability and performance front, Microsoft has added support for dynamic memory object scaling, which will partition memory objects on available nodes and cores to avoid bottlenecking.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |