Browse by Tags

• dbcc
• hotfix
• indexes
• max worker threads
• microsoft
• performance
• plan guide
• planning
• resources
• server
• service pack
• services
• sql server
• sqlperf
• system
• tuning

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
15 November 07 08:41 AM | SQL Master | 2 Comments   

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

Filed under: tuning, performance, sql server, microsoft, server, dbcc, testing, best practice, resources, max worker threads, sqlperf, system

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?
30 October 07 08:41 PM | SQL Master | 2 Comments   

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results Read More...

Filed under: performance, sql server, indexes, planning, testing, hotfix, services, best practice, service pack, plan guide