Topic: MS a SQL Server 2016 and Service Broker!
There was such problem:
There was an error in a cache of events of the timer. An error 2905, a state 2.
The code: 9646
The given error repeats endlessly yet does not hammer completely in a hard disk!
articles on the Internet came to a conclusion that all business in component Service Broker!
Found a script which stops transfer of messages:
ALTER DATABASE name_bd SET DISABLE_BROKER;
The script helped! The error left! But after systems, appeared again, and the script is not fulfilled any more (((
Help please! To solve the given problem!
At once I notify a teapot in this business so if it is possible is very detailed!