MS SQL Server - No Of CPU's on a server

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

No Of CPU's on a server - using t-sql.

SQLCatz

2005-08-08, 3:23 am

How do I use t-sql to find out the actual number (physical) of CPU’s running
on a server? On some sites – I found that people used xp_msver.
How do I transfer the output of the call to the SP into a variable that I
can use later?

Cheers
SQLCatz

Mike Epprecht (SQL MVP)

2005-08-08, 3:23 am

http://groups.google.ch/group/micro...60afc5
3d
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"SQLCatz" wrote:

> How do I use t-sql to find out the actual number (physical) of CPU’s running
> on a server? On some sites – I found that people used xp_msver.
> How do I transfer the output of the call to the SP into a variable that I
> can use later?
>
> Cheers
> SQLCatz
>

Sponsored Links