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

AdventureWorks for SQL Database

Chris Skorlinski SQL Server Escalation Services I’ll be posting SQL Database (Windows Azure SQL Database) performance troubleshooting tips over the next few weeks.  For most of these examples I’ll use the AdeventureWorks2012 sample database available for free download on CodePlex. AdventureWorks Community Samples Databases for Azure SQL Database http://msftdbprodsamples.codeplex.com/releases/view/37304 Once you download, execute from a…

0

SQL Database WAIT STATS

–SQL Database WAIT STATS–New for SQL Database (Windows Azure SQL Database) are database level WAIT STATS.  These are executed against the application database, not the MASTER database.–Retrieve cached performance WAIT stats by database–dm_db_wait_stats   SELECT * FROM sys.dm_db_wait_statsORDER BY wait_time_ms desc    wait_type                                     waiting_tasks_count  wait_time_ms         max_wait_time_ms     signal_wait_time_ms——————————————— ——————– ——————– ——————– ——————–LCK_M_U                                       7                    640004               225320               0ASYNC_NETWORK_IO             …

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