true
Data Source=localhost;Initial Catalog=MDW
SQL
dbdaf3b1-2933-4b70-a1ad-3aab6983df43
1in
1in
true
8.5in
true
Plain
SSAS Connections
Time
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
Connections
true
Outside
0
true
true
true
2
Line
8.875in
=Fields!CollectionDate.Value
=Fields!snapshot_id.Value
Default
=Sum(Fields!raw_value_first.Value)
Plain
SSAS Memory Usage, KB
3.375in
Time
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
KB
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