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