Browse by Tags

Max Worker Threads Configuration in SQL Server 2005

In 2005 the default value for this setting has changed from 255 (SQL2k) to 0 (dynamic in SQL2k5). According to various sources, the following table shows the automatically configured number of Max Worker Threads for SQL Servers (2005) with different numbers...

Posted 17 May 2007 06:29 PM by ThePremiers | with no comments

Filed under: Configuration, Max Worker Threads

Search

This Blog

• Home
• About

Tags

• "SQL Server 2005 Service Pack 2"
• Active Directory
• Aggregation Manager
• Analysis Services
• Analysis Services 2005
• Best Parctice
• Best Parctices Analyzer
• Best Practice
• best practices
• BIDS
• BOL
• Books On Line
• BPA
• Business Intelligence Design
• Business Intelligence Development Studio
• comulative update
• Configuration
• Configuration MaxDegreeOfParallelism PFE
• Costum Reports
• CTP
• Cumulative Update
• Custom Reports
• Data Dude
• Data Programmability Blog
• disaster recovery
• disaster recovery options
• DMV
• E-Learning
• Events
• execute
• Hidden Gems
• Hotfix
• JumpStart
• Katmai
• Management Pack
• Max Worker Threads
• MCA
• Microsoft Certified Architect
• Microsoft Certified Architect: Database
• Microsoft Office PerformancePoint Server 2007
• Microsoft Operations Manager
• MOM
• monitoring
• MSXML
• Olap Query Log
• OlapQueryLog
• PAL
• Performance Monitor
• performance Point 2007
• Performance point server
• Performance Studio
• PerformancePoint
• Podcast
• Precision
• Precision Performance
• Profiler
• RML
• Roadshow
• Security
• Service Pack
• Service Pack 2
• SP2
• SQL 2000 SP3
• SQL 2000 SP3a
• SQL blog
• SQL Server 2005
• SQL Server 2005 Performance Troubleshooting
• SQL Server 2005 Service Pack
• SQL Server 2005 Service Pack 2
• SQL Server 2005 SP2
• SQL Server 2008
• SQL Server Clustering
• SQL SERVER DATA SERVICES
• SQL Server Support
• SQL Server Support Lifetimes
• SSAS
• SSAS 2005
• Team Systems For Database Professional
• tempdb
• Tempdb Best Practices
• tips
• Training
• Virtual Labs
• Visual Studio Team Edition for Database Professionals
• webcast
• White Paper

Navigation

• Home
• Blogs
• Forums
• Photos
• Downloads

Archives

• July 2008 (2)
• June 2008 (4)
• May 2008 (1)
• April 2008 (1)
• March 2008 (1)
• February 2008 (5)
• January 2008 (2)
• December 2007 (6)
• November 2007 (6)
• October 2007 (6)
• September 2007 (3)
• August 2007 (5)
• July 2007 (7)
• June 2007 (5)
• May 2007 (6)
• April 2007 (5)
• March 2007 (9)
• February 2007 (1)