Solved

Import Performance Monitor saved files to Database

Posted on 2007-11-18
2
1,061 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
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…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
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…

726 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