Microsoft today announced that the final service pack for SQL Server 2012 is now available for download.
The latest official release for the half-decade-old version of Microsoft's database management system includes a rollup of all hotfixes released over the years and focuses on scalability and performance improvements, especially on newer hardware.
The final service pack also includes:
- Enhancements to dynamic management views (DMV), extended events, and query plans to provide additional monitoring capabilities.
- Consistency check performance improvements.
- Increased diagnostic tools in showplan XML.
- Resource Governor query hints, which Microsoft said will provide increased granular control.
- Performance improvements when accessing XEL files in the XEvent Linq reader.
- Database cloning, which will copy the schema and metadata (without the actual data) for troubleshooting.
- Spatial queries performance improvements.