if more than 10000 txns are coming than that should go to CPU2.

Question

Post reply

if more than 10000 txns are coming than that should go to CPU2.

forsqlserver

SSCoach

Points: 18902
More actions
December 9, 2011 at 3:51 am

#249396

I have sql server 2008 R2.I have 2 cpu in server I want to set it like this that if more than 10000 txns are coming than that should go to CPU2.
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

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

Pradyothana Shastry SSCertifiable Points: 5211 More actions · Answer 1

set maxdop

http://www.msqlserver.com/2011/08/differene-between-affinity-mask-and-max.html

- Pradyothana http://www.msqlserver.com

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

SQL balances transactions of the available CPUs. There's nothing you need to do for that.

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

forsqlserver SSCoach Points: 18902 More actions · Answer 3

After SQL Server instalation we need to set some performance tuning steps what are that?

Thanks

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

Can you be a little more specific?

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

forsqlserver SSCoach Points: 18902 More actions · Answer 5

forsqlserver

SSCoach

Points: 18902

December 9, 2011 at 4:54 am

#1419216

The post installation steps in short?

Thanks

Ant-Green SSC Guru Points: 113507 More actions · Answer 6

i believe google might be broke today

some post installation steps

click here[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

GilaMonster (12/9/2011)
Can you be a little more specific?

Can't be less specific, so that would be a yes :hehe:

/joke.