Rapid growth of Tempdb on AlwaysOn secondary replica due to version store

Hello all,   Recently I had worked on an interesting issue with rapid growth of Tempdb on AlwaysOn secondary replica. In this article, we will cover the approach and the queries used to isolate the growth issue and the workaround/fix used to control the growth of Tempdb on secondary replica.   The following types of…

5

SQL Performance troubleshooting guide: A walk through

Hi all, , This article gives a high level view of isolating SQL Performance issues and logical approach to troubleshoot them.   SQL Server performance issues can be broadly categorized as: Overall Server slowness Specific query slowness   If SQL Server overall performance is slow, then we can categorize the issues as below: If SQL Server…

3