MSSQL DB - Drive X 90% full - alerts

[csktwo1]

Hi All,

We have ECC on MSSQL DB and getting alerts on Drive X is 90% full. The Drive X has the MSSQL DB files (DATA1 , 2,3,4...)

Not sure what to check and how to retain more space . 

Can some please let me know what action can be performed so that we can retain more space in drive X ? How do we know that specific DB's / DATA file auto growth is full? Is it required to add a new DATA file as X drive has 110 GB left.

Regards,

Satish

[mamartins]

The official tool to manage a MSSQL Server instance is this one: https://learn.microsoft.com/en-us/ssms/download-sql-server-management-studio-ssms. Inside, you will find several Reports that will answer your questions.

Regarding the free space remaining on the disk, you have 2 options:

1. ARCHIVE/DELETE data and then perform a reorganization of the DB, and/or:
2. Extend the disk size

[csktwo1]

Hi mamartins, We received an alert about the sapdata3 file is 97% full. I see there is auto growth enabled with 10 MB and maximum file size is unlimited. Please let me know what action needs to be done so that the alert does not trigger