Database Reference
In-Depth Information
6. Examine the file sizes of the different files.
Note
Another way to examine how much memory a certain object takes up is
to use the schema
rowsets
available in Analysis Services. To query the
views, connect to the tabular instance using SQL Server Management
Studio and run the following query:
select OBJECT_PARENT_PATH, OBJECT_ID,
OBJECT_MEMORY_CHILD_NONSHRINKABLE
from
$system.DISCOVER_OBJECT_MEMORY_USAGE
where object_id = 'In-Memory Table'
order by
OBJECT_MEMORY_CHILD_NONSHRINKABLE desc
For information about the different Schema rowsets, refer to the online
There are two files called
dictionary files
that take up 4.5 MB and 1.1 MB respect-
ively. The names of the files indicate that they are storing the data from the
Employ-
eePhoto
column of the
DimEmployee
table and from the
SalesTerritoryImage
of the
DimSalesTerritory
table. These are columns that contain binary data with
Search WWH ::
Custom Search