how to verify number of CPUs?

Good Day All,
I was wondering if there is a way, with in SQL 2000 & 20005, to
find out the number of physical CPUs? I don't care about multi-core
or hyper-threading only the number of physical CPUs.
Thanks,
JD
You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
will have to find out from an external utility through xp_cmdshell or
sp_oa's.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
|||Thank You Jason.
On Apr 9, 11:13 am, "Jason Massie" <jason**R3mov...@.statisticsio.com>
wrote:[vbcol=seagreen]
> You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
> will have to find out from an external utility through xp_cmdshell or
> sp_oa's.
> --
> Jason Massie
> Web:http://statisticsio.com
> RSS:http://feeds.feedburner.com/statisticsio
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>
|||You can also try
EXEC xp_msver 'ProcessorCount'
This works with either SQL 2000 or SQL 2005.
Randy Dyess
Blog: http://blogs.solidq.com/EN/rdyess/default.aspx
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
>
|||Is this count showing physical CPUs or is counting CPU CORES?
I ask again because my Server guys are telling me my machine has 2
quad core cpus. sp_msver shows me 8.
thanks
On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:[vbcol=seagreen]
> You can also try
> EXEC xp_msver 'ProcessorCount'
> This works with either SQL 2000 or SQL 2005.
> Randy Dyess
> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>
|||Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> Is this count showing physical CPUs or is counting CPU CORES?
> I ask again because my Server guys are telling me my machine has 2
> quad core cpus. sp_msver shows me 8.
> thanks
>
> On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>
|||Thanks Tibor.
So back to my original post - is there a way to count only the
PHYSICAL CPUs via SQL Server?
Thanks much
On Apr 10, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>
>
>
>
>
|||I believe Intel has some utility for this. I doubt you find anything exposed in SQL Server to do
this...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> Thanks Tibor.
> So back to my original post - is there a way to count only the
> PHYSICAL CPUs via SQL Server?
> Thanks much
> On Apr 10, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>
|||Sorry, misunderstood that you only wanted the number of sockets and chips
being used and not physical cores.
Tibor is right, SQL Server does not have anything to tell you the number of
sockets that are being used versus the number physical cores or logical
cores.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
>I believe Intel has some utility for this. I doubt you find anything
>exposed in SQL Server to do this...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
>