odd wait type

• tcronin 95651

  SSCertifiable

  Points: 6735

  More actions

  November 23, 2016 at 1:51 pm

  #332329

  Have a server having performance issues when look at wait types my number #1 is

  FT_IFTSHC_MUTEX281386.4

  never seen this on any other servers

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 24, 2016 at 2:38 am

  #1914380

  Any database on that server have Full Text Indexing enabled on it?

  It's in Glenn's list of benign waits to ignore, so I'd just ignore it (lots of waits should be ignored as they're expected or benign)

  http://www.sqlskills.com/blogs/glenn/category/dmv-queries/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  November 24, 2016 at 3:07 am

  #1914383

  It occurs when threads busy with full text operations wait for synchronisation.

  https://www.sqlskills.com/help/waits/ft_iftshc_mutex/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass