I inherited a SQL server and the performance is not the best. I noticed that the front end app that uses the database moves data between several tables when it starts each morning and then runs a shrink on the database. It looks like there is a weekly maintenance task that rebuilds indexes and then runs a shrink on the weekend as well!
When I looked at the indexes today, there are many that are heavily fragmented. Autogrowth is set to 1MB, unlimited. I know this setup has been in place for a year or so. The database is around 20GB. Large chunks of data are moved in and out of the database regularly.
If I stop the shrink operations and rebuild the indexes, will that fix my problem? Or is the database likely in a state where more drastic action is needed?