开发者

SQL Session State - Why does tempdb size grow out of control? How to prevent this?

We'开发者_JAVA百科re currently using the tempdb to manage our SQL session state, but its size keeps growing out of control. Is there any way to manage or prevent this from happening?

We are thinking of setting up a custom database to manage SQL state instead of the tempdb, is this going to solve the problem?

Also, is there anything that we should be aware of when setting up and switching to a custom database?

Thanks.


Make sure that the SQL Server Agent is running. This is required to do clean up of the temp tables.

http://support.microsoft.com/kb/317604

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜