The server has 8GB total and 6.5GB for SQL Server. The average pages per second is 10 over the last 24 hours. Currently 1.6.

This is Visual Foxpro. ...

Lazy Writes are non existent. Max of 1.6 almost always 0.

I do allow autogrow but it's set to 1GB increments. After I moved it to C and...

There is antivirus but I verified that MDF and LDF and db* are excluded network wide.

Checkpoint pages are 370-410 / sec during the "peak" periods.

Disk Writes/Sec are about the same...

I was able to shrink the log file down to 1.5GB and moved it to C: Just to be clear C: is where I put tempDB and the LDF...

The LDF is 7 GB. The MDF is 350GB. Does that mean 7GB is the size it needs to be or is 7GB the biggest it has EVER...

Thanks for the clear explanation on the log files and the checkpoints. That makes a ton of sense.

Sorry, I thought I was clear about the disks. C: is...

There are no log files. It is set to simple recovery. The table has NO foreign keys, 6 indexes though. A 10 character primary key, and the...