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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-19 : 09:02:18
|
| Sundharesan writes "Gurus,I am facing a specific problem in my Production server.I have six application DBs in One SQL Server 7.0 [SP3].All the Application DBs have Autogrow enabled for Data and LOG File Autogrow is DISABLED [it is having static LOG file size].TEMPDB - AUtogrow 10% for both data and Log.My application does not fire any Nested Querries or Execute complex stored procedures at any time.In a span of 30 days the TEMPDB grows to 4GB [MDF file] not the LOG file. But SPACEUSED clearly gives that the space is Not Used by TEMPDB at all. IT is just occupuing the HDD Space. The Allocated space at any time is only 1MB to 5MB which is acceptable.UPon executed DBCC shrinkfile for tempdb the file is immdiately shrunk and the free spaces is freed to Operating system.Is there any specific reason for this ?Is my configuration wrong in SQL Config?I do not face this problem in similar servers in Test Environment at all..Please advise feel free to contact me through my email given above for any further inputs.RegardsSundharesan R" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-12-19 : 12:36:03
|
| How large are your application databases? DBCC commands like DBREINDEX and CHECKDB can use quite a bit of tempdb space, espically if they are run on multiple databases at the same time. If you are running these in prod and not test/dev then that could be one explanation.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
TEMPDb Grows beyond 4GB