hi seniors ,
can any one suggest/tell me the server settings/techniques? so that sql server 2005 could take advantages of all processors powers.becuase i am experencing a lot of spikes during my peak times, during presence of 8 no of 64 bit processor server machine and 64 bit window server 2003.
Note I have enabled AWE and also have maximize the sql server processes priority Up to 13 on windows server 2003.
Regards
The 64-bit version of SQL Server does not use AWE. 64-bit obsoletes that technology.
Anyway, SQL Server should manage its CPU usage perfectly fine on its own. It's possible that a certain query is causing problems. You can use the "SQL Server Profiler" tool to monitor running queries. Its configuration can be adjusted to show only long-running or highly-demanding queries. This can help you identify the problem.
-Ryan / Kardax
|||It is completely normal to see short period of high CPU utilization.Are you seeing a problem other than high CPU? Do you see activity on all the processors?sql
