Skip to content

Instantly share code, notes, and snippets.

@fo40225

fo40225/fdhost_cpu.sql

Last active September 28, 2019 06:06
Show Gist options
  • Save fo40225/4cb8016863463575a037d5aeda92b086 to your computer and use it in GitHub Desktop.
Save fo40225/4cb8016863463575a037d5aeda92b086 to your computer and use it in GitHub Desktop.
Download ZIP
fdhost cpu
Raw
fdhost_cpu.sql
sp_configure 'show advanced options'
go
sp_configure 'show advanced options', 1
go
RECONFIGURE
go
sp_configure 'max full-text crawl range'
go
sp_configure 'max full-text crawl range', 16
go
RECONFIGURE
go
EXEC sp_fulltext_service 'Restart_all_fdhosts'
-- restore
--sp_configure 'max full-text crawl range', 4
--go
--sp_configure 'show advanced options', 0
--go
--RECONFIGURE
--go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment