always on

SQLServerCentral Article

TempDB growth due to version store on AlwaysOn secondary server

  • Article

On a not-so-busy day, I received an alert saying tempdb has grown to 90 percent of the drive size and there is only 10 percent space left on the drive. The server is a SQL Server 2014 instance and hosts AlwaysOn secondary databases.

4.84 (19)

You rated this post out of 5. Change rating

2016-11-07

17,576 reads

Blogs

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

2024 PASS Data Community Summit Prep

By

Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...

A New Word: Bye-over

By

bye-over – n.  the sheepish casual vibe between two people who’ve shred an emotional...

Read the latest Blogs

Forums

SQL 2022 - CPU High Utilization

By haichells

Dear All, We have been facing this issue from last 3 months and unable...

Cloud Sources for the Data Migration Assistant

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Sources for the Data...

Your Personal ChatGPT Tutorial

By Kumar Abhishek

Comments posted to this topic are about the item Your Personal ChatGPT Tutorial

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers