Avatar of Jim Youmans
Jim Youmans
Flag for United States of America

asked on 

TempDB won't shrink on SQL Server 2014

I was helping a friend with a TempDB problem.  He is running SQL Server 2014 on Azure VM and it is part of an always on group.  The problem is that TempDB grew to fill up the drive and when we tried to shrink it, nothing worked.  We did the DBCC FREESYSTEMCACHE('ALL')  and shrink. We did alter TempDB size.  We did everything we could think of and nothing worked.  We finally failed the database over to secondary server and stopped and restarted the SQL instance to reset TempDB on the primary server.  That worked.

Has anyone come across a problem like this and if so how did you handle it?

Microsoft SQL ServerAzure

Avatar of undefined
Last Comment

8/22/2022 - Mon