Solved

Import Performance Monitor saved files to Database

Posted on 2007-11-18
2
1,038 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:ZURINET
2 Comments
 
LVL 8

Accepted Solution

by:
ubig earned 500 total points
ID: 20310763
0
 

Author Comment

by:ZURINET
ID: 20311036
Hoi Ubig..

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

Zurinet
0

Featured Post

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now