Welcome to the first Blog entry of AKAWN LIMITED.


To start the Blog off, there is a useful start-up option  –P which when used with sqlservr.exe, it allows you to specify how many CPU schedulers should be shown to SQL Server.


The number specified can be higher than what you have in your test machine and therefore it is extremely  handy for testing affinity mask settings and/or the effects of multiple schedulers on parallel execution plans when you have limited CPUs available to you.

Leave a Reply