Thursday, February 18, 2010

SQL Azure get its first update - SU1

The first service update for SQL Azure - SU1 was introduced on February 17th, 2009.

Things that are new:

* Bug fixes to the original

* Ability to between editions Web[1GB] and Business[10GB] (downgrade or upgrade)

* Better algoritm to terminate Long running transactions

* Idle connection timeout increased to 30 mts.

* Monitoring with Dynamic Management the following Views which improves monitoring, tuning and performance

sys.dm_exec_connections
sys.dm_exec_requests
sys.dm_exec_sessions
sys.dm_tran_database_transactions
sys.dm_tran_active_transactions
sys.dm_db_partition_stats

Read full story here.

No comments:

DMCA.com Protection Status