阅读背景:

SQL Server:强制清除tempdb中已释放的内部对象,以释放在打开的会话中为其保留的磁盘空间

来源:互联网 

I have a large cursor bases query which runs within a stored procedure under a job. It makes tons of calculations for bunches of market data in a loop all day long. Every such iteration pools pieces of history time series from a disk, fatches it to temporary tables with appropriate indexing, joins them in a number of trunsformations with intermediate results and stores calculation output to disk. At the end of each loop I drop (mostly) or truncate all temporary tables to deallocate pages of user objects inside tempdb and get namespace ready for the next iteration. I have a large cursor bases query which runs wi




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: