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 |
|
cr8nk
Yak Posting Veteran
77 Posts |
 Posted - 2005-10-13 : 11:52:28
|
| Hello,I have a nightly ETL process calling hundreds of procs that swells my TempDB to over 15 GB in size. I have identified the longest running queries using profiler, but they don't seem to be the culprits. Does anyone know a way of tracking how much impact a query has on TempDB without executing each one at a time and checking the db size over and over?thanks,Creighton |
|
|
|
|
|
Identifying Queries that swell TempDB