|
Home > Archive > MS SQL Server > July 2005 > Exactly how many CPUs does SQL Server use?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Exactly how many CPUs does SQL Server use?
|
|
| Robert Allen 2005-07-19, 3:23 am |
| 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
| |
| Tibor Karaszi 2005-07-19, 3:23 am |
| what 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
>
>
| |
| Kevin3NF 2005-07-19, 11:23 am |
| 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
>
>
| |
| Leythos 2005-07-23, 8:24 pm |
| 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
|
|
|
|
|