SQL Server 2012 Service Pack 4 provides additional updates to improve performance, scalability, and monitoring. Key updates include:
Scalability and performance improvements for the storage engine
Improvements in consistency check performance
Query hints to provide granular control while using Resource Governor
Additional monitoring ...
Continue reading