I have a database that has a high volume of data being inserted and deleted each week.
Every week there are approximately one million rows of data being deleted and inserted. Each month the base table on which the data gets inserted grows by around a million rows.
I think this large number of transactions are causing the log file to grow larger and get fragmented.
I am afraid the performance may get worse each month.
What is the best way to maintain and manage such a database?
If anyone can explain or provide a link that deals with such a scenario that would be great.