September 16, 2009 at 7:45 am
How would sql server identify which cpu should this use as I have 4 cpus in my system?
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'max degree of parallelism', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
-lk
September 16, 2009 at 8:02 am
luckysql.kinda (9/16/2009)
How would sql server identify which cpu should this use as I have 4 cpus in my system?sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure 'max degree of parallelism', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
-lk
do you have 4 physical cpu's or cores. to be honest i dont think you can identify initally what cpu it will be using. passing 1 as the option suppresses parallel plan generation
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 16, 2009 at 8:07 am
Is this true that it uses the cpu which has less load?
September 16, 2009 at 8:21 am
luckysql.kinda (9/16/2009)
Is this true that it uses the cpu which has less load?
I have absolutely no idea and I would say no, because that would imply that it would be dynamic and could switch, because the load could change. IF and a big if, you can do similar things if your are using load balancing such as on a web farm where you can delegate resources.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply