SELECT TOP 100
	myInstance.instance_name as DBInstance
	--,mySnapshotsTime.snapshot_time
	--,myDefinedCounters.path
	,myDefinedCounters.object_name as Category
	,myDefinedCounters.counter_name as CounterName
	,myDefinedCounters.instance_name as InstanceName
	,myCounterValues.collection_time as CollectionTime
	,myCounterValues.formatted_value as Value
FROM 
	[snapshots].[performance_counter_instances] as myDefinedCounters
	INNER JOIN [snapshots].[performance_counter_values] as myCounterValues ON myCounterValues.performance_counter_instance_id=myDefinedCounters.performance_counter_id
	INNER JOIN [core].[snapshots_internal] as mySnapshotsInternal on myCounterValues.snapshot_id=mySnapshotsInternal.snapshot_id
	--INNER JOIN [core].[snapshot_timetable_internal] as mySnapshotsTime on mySnapshotsInternal.snapshot_time_id=mySnapshotsTime.snapshot_time_id
	INNER JOIN [core].[source_info_internal] as myInstance ON mySnapshotsInternal.source_id=myInstance.source_id