Link to home
Start Free TrialLog in
Avatar of ZURINET
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].[CounterData]
 
  SELECT [CounterID]
      ,[MachineName]
      ,[ObjectName]
      ,[CounterName]
      ,[CounterType]
      ,[DefaultScale]
      ,[InstanceName]
      ,[InstanceIndex]
      ,[ParentName]
      ,[ParentObjectID]
      ,[TimeBaseA]
      ,[TimeBaseB]
  FROM [BaseLineOLAP].[dbo].[CounterDetails]
 
  SELECT [GUID]
      ,[RunID]
      ,[DisplayString]
      ,[LogStartTime]
      ,[LogStopTime]
      ,[NumberOfRecords]
      ,[MinutesToUTC]
      ,[TimeZoneName]
  FROM [BaseLineOLAP].[dbo].[DisplayToID]
Zones: Network Analysis Software, Co
ASKER CERTIFIED SOLUTION
Avatar of ubig
ubig
Flag of Lithuania image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ZURINET
ZURINET

ASKER

Hoi Ubig..

Thanks for the tip..
I am still looking for a small tutorial..
will get back to you soon

Zurinet