Post reply

Error 30063 - SQL Server could not set fdhost.exe process to 65535 because the value is not valid.

  • October 23, 2015 at 1:57 am

    #304442

    How do I go about fixing the error/warning in the topic?

    Is it a registry entry somewhere? I searched the registry for fdhost.exe without finding a parameter set to 65535.

    I should say, it appears in the errorlog on instance startup right after the fdhost process has been started. The FT service is running when looking at the Configuration manager.

    [font="Courier New"]2015-10-22 23:25:15.770spid17sA new instance of the full-text filter daemon host process has been successfully started.

    2015-10-22 23:25:15.780spid17sWarning: SQL Server could not set fdhost.exe processor affinity to 65535 because the value is not valid.[/font]

  • November 23, 2015 at 9:16 am

    #1841773

    Hi Ramus,

    Did you get to the bottom of this error message as we are experiencing the same issue.

    Thanks

    Frant101

  • November 23, 2015 at 2:59 pm

    #1841875

    Hi Frant101,

    No, havent found a fix yet. Keep me posted if you do.

  • November 24, 2015 at 2:03 am

    #1841952

    Hi,

    Still working on it and trying to establish if its anything to be concerned about.

    Configuration of Machine 2 Sockets , 20 Cores , 40 logical processors - although we only have 40 logical processors, Windows Server 2012 R2 has created two processor groups (thought this was only meant to happen when you had over 64 logical processors ?)

    SQL Server sees this logical CPU's as NumNode0 - CPU0 to CPU19 and NumNode1 - CPU64 to CPU83

    I've established that we only see this message in the error log when we set the processor affinity mask to use any of the logical processors from the second processor group (CPU64 - CPU83).

    Currently trying to establish why Windows Server 2012 has created a 2nd processor group as I don't think this is expected behaviour. The below links helped me :

    http://blogs.msdn.com/b/psssql/archive/2011/11/11/sql-server-clarifying-the-numa-configuration-information.aspx

    http://blogs.msdn.com/b/saponsqlserver/archive/2011/04/20/changes-in-affinity-settings-of-sql-server-2008-r2-to-support-gt-64-logical-processors.aspx

    http://blogs.msdn.com/b/saponsqlserver/archive/2010/09/28/windows-2008-r2-groups-processors-sockets-cores-threads-numa-nodes-what-is-all-this.aspx

    Thanks

    Frant101

  • November 24, 2015 at 10:25 pm

    #1842240

    Please check if you got any non-default values for the configurations:

    'affinity mask' and ‘affinity64 mask’

    if so, then set them default

  • November 24, 2015 at 11:44 pm

    #1842246

    I am not sure what the default settings are, but ours look like this - I don't think they have been changed.

    [font="Courier New"]

    name min max config run

    affinity I/O mask-2147483648214748364700

    affinity mask -2147483648214748364700

    affinity64 I/O mask-2147483648214748364700

    affinity64 mask -2147483648214748364700[/font]

    SQL server also created two NUMA nodes for our setup which, from the errorlog is

    [font="Courier New"]SQL Server detected 2 sockets with 4 cores per socket and 8 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing. This is an informational message; no user action is required.[/font]

    NumaNode0 is CPU0 through CPU7, NumaNode1 is CPU64 through CPU71.

  • November 30, 2015 at 8:42 am

    #1842901

    I can confirm the following link fixed the issue for us :

    http://h20564.www2.hpe.com/hpsc/doc/public/display?docId=emr_na-c04650594&sp4ts.oid=5379860

    Changing the System ROM BIOS option from Clustered to Flat for the NUMA Group Size Optimization allowed Windows to see all 40 logical processors in one Windows Processor Group and in turn stopped the warning message appearing in the Error Logs.

    SQL Server now correctly sees this logical CPU's as NumNode0 - CPU0 to CPU19 and NumNode1 - CPU20 to CPU39

    Obviously this only applies to HP ProLiant Gen9 server configured with an Intel Xeon E5 2600v3 processor

    Hope the info helps

    Frant101

  • December 3, 2015 at 5:18 am

    #1843732

    Well spotted!

    As it turns out, we're also using G9 HP with Xeon 26xx processors. I've asked our systems department to upgrade the BIOS and set the NUMA Group Size Optimization to FLAT - will post if this solves the issue at our side as well.

  • December 3, 2015 at 5:27 am

    #1843734

    Great feedback, guys ! :w00t:

    Thanks.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • December 17, 2015 at 12:20 am

    #1846478

    Upgrading our HP Proliant G9 Xeon server to the newest BIOS and setting the NUMA Group to FLAT also resolved our issue.

    Thanks for helping out.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply