Solved

Import Performance Monitor saved files to Database

Posted on 2007-11-18
2
1,072 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My previous article  (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html)detailed one possible method to get SCCM 2007 installed an…
This is my 3rd article on SCCM in recent weeks, the 1st (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html) dealing with installat…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
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…

691 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