Hi Experts, Need small information on CUP allocation in SQL Server 2005 64bit Enterprise edition on windows 2003 64bit Enterprise edition. What is the default allocation of CPU in SQL Server (SSMS--Properties--Processor) and I have a server which is having 16 CPU’s and 90+ of Ram memory, all the CPU’s are configured to SQL Server and the below check boxes are also checked in processor tab. Now my doubt is by allocating all the CPU’S to the SQL Server will it degrade the performance or will it increase as when I see task manager I found my CPU utilization (spikes) are more in peak hours. And virtual memory utilization is also more. One more doubt is if I want to reduce the allocation of CPU in the SSMS—Properties—Processor, on one of my test server which I want to make it equal with one of my prod server, what is the process and without restarting the SQL Server I need to do, as we are going to test some performance on the test server.