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

14,519 reads

Blogs

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs

Forums

SQL Window Functions Series: LAG() and LEAD()

By Nikhil Bangad

Comments posted to this topic are about the item SQL Window Functions Series: LAG()...

Breaking Biometrics

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Breaking Biometrics

Attaching Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Attaching Databases

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers