Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

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...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 10 2011
Filed under: Filed under: sql server, package, performance, memory, dba, i/o, best practices, maintenance, cpu, max worker threads, performance monitoring, pressure
Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 24 2010
Filed under: Filed under: sql server, performance, dba, query, best practice, parallel execution, max worker threads, numa, benchmarking, performance monitoring, latches, maxdop, threads
If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Nov 15 2007
Filed under: Filed under: sql server, performance, microsoft, server, tuning, dbcc, system, best practice, testing, resources, sqlperf, max worker threads

Page 1 of 1 (3 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?