Tempdb正在使用所有可用磁盘空间 [英] Tempdb is using all free disk space

问题描述

前几天我注意到我们的tempdb开始快速增长。我如何才能看到导致这种情况的原因？我们最近没有做任何事情。很快我们将耗尽磁盘空间。

Few days ago I noticed our tempdb is started to grow fast. How can I see what is causing this? We didn’t do anything recently. Soon we will run out of disk space.

推荐答案

很可能你有内存问题而你的SQL Server正在使用tempdb来存储数据，或者你经常运行DBCC CheckDB命令（将结果存储在tempdb中）

运行批量交易也可能导致此问题。



故障排除文章 - http://msdn.microsoft.com/en-us/library/ms176029.aspx [ ^ ]

Most likely you have memory issues and your SQL Server is using tempdb to store data or you are running DBCC CheckDB command often (stores results in tempdb)
Running bulk transactions also can cause this.

Troubleshooting article - http://msdn.microsoft.com/en-us/library/ms176029.aspx[^]

这篇关于Tempdb正在使用所有可用磁盘空间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！