asked on

How to Check How many CPUs are allocated to SQL in SQL 2008 Server?

We use SQL 2008 server running on OS: Windows 2008 R2.

I'm not very familiar with SQL 2008. I've only used older versions.

I need to check the CPU utilization that SQL is using.

We use SQL 2008 server running on OS: Windows 2008 R2.

I'm not very familiar with SQL 2008. I've only used older versions.

I need to check the memory utilization that SQL is using.

how can I Check to see How many CPUs are allocated to SQL in SQL 2008 Server?
Please provide steps.

Thanks!

EugeneZ

start from GUI

Server Configuration How-to Topics
http://msdn.microsoft.com/en-us/library/ms175045(v=sql.100).aspx

How to: View or Change Server Properties (SQL Server Configuration Manager)
http://msdn.microsoft.com/en-US/library/ms190648(v=sql.100).aspx
---

to see setting from code
Setting Server Configuration Options via
system proc sp_configure
http://msdn.microsoft.com/en-us/library/ms189631(v=sql.100).aspx

ASKER CERTIFIED SOLUTION

EugeneZ

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

matrix0511

ASKER

@EugeneZ, when I login to SQL Server Managment Studio, where do I go to find how many CPUs SQL is using. I couldn't find the setps in the links you sent.

I just need to know the simple steps on how to find it from Studio

Thanks

matrix0511

ASKER

Here is a screen print of what my "processers" section looks like from SSMM. From this view how many is SQL using? when I go back and highlight "general" under processers it shows 12.

so I'm confused over how many SQL is using.
CPUs-SQL-Using.docx

EugeneZ

it is "all" by default