SharePoint Health Analyzer rule detected the unused free space in WSS_Content Database
, so to free up the space I had to shrink the Database.
Before shrinking, the size of content DB was 259 GB. After Shrinking its reduce to 199 GB.
It was stable for 2 days but after that Content DB suddenly started to increase in size and ended up on 272 GB.
According to SQL Report of Disk space used by Table it showing near about 200 GB data. So what causes allocation of extra space and is there any way to regain the space?
Should I shrink it again (I know shrinking is not recommended by Microsoft) because SharePoint Health Analyzer again shows that the Content DB having unused space?
Please suggest useful solution for the problem above.
1.
What's the name of the table in your Content DB with the large growth per your SQL Report? When you shrink the data file, you cause database level fragmentation so you should also reindex when you do this. It's not going to help much if the transactions cause it to grow again so you'll need to capture what's causing it to grow transaction wise at the SQL Server level to see what's causing this.2.
What version of SQL Server are you running? Are you a sysadmin on the SQL Server instance with the Content DB or do you have a DBA that needs to assist with this level of troubleshooting? – Facebook Jan 3 '16 at 7:01