How to get the allocated CPU for SQL Server?

Question

Post reply

How to get the allocated CPU for SQL Server?

gracey

Ten Centuries

Points: 1306
More actions
December 6, 2012 at 8:34 pm

#285966

How to get the allocated CPU for SQL Server?
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

sanket kokane Hall of Fame Points: 3465 More actions · Answer 1

right click on server connection

>properties

>Processor

-----------------------------------------------------------------------------
संकेत कोकणे

gracey Ten Centuries Points: 1306 More actions · Answer 2

Hi Sanket,

you mean it's the "maximum worker threads:"?

sanket kokane Hall of Fame Points: 3465 More actions · Answer 3

marygrace_laurente23 (12/6/2012)
Hi Sanket,
you mean it's the "maximum worker threads:"?

No, Please check the attachement

-----------------------------------------------------------------------------
संकेत कोकणे

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

What do you mean by 'allocated CPU'?

The CPUs that SQL can use? If so, check the processor options for the affinity. It's all processors unless you set otherwise.

The amount of CPU processing time that SQL has used?

Something else?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass