Recently we have build one of the job with tempdb usage in the form of allocation and de-allocation of internal and external objects space. But the result set is providing the Data File usage and not able to get LDF file usage. When the tempdb is 85% the data file occupied only 30% but the LDF file occupies all the space. But we are unable to shrink the space because when we checked the dbcc opentran() on tempdb we have seen few transactions then once we killed them can able to shrink the tempdb, UNFORTUNATELY the opentrans are in SLEEPING STATE. So my questions are below. -> We need to know what are all the sleeping status transactions are occupied that much of LDF file space and why that space not released after their execution. -> When ever we seen the opentrans got the below command FETCH CURSOR 0010101010. What it means? We need script for finding the above secnarios because of LDF file filled up frequently but unable to find which sleeping transaction occupies that much of LDF file space.