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-04-19 : 08:54:25
|
| Vladimir writes "Hi Team,Well we have a lot of problems with the tempdb log file is increase and increase, we try it to truncate and shrink but nothing, only help to restart the database SQL Server 2000!!!, but we are checking with dbcc opentran('tempdb') a we got this: SPID (server process ID) : 63 UID (user ID) : 1 Name : implicit_transaction LSN : (18:13912:31) Start time : Apr 16 2002 12:36:34:733PMDBCC execution completed. If DBCC printed error messages, contact your system administrator.for very long time!! it seems some transaction is not finish!!and then the tempdb is beginning to increase and increase!!, can you help us to fix the problem!!!" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-19 : 09:59:08
|
| You need to figure out what command is running on that spid, and see if you can optimize it. To get at the command, run DBCC INPUTBUFFER (63) ---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
|
|
|
tempdb log file transaction