How to interpret ReLog Table
Bascially, I use Relog extracts perf data and then save to SQL database for further analysis. The Relog will auto generate three tables:- CREATE TABLE [dbo].[CounterData]( [GUID] [uniqueidentifier] NOT NULL, [CounterID] [int] NOT NULL, [RecordIndex] [int] NOT NULL, [CounterDateTime] [char](24) NOT NULL, [CounterValue] [float] NOT NULL, [FirstValueA] [int] NULL, [FirstValueB] [int] NULL, [SecondValueA] [int] NULL, [SecondValueB] [int] NULL, [MultiCount] [int] NULL ) CREATE TABLE [dbo].[CounterDetails]( [CounterID] [int] IDENTITY(1,1) NOT NULL, [MachineName] [varchar](1024) NOT NULL, [ObjectName] [varchar](1024) NOT NULL, [CounterName] [varchar](1024) NOT NULL, [CounterType] [int] NOT NULL, [DefaultScale] [int] NOT NULL, [InstanceName] [varchar](1024) NULL, [InstanceIndex] [int] NULL, [ParentName] [varchar](1024) NULL, [ParentObjectID] [int] NULL, [TimeBaseA] [int] NULL, [TimeBaseB] [int] NULL ) CREATE TABLE [dbo].[DisplayToID]( [GUID] [uniqueidentifier] NOT NULL, [RunID] [int] NULL, [DisplayString] [varchar](1024) NOT NULL, [LogStartTime] [char](24) NULL, [LogStopTime] [char](24) NULL, [NumberOfRecords] [int] NULL, [MinutesToUTC] [int] NULL, [TimeZoneName] [char](32) NULL ) Is there any documentation on these ? What's the difference among CounterValue, FirstValueA, FirstValueB, SecondValueA, SecondValueB, MultiCount ? thanks, Lan
September 19th, 2011 10:56am

Hi, Please check if following article can help on your question: http://msdn.microsoft.com/en-us/library/aa371915%28VS.85%29.aspx And you can have a try on the following forums for the Relog command related question: Windows Desktop Perfmon and Diagnostic tools http://social.technet.microsoft.com/Forums/en-US/perfmon/threads SQL Server http://social.msdn.microsoft.com/Forums/en/category/sqlserver TechNet Subscriber Support in forum |If you have any feedback on our support, please contact tnmff@microsoft.com.
Free Windows Admin Tool Kit Click here and download it now
September 21st, 2011 3:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics