View opm.storage_service_level_view Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigint 19 0
uuid varchar 512
name varchar 255  √  null
description text 65535  √  null Performance policy used to ensure workload performance.
peakIopsPerTB bigint 19 Specifies the maximum possible IOPS per TB allocated based on the storage object used size.
expectedIopsPerTB bigint 19 Specifies the minimum expected IOPS allocated based on the storage object allocated size.
absoluteMinIops bigint 19 100 Indicates the minimum IOPS value for a performance policy.
expectedLatency float 12  √  null
peakIopsAllocationPolicy enum 15 Indicates peak IOPS allocation policy.
conformancePolicyUuid varchar 512  √  null Conformance policy associated with the performance policy.
systemDefined bit 0 0 Indicates if this is a system-provided performance policy.
createTime bigint 19
updateTime bigint 19
usedCapacity decimal 41  √  null
workloadCount bigint 19 0

Analyzed at Tue Apr 23 04:58 EDT 2019

View Definition:
select `s`.`id` AS `id`,`s`.`uuid` AS `uuid`,`s`.`name` AS `name`,`s`.`description` AS `description`,`s`.`peakIopsPerTB` AS `peakIopsPerTB`,`s`.`expectedIopsPerTB` AS `expectedIopsPerTB`,`s`.`absoluteMinIops` AS `absoluteMinIops`,`s`.`expectedLatency` AS `expectedLatency`,`s`.`peakIopsAllocationPolicy` AS `peakIopsAllocationPolicy`,`s`.`conformancePolicyUuid` AS `conformancePolicyUuid`,`s`.`systemDefined` AS `systemDefined`,`s`.`createTime` AS `createTime`,`s`.`updateTime` AS `updateTime`,sum(coalesce(`netapp_model`.`lun`.`sizeUsed`,`vol`.`sizeUsed`,0)) AS `usedCapacity`,count(`wpm`.`storageServiceLevelId`) AS `workloadCount` from (((`opm`.`storage_service_level` `s` left join `opm`.`workload_provision_mapping` `wpm` on((`wpm`.`storageServiceLevelId` = `s`.`id`))) left join `netapp_model`.`volume` `vol` on(((`vol`.`objid` = `wpm`.`workloadId`) and (`wpm`.`workloadType` = 13)))) left join `netapp_model`.`lun` on(((`netapp_model`.`lun`.`objid` = `wpm`.`workloadId`) and (`wpm`.`workloadType` = 6)))) group by `s`.`name`
 
Possibly Referenced Tables/Views: