Skip to Content
Jul 03, 2018 at 05:54 PM

sybase sp_spaceused


Quick question experts. Newbie to SYB

We have enabled auto extend on DB however when I run sp_spaceused, I can see that PCT unreserved stands at 85.30 % which means there is quite a bit of space unreserved and is far away from database_size so we are ok for new objects.

Given auto extent is enabled, the unused space is quite low I...e PCT Free is only 4.72%. We have set auto extent thresholds and it shows in the cockpit all good but PCT free being low is worrying us. Does this mean even with auto extent enabled, we have to manually resize the data file. Is there a way I can check if auto extent is working. I want to get the PCT free percentage as high as possible. Thoughts