Skip to content

storageengineused-element-xmla.md

Latest commit

 

History

History
93 lines (80 loc) · 3.05 KB

storageengineused-element-xmla.md

File metadata and controls

93 lines (80 loc) · 3.05 KB
title StorageEngineUsed Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/04/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
StorageEngineUsed Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
ms.assetid 98895c10-f3c2-4d8a-be94-6128c828561d
caps.latest.revision 9
author Minewiskan
ms.author owend
manager erikre

StorageEngineUsed Element (XMLA)

Contains a read-only value that describes the current database type.

Syntax

  
<Databases>  
      <Database>  
      <Name>...</Name>  
      <ID>...</ID>  
      <CreatedTimestamp>...</CreatedTimestamp>  
      <LastSchemaUpdate>...</LastSchemaUpdate>  
      <LastUpdate>...</LastUpdate>  
      <Description>...</Description>  
      <State>   </State>  
      <AggregationPrefix>...</AggregationPrefix>  
      <EstimatedSize>...</EstimatedSize>  
      <LastProcessed>...</LastProcessed>  
      <Language>...</Language>  
            <Collation>...</Collation>  
            <Visible>...</Visible>  
      <MasterDatasourceID>...</MasterDataSourceID>  
      <Accounts>...</Accounts>  
      <DataSources>...</DataSources>  
      <DataSourceViews>...</DataSourceViews>  
            <Dimensions>...</Dimensions>  
      <Cubes>...</Cubes>  
            <MiningStructures>...</MiningStructures>  
      <Roles>...</Roles>  
      <Assemblies>...</Assemblies>  
      <DatabasePermissions>...</DatabasePermissions>  
      <Translations>...</Translations>  
      <Annotations>...</Annotations>  
            <StorageEngineUsed >...</StorageEngineUsed>  
   </Database>  
</Databases>

Element Characteristics

Characteristic Description
Data type and length String (enumeration)
Default value None
Cardinality 1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element
Parent elements database
Child elements None

Remarks

The value of this element is limited to one of the strings listed in the following table.

Value Description
Traditional The database model corresponds to a MOLAP, ROLAP, or HOLAP storage mode.
InMemory The database model corresponds to an IMBI storage mode.
Mixed The database model mixes IMBI and MOLAP, ROLAP, or HOLAP storage modes.

The enumeration that corresponds to the allowed values for StorageEngineUsed in the Analysis Management Objects (AMO) object model is xref:Microsoft.AnalysisServices.StorageEngineUsed.

The elements that correspond to the parents of StorageEngineUsed in the Analysis Management Objects (AMO) object model are xref:Microsoft.AnalysisServices.Database.