Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anbu_sql
Starting Member
4 Posts |
 Posted - 2007-08-28 : 04:23:17
|
| I just want to see the space used by a process or session against TempDB space. i.e. For example. TempDB space used is 50MB, I need to see the split of each process occupied the TempDB space like as follows SPID Used Space 1 10 MB 2 5 MB 3 25 MB 5 10 MB ....Is Sql server maintains any log report like this for TempDB space used by each Process or Session (SPID)?It is like viewing the TempDB usage by each process...Who is using more space?Please help me in this?Thanks in Advance!- Anbu |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 21:56:28
|
| Don't think so unless you know list of temp objects created by spid. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
|
|
|
|
|
How to find the space occupied by a process