Skip to Content

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

Apr 03, 2017 at 10:27 AM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers