Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Highlighted
Community Manager

Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Available disk space is getting dangerously low towards the end of each month or runs out completely and reaches 0MB of free space before the end of each month causing data gaps in reports.

What can we do to avoid data gaps in reports and bring free disk space back to safe levels?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Re: Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Scenario:

Available disk space is getting dangerously low towards the end of each month or runs out completely and reaches 0MB of free space before the end of each month causing data gaps in reports.

 

Note that the Advanced Reporting ETL job is designed to automatically purge file groups that are older than the retention period. The ETL does this within the first few days of each month.

 

Question:

What can we do to avoid data gaps in reports and bring free disk space back to safe levels?

 

Answers:
1. The safest and supported way is to reduce the retention period by re-running the deployment script setup.bat pointing it the existing database, selecting 'U' option (Use existing database), then entering a smaller number of months of retention and then relying on the ETL to remove old file groups/partitions automatically at the first few days of the month. See this post for running the setup script to change retention:
https://community.ir.com/t5/Unified-Communications/In-Advanced-Reporting-can-I-change-how-many-month...

 

2. Alternatively (Requires SQL knowledge) move file group files to another drive (take the database off line, move files, alter database file filenames to the new path, bring database online).

* Make sure there is a complete full backup of the database before attempting this.

 

HTH

 

View solution in original post

2 REPLIES 2
Highlighted
Community Manager

Re: Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Scenario:

Available disk space is getting dangerously low towards the end of each month or runs out completely and reaches 0MB of free space before the end of each month causing data gaps in reports.

 

Note that the Advanced Reporting ETL job is designed to automatically purge file groups that are older than the retention period. The ETL does this within the first few days of each month.

 

Question:

What can we do to avoid data gaps in reports and bring free disk space back to safe levels?

 

Answers:
1. The safest and supported way is to reduce the retention period by re-running the deployment script setup.bat pointing it the existing database, selecting 'U' option (Use existing database), then entering a smaller number of months of retention and then relying on the ETL to remove old file groups/partitions automatically at the first few days of the month. See this post for running the setup script to change retention:
https://community.ir.com/t5/Unified-Communications/In-Advanced-Reporting-can-I-change-how-many-month...

 

2. Alternatively (Requires SQL knowledge) move file group files to another drive (take the database off line, move files, alter database file filenames to the new path, bring database online).

* Make sure there is a complete full backup of the database before attempting this.

 

HTH

 

View solution in original post

Highlighted
Community Manager

Re: Advanced Reporting BigDataInsightUC database free disk space running out or low on SQL server

Follow on Q&A:

 

Question:
Can the oldest file group within the retention be deleted before the end of the month?

 

Answer:

The short answer is No. There is currently no supported feature or procedure to do this. Attempts to remove a file group that is still within the retention period have failed and resulted in having to restore the whole databse from backup (and incur data gap from the time that the backup was taken).

 


Question:

How can this scenario be avoided pro-actively?

 

Answer:

This post provides a formula to help anticipate how much disk space is required.
https://community.ir.com/t5/Unified-Communications/disk-drive-sizing-for-Advanced-Reporting-BigDataI...

HTH

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar