I have investigated a client's database today and the situation looks alarming. It has a size of 15,617 MB and space available of 4.59 MB with autogrowth of only 1 MB (obviously). I obtained this information by clicking on Properties in SSMS. This looks to me like the reason why they are having performance problems and yet there is 22,1 GB of free space available on that drive. Am I interpreting this information correctly
and if so how do you recommend that this problem be handled ?
Also they have a maintenance plan in which a 'Shrink database' task follows immediately after a 'Rebuild index' task. I am informed that this is bad practice as it will undo the good work done by the rebuild and cause more fragmentation. Please confirm.