Best Performance SQL Server version

Question

Best Performance SQL Server version

Thamizh

Old Hand

Points: 329
More actions
March 2, 2010 at 11:11 pm

#211794

If u have a choice for SQL 2000,2005,2008. Which one make u to choose ?
Whatever the reason is.....

Viewing 15 posts - 1 through 14 (of 14 total)

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

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

Don't understand the question.

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

GSquared SSC Guru Points: 260824 More actions · Answer 2

Are you asking which server version has the best performance?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Thamizh Old Hand Points: 329 More actions · Answer 3

As a DBA, if u have a choice for 2000,2005,2008. Which one make u to choose ?

Whatever the reason .....

Thamizh Old Hand Points: 329 More actions · Answer 4

Not exactly,Already i replied for Gilamonster......

"As a DBA, if u have a choice for 2000,2005,2008. Which one make u to choose ?

Whatever the reason is ....."

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 5

"All the above" depending on what the customer has. It's also not a really good question because of things like the Enterprise Edition of any version is "better" than the other editions but is also more expensive. The correct answer for a new installation would be "the latest version at the highest Edition needed to get the job done".

--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)

Thamizh Old Hand Points: 329 More actions · Answer 6

Thamizh

Old Hand

Points: 329

March 3, 2010 at 10:01 pm

#1128246

....

Thamizh Old Hand Points: 329 More actions · Answer 7

Yes Jeff u r right .Its all about what the customer has but what i want to know is only from the DBA's part.What DBA's like to go blindly...Anyway thank u for ur post.

GSquared SSC Guru Points: 260824 More actions · Answer 8

Jeff Moden (3/3/2010)
"All the above" depending on what the customer has. It's also not a really good question because of things like the Enterprise Edition of any version is "better" than the other editions but is also more expensive. The correct answer for a new installation would be "the latest version at the highest Edition needed to get the job done".

I'd actually modify that to "the lowest edition needed to get the job done". If Express will do the job, why buy Enterprise? But I think that's what you meant in the first place.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

GSquared SSC Guru Points: 260824 More actions · Answer 9

Thamizh (3/3/2010)
As a DBA, if u have a choice for 2000,2005,2008. Which one make u to choose ?
Whatever the reason .....

Everything else being equal, I'd choose 2008, for what I consider obvious reasons. Since that seems obvious to me, I was curious about why you were asking.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 10

GSquared (3/4/2010)
Jeff Moden (3/3/2010)
"All the above" depending on what the customer has. It's also not a really good question because of things like the Enterprise Edition of any version is "better" than the other editions but is also more expensive. The correct answer for a new installation would be "the latest version at the highest Edition needed to get the job done".
I'd actually modify that to "the lowest edition needed to get the job done". If Express will do the job, why buy Enterprise? But I think that's what you meant in the first place.

'zactley 🙂

--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)

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 11

Thamizh (3/3/2010)
Yes Jeff u r right .Its all about what the customer has but what i want to know is only from the DBA's part.What DBA's like to go blindly...Anyway thank u for ur post.

Then, like the other's implied, why wouldn't someone select the latest and greatest? 2k8 has some awesome DBA management tools in it and some optimizer enhancements that make life a bit easier.

Still, it doesn't matter which version you have nor how powerful the machine may be... incorrectly written code can cripple a Cray. 😉

--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)

Paul Bakker SSC Journeyman Points: 95 More actions · Answer 12

The latest version loaded with all servicepacks, but check if your application vendor formal supports this version.

Megistal SSCrazy Eights Points: 8787 More actions · Answer 13

I agree that the question is somewhat very large and may be interpreted in many ways.

The way I did see it at first was (translating "best administrative performance")

"What version will make your life easier for trouble shooting issues and get most of the time the job done quicker"

And I do say that I prefer DMVs than the way sql 2000 worked for gathering metrics.

Again this question can be interpreted in many ways.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 14

I prefer SQL 2000 because I can get more money as a consultant from clients with that platform because not as much information is exposed and thus I can know and do way more than most clients can. 😎

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