Temdb大小增加。 [英] Temdb size is increased.

问题描述

Tempdb大小为130 GB。这个sql性能的Bcos非常慢。请帮我解决这个问题。





tempdev 112941.25 MB

templog 214.6875





请帮忙。



谢谢

Vinoth P

解决方案

越来越多的tempdb是对Sql服务器资源使用不当以及这些资源争用的偏好，从这里开始：



http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119436 [ ^ ]



如何缩小SQL Server中的tempdb数据库 [ ^ ]



优化tempdb效果 [ ^ ]

Hi ,

Tempdb size is 130 GB. Bcos of this sql performance is very very slow. Please help me how to resolve this issue.


tempdev 112941.25 MB
templog 214.6875


Please help.

Thanks
Vinoth P

解决方案

Growing tempdb is an indocation of poor use of Sql server resources and contention of those resources, start here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119436[^]

How to shrink the tempdb database in SQL Server[^]

Optimizing tempdb Performance[^]

这篇关于Temdb大小增加。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！