How do you use cloud databases? Take the survey.
Options

Connection failed (Internal SQL Monitor error) - SqlProcessSampler

CarolCarol Posts: 2 New member
edited April 30, 2024 7:15AM in Redgate Monitor
Hi All / Redgate Support Team,
We encountered an alert error Connection failed (Internal SQL Monitor error) - SqlProcessSampler in our server. 
Exception : CultureNotFoundException
Exception message : Culture is not supported. (Parameter 'culture') 66577 (0x10411) is an invalid culture identifier.
It seems occurred every hour. We do not have this kind of error previously until we installed a custom metrics
(

OS Wait Time: Async_Network_IO(secs) 

Average IO stall

)
I am not sure whether is the custom metrics caused it or other reason. 
Please help and provide your insights if you have experienced before.

Thanks,
Carol
Tagged:

Answers

  • Options
    ATurnerATurner Posts: 193 Silver 2
    Hi Carol

    Is this a newly added server, or has it just occurred on this instance that has been monitored for a whilst?
    What is the collation of the system databases of this instance?

    SELECT name, collation_name FROM sys.databases

  • Options
    CarolCarol Posts: 2 New member
    edited May 3, 2024 9:28AM
    Hi, thanks for your reply. we have been monitored it for quite some time.
    After i installed the custom metric "Average I/O stalls" and "OS Wait Time: Async_Network_IO", then the server start receiving this error. 
    The collation for the system databases is Japanese_XJIS_100_BIN2. However, some user databases collation are Japanese_Unicode_BIN2.



    Thanks,
    Carol
  • Options
    ATurnerATurner Posts: 193 Silver 2
    Hi Carol

    I have been attempting to replicate this but have been unable to do so thusfar. Does this only occur when the custom metric is gathering from this machine? 
Sign In or Register to comment.