Home Forums SQL Server 2005 Administering max worker threads RE: max worker threads
ajitgadge
Old Hand
Points: 334
More actions
May 12, 2009 at 4:23 am
#992728
Default value of max working thread is 255. So anything over 255 will slower down the performance.
If your application is OLTP then i would suggest to keep max dop 0 or if OLAP then incraese the value equal to your physical processor.