March 18, 2015 at 7:47 am
Hi,
I setup data collection on a production server to capture growth rates.
When I run the dis usage report, it shows a daily growth rate of over 500 megs. This seems excessive to me.
As a troubleshooting step I then ran sp_space used and got these results:
database_namedatabase_sizeunallocated space
rgc_prod 273442.63 MB3648.48 MB
reserved data index_size unused
265345488 KB164385384 KB99826072 KB1134032 KB
What should my next steps be to try and determine why there is so much growth? And isn't the index size rather large?
March 18, 2015 at 8:49 am
It depends. Do you have a lot of clustered/non clustered indexes?
Take a look at your "data" column on a day-to-day basis, that will give you an idea of how much growth you've got occurring in your data file(s).
To help clear up any confusion on what these values mean, check BOL or go to http://sqlserverzest.com/2013/06/28/sql-server-understanding-sp_spaceused-results-for-database-size-information/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply