Browse by Tags

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

Published 15 November 7 9:41 AM | SSQA.net

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

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

SQL Server Licensing for a quad CPU server, a mystery?

Published 16 August 7 10:9 AM | SSQA.net

Microsoft Licensing methods for SQL Server is always a mystery! Though visiting HOWTOBUY says what type of license choose but nothing much to understand. Scalable link explains bit more than that page. Still I have to search for a quest on how many processor...

Filed under: sql server, performance, microsoft, tuning, processor, quad