1
kudos
spam Kudos Remove

SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf
published 372 days, 3 minutes ago posted by sasa 377 days, 28 minutes ago
Monday, May 16, 2011 11:36:18 AM GMT Wednesday, May 11, 2011 11:11:36 AM GMT
SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf
When you are dealing with multi-instances and multiple databases then handling server resources is essential. By default every instance of SQL Server runs as a seperate system process, in terms of memory. In such cases each instance will need to handle concurrent requests from the applications and that instance need to start a thread on operating system is created which is then allocated to specific CPU. The distribution of threads and CPUs is managed automatically by the operating system and SQL...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: Best Practices, cpu, DBA, i/o, Maintenance, max worker threads, Memory, package, Performance, performance monitoring, pressure, SQL Server

No comments yet, be the first one to post comment.

To post your comment please login or signup