true Data Source=localhost;Initial Catalog=MDW SQL dbdaf3b1-2933-4b70-a1ad-3aab6983df43 1in 1in true 8.5in true RightCenter Plain <Caption>SSAS Connections</Caption> <Caption>Time</Caption> Outside 0 true true 0 0.5in 30 30 Simple 50 MDW Equal \MSAS 2008:Connection\Current connections =Fields!path.Value =Fields!performance_instance_name.Value 4.125in <Caption>Connections</Caption> true Outside 0 true true true 2 Line 8.875in =Fields!CollectionDate.Value =Fields!snapshot_id.Value Default =Sum(Fields!raw_value_first.Value) RightCenter Plain <Caption>SSAS Memory Usage, KB</Caption> 3.375in <Caption>Time</Caption> Outside 0 true 0 0.125in 30 30 Simple 50 MDW Equal \MSAS 2008:Memory\Memory Usage KB =Fields!path.Value =Fields!performance_instance_name.Value 0.5in <Caption>KB</Caption> true Outside 0 true true true 1 Line 9.25in =Fields!CollectionDate.Value =Fields!snapshot_id.Value Default =Sum(Fields!raw_value_first.Value) textbox1 5in true 0.36in SSAS Counters 7.25in 94e41f47-2ddc-493a-8420-a22b61da3248 1in true SELECT performance_counter_id, snapshot_id , collection_time , RIGHT(LEFT(CONVERT(varchar, collection_time, 120),10),5) AS CollectionDate , LEFT(RIGHT(CONVERT(varchar, collection_time, 120),8),5) AS CollectionTime , path , performance_object_name, performance_counter_name , performance_instance_name, formatted_value, raw_value_first, raw_value_second FROM [MDW].[snapshots].[performance_counters] WHERE performance_object_name like 'MSAS 2008:%' MDW System.Int32 performance_counter_id System.Int32 snapshot_id System.DateTime collection_time System.String CollectionDate System.String CollectionTime System.String path System.String performance_object_name System.String performance_counter_name System.String performance_instance_name System.Double formatted_value System.Int64 raw_value_first System.Int64 raw_value_second 9.75in 11in en-US 1in