SQL Database Error for ProGet

[priyanka.m_4184]

Hi,
We are using proget Version 6.0.18 (Build 2-proget6) and our Proget instance is down since the app pool is in a stopped state and it wont start, because of the errors we see in the event viewer

Could not allocate space for object 'dbo.PackageDownloads'.'IX__PackageDownloads__DownloadDate' in database 'ProGet2' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

Could you please suggest next steps on how to resolve this issue? We are considering upgrading to SQLServer Standard edition, however we want to know if there is anything else we can do temporarily until we can get that upgrade done.

Look forward to hear from you soon.

Kind Regards,
Priyanka

[stevedennis]

Hi @priyanka-m_4184 ,

It sounds like you have package statistics enabled; as you can see, this table gets really big over several years.

If you aren't using this data and don't care about it, then just run TRUNCATE PackageDownloads and disable the feature.

Another big table is often EventOccurences, but usually that's much smaller.

Here is query that will purge data from those tables before 2023:

DECLARE @DELETED INT = 1
WHILE (@DELETED > 0)
BEGIN
    BEGIN TRANSACTION
    
    -- PURGE OLD DATA
    DELETE TOP (10000) [PackageDownloads]
    WHERE [Download_Date] < '2023-01-01'
    SET @DELETED = @@ROWCOUNT
   
    -- PURGE OLD EVENTS
    DELETE TOP (10000) [EventOccurrences]
    WHERE [Occurrence_Date] < '2023-01-01'
    SET @DELETED = @DELETED + @@ROWCOUNT
    
    COMMIT
    CHECKPOINT 
END

Best,
steve

[priyanka.m_4184]

Thanks Steve,

That was helpful!

Regards,
Priyanka