October 3, 2012 at 2:18 am
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.
Thank you in Advance.
October 3, 2012 at 8:12 am
Is it as dedicated SQL server or any other application running on it?.
Regards
Durai Nagarajan
October 3, 2012 at 10:42 pm
Hi,
Its a dedicated SQL Server machine, no other application is running in that.
October 3, 2012 at 11:54 pm
as it is dedicated sql server why dont you look at what inside SQL server is making the CPU to peak?
Rather sql will release the memory when OS needs it.
Regards
Durai Nagarajan
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply