SQL Server Performance Forum – Threads Archive

A basic question

Hello This might be a basic question. How can find out the number of CPU’s used by the SQL Server. Thanks

---

Check the run_value from the output of the following proc… exec sp_configure ‘max degree of parallelism’
MohammedU.
Moderator
SQL-Server-Performance.com

---

Thank you Mohammed. But for all the servers , its showing me the Value ‘0’ ( Zero). I want the total number of CPU’s present in the Server . Do I need to enable anything . Thanks

---

I think that the following might help: In the Enterprise Manager, right click on the server instance – choose Properties – choose Processor tab.

---

Or run Performance Monitor.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.

---

Thanks for the replies. I have done it accordingly and got the values. Thanks

---

exec sp_configure ‘max degree of parallelism’ returns number of processors used by sql server but I forgot to mention when it returns zero sql uses all processors… To get all processors you can use the following too… exec xp_msver ‘ProcessorCount’
MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>