SIMS LDF growing even though it's in SIMPLE mode?
Is there any reason the SIMS log file would grow even though the database is in simple recovery mode? We have a site where SQL is sucking up almost all of the 16Gb of memory on the server, and it also seems to be causing intermittent CPU spikes. I looked at it last week and the SIMS LDF file was over 1Gb so I freed up the space in the lolg file and it was back at a nice 1Mb. Performance seemed to improve again, but I'm checking it a week later and again, it's sucked up almost all the memory and the LDF file has grown to almost 3Gb and again, it's still in simple recovery mode! The CPU spikes look like they are back as well, and it's got me baffled! I know SQL has a tendency to grab as much memory as it needs but this server is a beast and I can't imagine that it's used so heavily that it needs all of the 16Gb!