Recent Blog ArticlesNewest TopicsMost LikesTagged:TagTroubleshooting High Log Utilization Due to ACTIVE_TRANSACTION Uncover the reasons behind transaction log retention and learn strategies for resolving high log usage due to active transactions. Connections rejected by DoSGuard (error 18456 state 113) If there are multiple applications connecting to an Azure SQL Database from the same source IP and one of them is misconfigured and causing multiple connections failures due to wrong credentials, DoS...Performance degradation due to implicit conversion Implicit conversion is a common cause of performance degradation. It happens when a client/application runs a query in which a column is compared to a parameter with a data type that precedes the col...'Lock request time out period exceeded' when connecting to the database from SSMS When you connect to the database using SQL Server Management Studio (SSMS), It will perform several queries to gather the information necessary for the user interface. If one of the queries performed...Troubleshooting high lock wait time and lock time-out Locks are held in the database to ensure data consistency. If there are errors due to lock time-out or performance issues due to lock waits, the recommendation is to review the transactions that are ...Using partitioned tables or multiple tables to improve big deletes performance There are cases in which the time It takes to perform the delete operations are higher than what is acceptable, even if there are no resources constraint and the execution plan is good. In such a cas...Restore a DB encrypted with a TDE key into a server/instance having a different encryption key Steps on how to restore of a database encrypted with a Transparent Data Encryption (TDE) customer-managed key into a server/instance encrypted with a different key. This works for both Azure SQL DB a...Azure SQL Database Auditing not writing to Storage Account behind firewall Mitigation steps for when the Azure SQL Database Auditing is not writing to a Storage Account behind firewall.
MicrosoftMicrosoftMicrosoftMicrosoft
