Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Server Agent Powershell Subsystem with only 2 worker threads RE: SQL Server Agent Powershell Subsystem with only 2 worker threads
Jeffrey.Simmons
SSC Enthusiast
Points: 126
More actions
November 7, 2012 at 4:56 pm
#1556973
I have been trying to change this in SQL 2012. Every time I change the value for PowerShell in the syssubsystems table when I restart the SQL agent it is set back to 2. SQL 2008R2 persisted this change. Anyone been able to change it in 2012?