Browse by Tags

All Tags » performance » testing (RSS)
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 2005 standard query tuning options - plan guide for performance testing how to?
Published 30 October 7 10:41 PM | SSQA.net
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...
Filed under: , , , , , , , , ,
NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
Published 16 October 7 7:18 AM | SSQA.net
You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and...
Filed under: , , , , , , , , ,
How to gain Disk related performance with few simple steps
Published 30 July 7 9:24 AM | SSQA.net
Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write...
Filed under: , , , , , , , , ,