Skip to Content

How to calculate how much tempdb reuired while performing update index stat on a larg table?

Hi all,

We have very big table table with the below mentioned size.

data - 89792920 KB

index_size - 29029144 KB

We are trying to run update index stat on this and our 13 GB tempdb is getting filled up and stats are failing.

Could some one please suggest how we can measure what should be the size of the tempdb we need to use?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers