March 25, 2003 at 3:11 am
I have an SQL2k sp2 who is growing by appx. 200m a day. Anybody who knows what and where to look
March 25, 2003 at 3:26 am
Are you inserting a lot of data into it? Are there a lot of transactions going on, and do you backup your log? Are you running Profiler (or just server-side traces) and storing the results in tables in your database?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 4:12 am
It is an regular OLTP database with 10 users. Their amount of data from 97 until today is 2GB on an OracleDB, but after moving them to SQL it started to grow. I'm not backing up the log. How to check if tracing is turned on???
March 25, 2003 at 4:45 am
If you don't know if tracing is on or not, I'd guess it's not. 🙂
However, if your transaction log is set to grow automatically (and I guess it is, otherwise you would have seen an error probably) it will continue to grow until it is truncated and thereby can reuse old space. Backing up the log frequently will keep it small. I don't know if this is the reason for your 200 MB growth a day (sounds like a lot), but if you have a lot of activity it could be. Have you checked the size of the log? Is it just the log that is growing or are the data files growing as well?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply