When a system has reached capacity, research should be done
prior to requesting additional resources.
·
Determine historical growth and try to
determine offending source that is consuming the resource.
o
The DBA should be able to generate disk
consumption reports for the target volume.You will also want to get a report on the
growth of the individual database that space is being requested for.
Perform a shrink on the data and log
files if there is unused allocated space to the database.
If possible perform file system cleanup
(Old backups, data files, software installations, etc…)
Verify that unused and unallocated space
is at acceptable levels for all database objects.
o
This is to be provided by the DBA.
If the
volume contains transaction logs files, perform an audit on the Transaction Log
settings.
o Verify that Transaction Log backups are
being performed if the database is in Full Recovery Mode
o Can the log file be shrunk
o Autogrowth is configured to acceptable
growth level and restricted growth
o Log file is on a separate volume than
the data file
Once all cleanup efforts have been confirmed and the storage
is still needed, a new project has to be raised to allocate additional
storage.
No comments:
Post a Comment