| Lee Graber [MSFT] 2004-06-26, 10:51 am |
| Either:
1) YOu have a lot of work in your queue and did not turn on a processing
box to actually do the work (doubful)
2) You have a lot of work in a service window which is too small to
actually process the work (also doubtful)
3) You have a lot of suspended items because of some failures and have
never cleaned them up (possible)
All of the above can be ascertained by using our admin mmc and simply
looking at the queue sizes
4) You are doing a lot of BTF work and the expiration stamp on the btf
envelopes is in 5 years. (not too likely since we only stored a guid and a
date, but I guess it is possible)
5) You have created your database using full recovery mode (or simply
disabled the truncate on checkpoint flag) and it is not your data file
which is big, but your log file (most likely). In this case, check your log
file size in the taskpad view of your db in sql enterprise manager. If it
is big and you are not doing any backup of your data, you should switch to
simple recovery model, or else you should read up on doing log backups of
your db for failure recovery.
HTH
Lee
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
--------------------[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13
.phx.gbl[vbcol=seagreen]
|