Correct MAXDOP setting

Question

Correct MAXDOP setting

Viewing 7 posts - 16 through 21 (of 21 total)

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 1

Jeff Moden (7/19/2016)
smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some time fixing unnecessarily resource intensive code. 32GB is pretty small for a 12 processor box running on 64 bit technology.

It always gets me when I see Enterprise Edition SQL Server running on such specs ...

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 2

TheSQLGuru (7/19/2016)
Jeff Moden (7/19/2016)
smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some time fixing unnecessarily resource intensive code. 32GB is pretty small for a 12 processor box running on 64 bit technology.
It always gets me when I see Enterprise Edition SQL Server running on such specs ...

Agreed... Lamborghini with a hamster wheel and a half starved hamster for a motor. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

smthembu Hall of Fame Points: 3464 More actions · Answer 3

I hear you but my problem is that I did mention to powers that be but it has fallen to deaf ears, I have to make mini cooper pull a 20 ton truck

I have requested more RAM up to 64GB since that being a limitation for a VM:angry:

It's better to fail while trying, rather than fail without trying!!!

smthembu Hall of Fame Points: 3464 More actions · Answer 4

Would be great to hear what would be the best specs

It's better to fail while trying, rather than fail without trying!!!

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

Jeff Moden (7/19/2016)
smthembu (7/19/2016)
@Gail, what else to look for?
Can't speak for Gail but my suggestion would be... a small amount of money to at least quadruple memory or spend some time fixing unnecessarily resource intensive code. 32GB is pretty small for a 12 processor box running on 64 bit technology.

That would be my suggestion too.

My desktop (gaming machine, writing and SQL dev) has 32 GB of memory.

And what VM has a guest limit of 64GB of memory?

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 6

smthembu (7/19/2016)
I have requested more RAM up to 64GB since that being a limitation for a VM:angry:

Uh, if your VM software DOES have that limit, it is time to change the VM software!!! Maybe your (rather silly, IMHO) IT staff have set that limit for some (very silly) reason?!? :hehe:

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 7

smthembu (7/19/2016)
I hear you but my problem is that I did mention to powers that be but it has fallen to deaf ears, I have to make mini cooper pull a 20 ton truck
I have requested more RAM up to 64GB since that being a limitation for a VM:angry:

That might be the limitation of SQL Server 2008 Standard Edition but I've never heard of a VM with such a limit. If true, then I'm with the others... time to get a new VM.

Of course, you're being limited by the limited thinking of the people with the purse strings. I've been there (even had to resort to dumpster diving in the past to dig out spare parts) and I feel for you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)