January 30, 2018 at 11:19 am
I have sql server 2014 has a system process that is blocking another systems process every 15 mins and then go away.
It does not provide any details about the spid. When i try to find the details about the spid then it says SessionID has either ended. Only details i can see about the blocking system spid command is FT BATCH CMPLETE. Have you seen this before?
Any idea?
January 30, 2018 at 12:44 pm
Admingod - Tuesday, January 30, 2018 11:19 AMI have sql server 2014 has a system process that is blocking another systems process every 15 mins and then go away.
It does not provide any details about the spid. When i try to find the details about the spid then it says SessionID has either ended. Only details i can see about the blocking system spid command is FT BATCH CMPLETE. Have you seen this before?
Any idea?
FT ... implies Full Text Search. There are some tuning things that can be done with that if necessary.
How long is the blocking, and what is blocked, and does it really matter in any case?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 30, 2018 at 12:56 pm
I see the blocking every 10- 15 mins and the blocking won't last more than 30 secs - 1 min.It blocks the FT CRAWL MON SPID and which seems to be a system spid. so far its not blocking any user spids.
January 30, 2018 at 9:07 pm
Well, if it isn't causing user complaints I don't know that I would worry too much.
Are you using sp_whoisactive (with some parameters enabled) to do your investigation?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply