Exactly how many CPUs does SQL Server use?

I've installed an enterprise version of SQL Server on a 4-cpu box but when I
look at the task manager, it seems that most of the time it sticks to one
CPU. I think I set it up properly. Is there something non-obvious I can
check to make sure?
Regardswhat kind of load do you have? There are only certain type of queries that can be spread over
several processors. If you have few, or only one user, and the queries cannot be parallelized, you
will only see one CPU used by SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Robert Allen" <none@.allen.com> wrote in message news:%23T05SVBjFHA.3436@.tk2msftngp13.phx.gbl...
> I've installed an enterprise version of SQL Server on a 4-cpu box but when I
> look at the task manager, it seems that most of the time it sticks to one
> CPU. I think I set it up properly. Is there something non-obvious I can
> check to make sure?
> Regards
>|||Have you looked at the Processor tab of the Server Properties page to see
how many CPUS are selected for the SQL Server to use?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Robert Allen" <none@.allen.com> wrote in message
news:%23T05SVBjFHA.3436@.tk2msftngp13.phx.gbl...
> I've installed an enterprise version of SQL Server on a 4-cpu box but when
> I
> look at the task manager, it seems that most of the time it sticks to one
> CPU. I think I set it up properly. Is there something non-obvious I can
> check to make sure?
> Regards
>|||In article <#T05SVBjFHA.3436@.tk2msftngp13.phx.gbl>, none@.allen.com
says...
> I've installed an enterprise version of SQL Server on a 4-cpu box but when I
> look at the task manager, it seems that most of the time it sticks to one
> CPU. I think I set it up properly. Is there something non-obvious I can
> check to make sure?
Are you aware that it requires a CPU license to run in CPU mode and that
you have to tell it how many CPU's to use?
spam999free@.rrohio.com
remove 999 in order to email me