Anyone have any experience or comments using Microsoft SQL Server Health and
History Tool?
Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
================================================== ====
Get Secure! - www.microsoft.com/security
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties,and confers no rights.
================================================== ====
--[vbcol=seagreen]
and[vbcol=seagreen]
Showing posts with label health. Show all posts
Showing posts with label health. Show all posts
Monday, February 20, 2012
Microsoft SQL Server Health and History Tool
Hi All
I am reciving the following error when running the
Microsoft SQL Server Health and History Tool:
22/09/2004 1:48:56 PM INFO: version: 8.00.760
22/09/2004 1:48:56 PM Status: RUN
22/09/2004 1:48:56 PM Status: Initializing
collector: WMI
22/09/2004 1:48:56 PM Status: Running WMI collector
22/09/2004 1:48:56 PM Status: Opening Unit 1
(OS/CS)
22/09/2004 1:48:56 PM Status: Collecting
Win32_OperatingSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_ComputerSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_Processor
22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
syntax near 'c09'.
22/09/2004 1:48:58 PM Status: Closing Unit 1
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM WARNING: WMI Collector
encountered critical error. Abandoning Collector.
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM ERROR: test01: Collection
failed; Error:104; Provider Error: 170
22/09/2004 1:48:58 PM ERROR: Critical Repository
Failure
22/09/2004 1:48:58 PM SQLH2 is shutting down
22/09/2004 1:48:58 PM Closing Log
Has anyone come acrosss this error and can advise.
Thanks
Yes, i also have problems too.
And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).
Also reports are not working because of that i think. Hate this localization
problems.
I will try on English Locale server and see if it works..
"anonymous@.discussions.microsoft.com" wrote:
> Hi All
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
> Has anyone come acrosss this error and can advise.
> Thanks
>
I am reciving the following error when running the
Microsoft SQL Server Health and History Tool:
22/09/2004 1:48:56 PM INFO: version: 8.00.760
22/09/2004 1:48:56 PM Status: RUN
22/09/2004 1:48:56 PM Status: Initializing
collector: WMI
22/09/2004 1:48:56 PM Status: Running WMI collector
22/09/2004 1:48:56 PM Status: Opening Unit 1
(OS/CS)
22/09/2004 1:48:56 PM Status: Collecting
Win32_OperatingSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_ComputerSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_Processor
22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
syntax near 'c09'.
22/09/2004 1:48:58 PM Status: Closing Unit 1
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM WARNING: WMI Collector
encountered critical error. Abandoning Collector.
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM ERROR: test01: Collection
failed; Error:104; Provider Error: 170
22/09/2004 1:48:58 PM ERROR: Critical Repository
Failure
22/09/2004 1:48:58 PM SQLH2 is shutting down
22/09/2004 1:48:58 PM Closing Log
Has anyone come acrosss this error and can advise.
Thanks
Yes, i also have problems too.
And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).
Also reports are not working because of that i think. Hate this localization
problems.
I will try on English Locale server and see if it works..
"anonymous@.discussions.microsoft.com" wrote:
> Hi All
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
> Has anyone come acrosss this error and can advise.
> Thanks
>
Microsoft SQL Server Health and History Tool
Hi All
I am reciving the following error when running the
Microsoft SQL Server Health and History Tool:
22/09/2004 1:48:56 PM INFO: version: 8.00.760
22/09/2004 1:48:56 PM Status: RUN
22/09/2004 1:48:56 PM Status: Initializing
collector: WMI
22/09/2004 1:48:56 PM Status: Running WMI collector
22/09/2004 1:48:56 PM Status: Opening Unit 1
(OS/CS)
22/09/2004 1:48:56 PM Status: Collecting
Win32_OperatingSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_ComputerSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_Processor
22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
syntax near 'c09'.
22/09/2004 1:48:58 PM Status: Closing Unit 1
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM WARNING: WMI Collector
encountered critical error. Abandoning Collector.
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM ERROR: test01: Collection
failed; Error:104; Provider Error: 170
22/09/2004 1:48:58 PM ERROR: Critical Repository
Failure
22/09/2004 1:48:58 PM SQLH2 is shutting down
22/09/2004 1:48:58 PM Closing Log
Has anyone come acrosss this error and can advise.
ThanksYes, i also have problems too.
And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).
Also reports are not working because of that i think. Hate this localization
problems.
I will try on English Locale server and see if it works..
"anonymous@.discussions.microsoft.com" wrote:
> Hi All
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
> Has anyone come acrosss this error and can advise.
> Thanks
>
I am reciving the following error when running the
Microsoft SQL Server Health and History Tool:
22/09/2004 1:48:56 PM INFO: version: 8.00.760
22/09/2004 1:48:56 PM Status: RUN
22/09/2004 1:48:56 PM Status: Initializing
collector: WMI
22/09/2004 1:48:56 PM Status: Running WMI collector
22/09/2004 1:48:56 PM Status: Opening Unit 1
(OS/CS)
22/09/2004 1:48:56 PM Status: Collecting
Win32_OperatingSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_ComputerSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_Processor
22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
syntax near 'c09'.
22/09/2004 1:48:58 PM Status: Closing Unit 1
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM WARNING: WMI Collector
encountered critical error. Abandoning Collector.
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM ERROR: test01: Collection
failed; Error:104; Provider Error: 170
22/09/2004 1:48:58 PM ERROR: Critical Repository
Failure
22/09/2004 1:48:58 PM SQLH2 is shutting down
22/09/2004 1:48:58 PM Closing Log
Has anyone come acrosss this error and can advise.
ThanksYes, i also have problems too.
And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).
Also reports are not working because of that i think. Hate this localization
problems.
I will try on English Locale server and see if it works..
"anonymous@.discussions.microsoft.com" wrote:
> Hi All
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
> Has anyone come acrosss this error and can advise.
> Thanks
>
Microsoft SQL Server Health and History Tool
Anyone have any experience or comments using Microsoft SQL Server Health and
History Tool?Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Reply-To: "TM" <tmcclenn@.community.nospam>
>>From: "TM" <tmcclenn@.community.nospam>
>>Subject: Microsoft SQL Server Health and History Tool
>>Date: Mon, 6 Nov 2006 10:45:23 -0500
>>Lines: 5
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <#B$rSqbAHHA.1224@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: ip70-161-7-200.hr.hr.cox.net 70.161.7.200
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:450417
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Anyone have any experience or comments using Microsoft SQL Server Health
and
>>History Tool?
>>
>>
History Tool?Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Reply-To: "TM" <tmcclenn@.community.nospam>
>>From: "TM" <tmcclenn@.community.nospam>
>>Subject: Microsoft SQL Server Health and History Tool
>>Date: Mon, 6 Nov 2006 10:45:23 -0500
>>Lines: 5
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <#B$rSqbAHHA.1224@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: ip70-161-7-200.hr.hr.cox.net 70.161.7.200
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:450417
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Anyone have any experience or comments using Microsoft SQL Server Health
and
>>History Tool?
>>
>>
Microsoft SQL Server Health and History Tool
Anyone have any experience or comments using Microsoft SQL Server Health and
History Tool?Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads...d10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
and[vbcol=seagreen]
History Tool?Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads...d10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
and[vbcol=seagreen]
Subscribe to:
Posts (Atom)