Description of SE_REPL Waits for Windows Azure SQL Database

Description of SE_REPL Waits for Windows Azure SQL Database Chris Skorlinski and John Sims Microsoft SQL Server Escalation Services If you’ve missed the announcement, we just published description of the Windows Azure SQL Database waits types including the SE_REPL waits. sys.dm_db_wait_stats http://msdn.microsoft.com/en-us/library/dn170450.aspx SE_REPL_CATCHUP_THROTTLE Occurs when the transaction is waiting for one of the database secondaries…

0

Tracking down Deadlocks in SQL Database

Tracking down Deadlocks in SQL Database Chris Skorlinski Microsoft SQL Server Escalation Services I want to share some tips for handling deadlocks in your SQL Database applications. You’ll see the solutions for SQL Database are similar to on-premises SQL Server for which you’ll well documented on web.  I’ll focus on parts unique to SQL Database….

2

Troubleshooting Blocking in SQL Database–the why

Chris Skorlinski Microsoft SQL Server Escalation Services In my last blog posting I explored SQL DMVs used to find who is blocking queries from running.  By Who, I mean other queries.  We calls these "head blockers".  Our goal is to get those head blockers finished as quickly as possible to release resources for other queries….

1

Troubleshooting Blocking in SQL Database - the who

Chris Skorlinski Microsoft SQL Server Escalation Services In this blog I’ll walk through troubleshooting blocking in SQL Database.  As you’ll see, we’ll many of the same techniques used for on-premises SQL Servers with one exception, will not have use of SQL Server Profiler to capture server activity.  While Profiler is often used, started with SQL…

0

Some of my favorite links

Chris Skorlinski SQL Server Escalation Services There is some great learning opportunities for Windows Azure SQL Database.  I decided to collect some of my favorites and includes them on my LINKS posting. Tools CSS SQL Azure Diagnostics tool released –Web Portal tool to display historical query performance stats from SQL Database Tools and Utilities Support…

0