What is QDS_ASYNC_QUEUE wait type ???

A week ago, one of my clients’ faced an issue with the SQL server performance going poor post migration from SQL 2012 to SQL 2016. On delving deeper found that QDS_ASYNC_QUEUE was the major wait type. The client did have the Query Store enabled on the subject databases and found the below information on research. As…

1

SQL Server Failover cluster instance upgrade failure issue from 2008 R2 to 2012

Today, one of my clients’ production environment was facing an issue with the failed upgrade of a SQL Failover Cluster Instance from SQL 2008 R2 to SQL 2012. They were trying the upgrade since a couple of days and it was failing with the below error TITLE: SQL Server 2008 R2 Setup —————————— The following…

0

SQL Server detected a DTC/KTM in-doubt transaction

Few days back, one of my clients’ faced an issue with their Availability group getting into the resolving state. On checking the logs found that the issue was due to a split brain scenario and as it was a business critical issue, we resolved the issue by restarting the SQL server services on the Secondary…

0

Upgrade of SSRS from SQL 2008 R2 to SQL 2012

Yesterday, I encountered a weird scenario where in the SSRS component was failing to upgrade from SQL 2008 R2 to SQL 2012 where in the SQL database engine and all the other components succeeded. SSRS component upgrade was failing with the below error : TITLE: Microsoft SQL Server 2012 Setup —————————— The following error has…

0

Sharing TDE Encrypted Backup outside the organisation.

In order to share the TDE Encrypted Database backup with somebody outside the organisation, the below steps can be followed. ++ Create new temporary database in order to prepare a make-shift copy of the intended database. RESTORE DATABASE MyEncryptedDB_Temp FROM DISK = N’C:\Temp\EncryptedDatabase.bak’ WITH MOVE EncryptedDatabase’ TO N’C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\EncryptedDatabase_Temp.mdf’, MOVE N’EncryptedDatabase_log’ TO N’C:\Program Files\Microsoft…

0

SQL failing to come online with SQLClusterResourceWorkerWaitForCompletion() failing

A few days back, I was working on an issue where in my client applied the patch KB3045318 on his SQL server instance running on SQL server 2012 SP1 build. As it was a 2 node – Failover Clustered Instance, he had applied the patch simultaneously on both the nodes and post which he has rebooted…

0

Tit Bits (2) on recent speculative execution side-channel vulnerabilities

Microsoft is constantly working to address the new publicly disclosed class of vulnerabilities referred to as “speculative execution side-channel attacks” that affect many modern OS and processors. Microsoft has developed the required patches both at the OS level and the SQL server level to help address this vulnerability which can be obtained in my previous blog : https://blogs.msdn.microsoft.com/shreyasgowda/2018/01/12/tit-bits-on-the-recent-speculative-execution-side-channel-vulnerabilities/…

0