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 |
|
Wrangler
Starting Member
35 Posts |
 Posted - 2011-10-30 : 15:57:08
|
| Lately when the DatabaseIntegrityCheck job runs it grows the tempdb datafile to 40GB. The job is from Ola Hallengren and my syntax is below. Anything I can look at or should be concerned with regarding the large growth of tempdb? sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d JobsDB -Q "EXECUTE [dbo].[DatabaseIntegrityCheck] @Databases = 'USER_DATABASES'" -bThank you,Wrangler |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-30 : 19:38:46
|
| CheckDB can use TempDB quite intensively.--Gail ShawSQL Server MVP |
 |
|
|
Wrangler
Starting Member
35 Posts |
Posted - 2011-10-30 : 20:56:08
|
| It seems so. I'll leave it alone for now and see what happens next Sunday when the jobs runs again. It should be fine if it stays at 40GB. Thanks,Wrangler |
|
|
|
|
|
|
40GB Tempdb data file