Recent Blog ArticlesNewest TopicsMost LikesTagged:TagIntroducing optimized locking v2 Executive summary New improvements in optimized locking further reduce the overhead of locks in the MSSQL database engine. For many transactions, row and page locks aren’t taken at all while still ...Resource governor - a new beginning Executive summary In addition to increased CPU and memory limits, we are making another change to benefit customers using the SQL Server Standard edition. Starting with SQL Server 2025, resource ...SQL Server 2025: introducing tempdb space resource governance An old problem Since the early days of SQL Server, DBAs had to contend with a common problem – running out of space in the tempdb database. It has always struck me as odd that all I need to cau...SQL Server 2025: introducing optimized Halloween protection Executive summary Optimized Halloween protection, available in the public preview of SQL Server 2025 starting with the CTP 2.0 release, reduces tempdb space consumption and improves query performan...ABORT_QUERY_EXECUTION query hint - public preview We are pleased to announce the public preview of a new query hint, ABORT_QUERY_EXECUTION. The hint is intended to be used as a Query Store hint to let administrators block future execution of known p...Improving Azure SQL Database reliability with accelerated database recovery in tempdb We are pleased to announce that in Azure SQL Database, accelerated database recovery is now enabled in the tempdb database to bring instant transaction rollback and aggressive log truncation for tran...Announcing a limited public preview of the ABORT_QUERY_EXECUTION query hint We are pleased to announce a limited preview of a new query hint, ABORT_QUERY_EXECUTION. The hint is intended to be used as a Query Store hint to let administrators block future execution of known pr...Introducing database watcher for Azure SQL We are pleased to announce the public preview of database watcher for Azure SQL, a managed database monitoring solution to help our customers use Azure SQL reliably and efficiently. Improving Extended Events in Azure SQL In recent months, we have made several improvements to Extended Events in Azure SQL Database and Azure SQL Managed Instance. Read on to find out all the details. A new way to troubleshoot out-of-memory errors in the database engine We have added a new dynamic management view (DMV), sys.dm_os_out_of_memory_events. It is now available in Azure SQL Database and Azure SQL Managed Instance and will become available in a future versi...
MicrosoftMicrosoftMicrosoftMicrosoft
