Viewing 2 posts - 1 through 2 (of 2 total)
I just noticed this 2008-2012 difference myself when looking at the max_worker_threads for the TSQL subsystem.
I think sp_verify_subsystems must run whenever SQL agent starts. In 2008, it only inserts into...
November 19, 2012 at 3:01 pm
#1560529
(Pardon the bump, just wanted to leave this here for anyone else who finds this thread.)
I was also seeing this warning, and the function would often take a few seconds...
June 28, 2012 at 10:30 am
#1506740