Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Import Performance Monitor saved files to Database

Posted on 2007-11-18
2
Medium Priority
?
1,090 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 1500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
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…

636 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