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

  • April 7, 2015 at 7:27 am

    #1789185

    edit sp_verify_subsystems in msdb. This inserts the value to subsystems table by multiplying an arbitrary number to the no.of processors. you can manipulate this number to get the desired worker threads

    For powershell, just change 2 to the number you want

    INSERT syssubsystems

    VALUES

    (

    12, N'PowerShell', 14698, @InstRootPath + N'SQLPOWERSHELLSS.DLL', @SQLPSPath, N'PowerShellStart',N'PowerShellEvent',N'PowerShellStop',2

    )