December 6, 2012 at 8:34 pm
How to get the allocated CPU for SQL Server?
Thanks.
December 6, 2012 at 10:13 pm
right click on server connection
>properties
>Processor
-----------------------------------------------------------------------------
संकेत कोकणे
December 6, 2012 at 11:10 pm
Hi Sanket,
you mean it's the "maximum worker threads:"?
December 6, 2012 at 11:23 pm
marygrace_laurente23 (12/6/2012)
Hi Sanket,you mean it's the "maximum worker threads:"?
No, Please check the attachement
-----------------------------------------------------------------------------
संकेत कोकणे
December 7, 2012 at 2:51 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy