What does -3 state means on a PerfColector?
I'm using en-US windows locale spanish sql server & database with english in user instance settings.
That's the SQLH2 log:
4/11/2008 1:40:44 PM Status: Starting Perf Loader
4/11/2008 1:40:44 PM INFO: Perf host_id = 2
4/11/2008 1:40:44 PM INFO: Lock aquired: pid = 1
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pf040108165200.txt:
fid = 1, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc040108173252.txt:
fid = 3, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc040308121908.txt:
fid = 4, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc040908030916.txt:
fid = 5, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008103549.txt:
fid = 6, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008113250.txt:
fid = 7, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008130242.txt:
fid = 8, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008160816.txt:
fid = 9, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008163638.txt:
fid = 10, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008165536.txt:
fid = 11, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008175623.txt:
fid = 12, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008180152.txt:
fid = 13, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008180943.txt:
fid = 14, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008190030.txt:
fid = 15, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: C:\SQLH2\PerfCollector\Data\pfc041008190043.txt:
fid = 16, state = -3, retry = 0
4/11/2008 1:40:44 PM INFO: Lock released: pid = 1
4/11/2008 1:40:44 PM Status: Perf Loader finished
That's C:\SQLH2\PerfCollector\Data\pf040108165200.txt file:
e2e15752-d140-4ca8-8d1f-9fbd8dc6c44f,632dfe80-4808-4f2b-aa06-673456abcb02,e25ef2c6-160c-44a5-99c7-9fedd1ef50b3,,
,,,,
1,SRVPRUEBAS,,,
,,,,
,,,,
1,PROCESSOR,% PROCESSOR TIME,_TOTAL,
2,PROCESSOR,% PRIVILEGED TIME,_TOTAL,
3,MEMORY,AVAILABLE KBYTES,,
4,MEMORY,PAGES/SEC,,
5,MEMORY,COMMITTED BYTES,,
6,MEMORY,COMMIT LIMIT,,
7,SYSTEM,PROCESSOR QUEUE LENGTH,,
8,SYSTEM,CONTEXT SWITCHES/SEC,,
9,PHYSICALDISK,AVG. DISK QUEUE LENGTH,_TOTAL,
10,PHYSICALDISK,AVG. DISK SEC/READ,_TOTAL,
11,PHYSICALDISK,AVG. DISK SEC/WRITE,_TOTAL,
12,PHYSICALDISK,DISK READS/SEC,_TOTAL,
13,PHYSICALDISK,DISK WRITES/SEC,_TOTAL,
14,PHYSICALDISK,DISK READ BYTES/SEC,_TOTAL,
15,PHYSICALDISK,DISK WRITE BYTES/SEC,_TOTAL,
16,PROCESS,% PROCESSOR TIME,SQLSERVR,
17,SQLSERVER:BUFFER MANAGER,BUFFER CACHE HIT RATIO,,
18,SQLSERVER:BUFFER MANAGER,CHECKPOINT PAGES/SEC,,
19,SQLSERVER:BUFFER MANAGER,PAGE LIFE EXPECTANCY,,
20,SQLSERVER:MEMORY MANAGER,TOTAL SERVER MEMORY (KB),,
21,SQLSERVER:MEMORY MANAGER,TARG