SQL in Cloud

Diagnostic connections to SQL DB V12 Databases

SQL DB V12 supports diagnostic connections (DAC) to the SQL DB V12 databases similar to the SQL Standalone. Using this an admin can connect to the database to troubleshoot the issues when he can’t connect to the database (for example concurrent session limit reached).
Connection String:
Sqlcmd –S .database.windows.net,1434 –U -P -d DatabaseName
The port to connect is 1434. However it appears one can’t connect to the master database.
Usage:
If one offending session took a lock on an object where rest all the concurrent sessions waiting on that session to finish we end up in a situation where admin can’t connect to the database to recover it. This is when one can open DAC connection to the database and kill the offending session.

« Row versioning in SQL Database V12
SQL Azure Connection Strings »

Comments are closed.

Pages

  • Alter database in SQL V12
  • Changing MAX_DOP setting in SQL Azure DB V12
  • Connection Pooling and Isolation level reset
  • Contained users in SQL Azure DB V12
  • Full-text search in SQL Azure
  • Large Index Rebuild in SQL Azure V12
  • Row versioning in SQL Database version (V12)
  • Sql Azure db – database offline

Archives

  • May 2016
  • December 2015
  • July 2015
  • May 2015
  • April 2015

Categories

  • SQL Azure (8)
  • Uncategorized (3)

WordPress

  • Log in
  • WordPress

Subscribe

  • Entries (RSS)
  • Comments (RSS)
  • Alter database in SQL V12
  • Changing MAX_DOP setting in SQL Azure DB V12
  • Connection Pooling and Isolation level reset
  • Contained users in SQL Azure DB V12
  • Full-text search in SQL Azure
  • Large Index Rebuild in SQL Azure V12
  • Row versioning in SQL Database version (V12)
  • Sql Azure db – database offline