ZURINET
asked on
Import Performance Monitor saved files to Database
Import Performance Monitor saved files to Database
Bookmark:
Question: Hi all
We just have some guru over in the office..
They did analysis of our servers and saved the output to a "*.BLG" file.
Now we need to create an OLAP database based on the tables below..
Now the big question is. How can we extract the related column files from the saved .BLG
files.
Note the tables below are created automatically we the protocols of the performance monitor is saved to a database
SELECT [GUID]
,[CounterID]
,[RecordIndex]
,[CounterDateTime]
,[CounterValue]
,[FirstValueA]
,[FirstValueB]
,[SecondValueA]
,[SecondValueB]
,[MultiCount]
FROM [BaseLineOLAP].[dbo].[Coun terData]
SELECT [CounterID]
,[MachineName]
,[ObjectName]
,[CounterName]
,[CounterType]
,[DefaultScale]
,[InstanceName]
,[InstanceIndex]
,[ParentName]
,[ParentObjectID]
,[TimeBaseA]
,[TimeBaseB]
FROM [BaseLineOLAP].[dbo].[Coun terDetails ]
SELECT [GUID]
,[RunID]
,[DisplayString]
,[LogStartTime]
,[LogStopTime]
,[NumberOfRecords]
,[MinutesToUTC]
,[TimeZoneName]
FROM [BaseLineOLAP].[dbo].[Disp layToID]
Zones: Network Analysis Software, Co
Bookmark:
Question: Hi all
We just have some guru over in the office..
They did analysis of our servers and saved the output to a "*.BLG" file.
Now we need to create an OLAP database based on the tables below..
Now the big question is. How can we extract the related column files from the saved .BLG
files.
Note the tables below are created automatically we the protocols of the performance monitor is saved to a database
SELECT [GUID]
,[CounterID]
,[RecordIndex]
,[CounterDateTime]
,[CounterValue]
,[FirstValueA]
,[FirstValueB]
,[SecondValueA]
,[SecondValueB]
,[MultiCount]
FROM [BaseLineOLAP].[dbo].[Coun
SELECT [CounterID]
,[MachineName]
,[ObjectName]
,[CounterName]
,[CounterType]
,[DefaultScale]
,[InstanceName]
,[InstanceIndex]
,[ParentName]
,[ParentObjectID]
,[TimeBaseA]
,[TimeBaseB]
FROM [BaseLineOLAP].[dbo].[Coun
SELECT [GUID]
,[RunID]
,[DisplayString]
,[LogStartTime]
,[LogStopTime]
,[NumberOfRecords]
,[MinutesToUTC]
,[TimeZoneName]
FROM [BaseLineOLAP].[dbo].[Disp
Zones: Network Analysis Software, Co
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the tip..
I am still looking for a small tutorial..
will get back to you soon
Zurinet