July 24, 2019 at 9:41 am
How can we minimize the space utilization of tempdb when we ran the dbcc integrity/check db jobs ? we are geeting space issues every week when these jobs are running in weekends. if we choose sort in tempdb =off will it save the disk space where tempdb resides?
July 24, 2019 at 10:12 am
I suspect, you're speaking about two different things : dbcc jobs and maintenance (reindexing) jobs
which one affect your tempdb?
July 24, 2019 at 10:28 am
Sort in temp relates to index , i am looking for dbcc check db
July 24, 2019 at 12:41 pm
Sort in temp relates to index , i am looking for dbcc check db
then the following part of your message should be ignored, right?
"we are geeting space issues every week when these jobs are running in weekends. if we choose sort in tempdb =off will it save the disk space where tempdb resides?"
Regarding dbcc checkdb have a look here:
https://www.sqlskills.com/blogs/paul/checkdb-from-every-angle-why-would-checkdb-run-out-of-space/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply