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 |
|
hrishi_des
Yak Posting Veteran
76 Posts |
 Posted - 2007-01-17 : 05:11:14
|
| Hi,I am having problem with tempdb size, it grows and occupies whole disk. I have migrated from SQl server 2000 to SQL server 2005.Have anybody faced similar problem? and what could be the solution. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-17 : 05:55:26
|
| Which operations are causing this? Did you do any processing which heavily uses temporary tables?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2007-01-17 : 07:48:13
|
| Hi Harsh,We are using Microsoft reporting service,When we try to view report, the size of tempdb increases after few trials. yea one Stored procedure has some temp tables but the size of tempdb overshoots before that sp is executed.Thanks,Hrishikesh |
|
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-17 : 08:45:48
|
| u may be using session caching in report. u must minimise that. Madhu |
|
|
|
|
|
|
TempDB size