September 15, 2016 at 11:28 am
Hello I load from Pivot file which 89 mb and when created database it went significally high in 127 mb(estimated size) I checked in options of database, is that correct size of database? is that the only way to check size of database? why it is such high difference? Thank you
September 17, 2016 at 8:31 am
Krasavita (9/15/2016)
Hello I load from Pivot file which 89 mb and when created database it went significally high in 127 mb(estimated size) I checked in options of database, is that correct size of database? is that the only way to check size of database? why it is such high difference? Thank you
Are you wanting to check memory usage as the title of the post asks or physical size of the database?
The size increase is very small and the overall size is very small. Databases have structures (tables, columns, constraints, etc) the require some space. There is nothing there to be concerned about.
The size estimate is an estimate but it's close
You can use Performance Monitor to monitor SSAS memory usage. You can use DMX query to monitor usage by object:
SELECT * FROM $System.discover_object_memory_usage
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply