OK Now things are becoming clearer
SQLH2 is not real time monitoring as the performance files are not added to the database. (not a problem)
D:\SQLH2\Sqlh2 /DDMY is scheduled to upload the Perf files (How often is this scheduled??) ... does this also collect the other server data? (H/W, NIC, Disk e.t.c)
I ran SQLH2 and the Perf File was Removed...
The Following log entry was created
28/10/2004 10:03:29 Opening Log
28/10/2004 10:03:29 SQLH2 ver. V2 2.0.024.0 9/30/04 17:58
28/10/2004 10:03:29 INFO: The following command line arguments were supplied: /DDMY
28/10/2004 10:03:29 Status: Init
28/10/2004 10:03:29 Status: Initializing repository: (local)
28/10/2004 10:03:30 Status: Repository Database: SQLH2Repository
28/10/2004 10:03:30 INFO: host_id = 3
28/10/2004 10:03:30 Status: Starting RUN
28/10/2004 10:03:30 Status: Registering Run
28/10/2004 10:03:30 INFO: run_id = 14
28/10/2004 10:03:30 Status: Starting Targets processing
28/10/2004 10:03:30 Status: Initializing Target: DEV-SQL
28/10/2004 10:03:30 Status: registering Server
28/10/2004 10:03:30 INFO: srv_id = 1; signature = 9b0d433d-4169-44ec-9340-181606c93232
28/10/2004 10:03:30 Status: Scanning Registry on DEV-SQL
28/10/2004 10:03:30 Status: registering instance DEV-SQL
28/10/2004 10:03:30 INFO: inst_id = 1
28/10/2004 10:03:30 INFO: version: 8.00.760
28/10/2004 10:03:30 Status: RUN
28/10/2004 10:03:30 Status: Initializing collector: WMI
28/10/2004 10:03:30 Status: Running WMI collector
28/10/2004 10:03:30 Status: Opening Unit 1 (OS/CS)
28/10/2004 10:03:30 Status: Collecting Win32_OperatingSystem
28/10/2004 10:03:32 Status: Collecting Win32_ComputerSystem
28/10/2004 10:03:33 Status: Collecting Win32_Processor
28/10/2004 10:03:35 Status: Closing Unit 1
28/10/2004 10:03:35 Status: Opening Unit 2 (NIC)
28/10/2004 10:03:35 Status: Collecting Win32_NetworkAdapter
28/10/2004 10:03:36 Status: Collecting Win32_NetworkAdapterConfiguration
28/10/2004 10:03:36 Status: Closing Unit 2
28/10/2004 10:03:36 Status: Opening Unit 3 (Disk)
28/10/2004 10:03:36 Status: Collecting Win32_DiskDrive
28/10/2004 10:03:36 Status: Closing Unit 3
28/10/2004 10:03:36 Status: Opening Unit 4 (QFEs)
28/10/2004 10:03:36 Status: Collecting QFE registry
28/10/2004 10:03:36 Status: Closing Unit 4
28/10/2004 10:03:36 Status: Opening Unit 5 (EventLog files)
28/10/2004 10:03:36 Status: Collecting Win32_NTEventlogFile
28/10/2004 10:03:37 Status: Closing Unit 5
28/10/2004 10:03:37 Status: Opening Unit 6 (Processes)
28/10/2004 10:03:37 Status: Collecting Win32_Process
28/10/2004 10:03:37 Status: Closing Unit 6
28/10/2004 10:03:37 Status: Opening Unit 7 (Products)
28/10/2004 10:03:37 Status: Collecting Win32_Product
28/10/2004 10:03:40 Status: Closing Unit 7
28/10/2004 10:03:40 Status: Opening Unit 8 (Services)
28/10/2004 10:03:40 Status: Collecting Win32_Service
28/10/2004 10:03:42 Status: Closing Unit 8
28/10/2004 10:03:42 Status: Initializing collector: EventLog
28/10/2004 10:03:42 Status: Initializing collector: SQL
28/10/2004 10:03:42 Status: Running SQL collector on DEV-SQL
28/10/2004 10:03:42 Status: Opening Unit 5 (Server Properties)
28/10/2004 10:03:42 Status: Closing Unit 5
28/10/2004 10:03:42 Status: Opening Unit 1 (Databases)
28/10/2004 10:03:48 Status: Closing Unit 1
28/10/2004 10:03:48 Status: Opening Unit 2 (Current Configuration)
28/10/2004 10:03:48 Status: Closing Unit 2
28/10/2004 10:03:48 Status: Opening Unit 3 (Running traces)
28/10/2004 10:03:48 Status: Closing Unit 3
28/10/2004 10:03:48 Status: Opening Unit 4 (Registry)
28/10/2004 10:03:48 Status: Collecting Watson settings from Registry
28/10/2004 10:03:48 Status: Collecting dumps info
28/10/2004 10:03:48 Status: Closing Unit 4
28/10/2004 10:03:48 Status: Running EventLog collector on DEV-SQL
28/10/2004 10:03:48 Status: Opening Unit 1
28/10/2004 10:03:48 Status: Opening System EventLog on DEV-SQL
28/10/2004 10:03:48 Status: 13170 events in the log
28/10/2004 10:03:48 Status: 13132 (99%) rolled forward
28/10/2004 10:03:48 Status: 13170 (100%) events processed
28/10/2004 10:03:48 INFO: 13170 events processed
28/10/2004 10:03:48 Status: Analyzing OS outages
28/10/2004 10:03:48 Status: Closing Unit 1
28/10/2004 10:03:48 Status: Opening Unit 2
28/10/2004 10:03:48 Status: Opening Application EventLog on DEV-SQL
28/10/2004 10:03:48 Status: 42691 events in the log
28/10/2004 10:03:48 Status: 42508 (99%) rolled forward
28/10/2004 10:03:48 Status: 42691 (100%) events processed
28/10/2004 10:03:48 INFO: 42691 events processed
28/10/2004 10:03:48 Status: Instance: MSSQLSERVER
28/10/2004 10:03:48 Status: Analyzing SQL outages
28/10/2004 10:03:48 Status: Analyzing trace history
28/10/2004 10:03:48 Status: Analyzing AV/assertion history
28/10/2004 10:03:48 Status: Analyzing Watson history
28/10/2004 10:03:49 Status: Closing Unit 2
28/10/2004 10:03:49 Status: DEV-SQL: Collection finished
28/10/2004 10:03:49 Status: Targets processing finished
28/10/2004 10:03:49 Status: Starting Perf Loader
28/10/2004 10:03:49 INFO: Perf host_id = 3
28/10/2004 10:03:49 INFO: Lock aquired: pid = 1
28/10/2004 10:03:49 INFO: D:\SQLH2\PerfCollector\Data\pfc102604161919.txt: fid = 4, state = 0, retry = 0
28/10/2004 10:03:49 Status: Perf records loaded: 0
28/10/2004 10:03:49 INFO: Lock released: pid = 1
28/10/2004 10:03:49 Status: Perf Loader finished
28/10/2004 10:03:49 Status: Starting Data Exporter
28/10/2004 10:03:49 Status: Data Export is not allowed for this Repository
28/10/2004 10:03:49 Status: Data Exporter finished
28/10/2004 10:03:49 SQLH2 is shutting down
28/10/2004 10:03:49 Closing Log
I Cannot Find any entries for the perf Data but it looks as though the data has been transfered into the database... Where should I look to Check?
Thanks for the help
I will post this now as I have lost My train of thought
Regards
Andy