SQL SERVER 2005 64Bit Vs 32 Bit???

[sanjdhiman]

Hi

I need to do some performance benchmarking on 64 vs 32 on SQL server 2005. Is there a good website or sites where I can find this info out which will hopefully show that 64bit is the way forward ??

Thanks

Sanj

 

[Catadmin]

I'm not sure where you can find that sort of thing, unfortunately.

FYI (in case you didn't know) 64bit requires special, more expensive, hardware and there are a lot of client applications that will not work on a Windows 64 bit OS that will work on a 32 bit OS, so you'll want to be careful if you do decide to go to 64 bit because you may lose all your fun tools and other programs.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Microsoft doesn't allow publishing benchmarking of SQL Server 2005.

Here is some unofficial stuff that I did thread183-1170932.

Your results may vary, I'm full of crap, what ever else I need to say that that I don't get in trouble with Microsoft.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Microsoft doesn't allow it? Hmm. I wonder what they're afraid of.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Yeah, I've got no idea. Check the EULAs. All the new ones have that restriction.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[onpnt]

To me it's fairly straight forward why they would not want publications of benchmarks on the db server. There is no way to effectively perform a benchmark on a db server while maintaining a certain controlled environment and standard setup that may be set by the vendor. If i was a vendor (and rich ) I wouldn't want anyone publishing something they hacked up and decided to call a benchmark either. It could/would show negative views (or positive) about the product while not (or probably not) being done in a controlled environment. And you'll never convince me everyone out there knows and is setting up there db server to the exact specifications that are supplied by the vendors. It isn't MS alone that has this restriction either. Oracle will not allow it and I'm sure pretty much all the other big players.

Refer to this article. I recalled reading it awhile ago.

The clause in the EULA

e. Benchmark Testing. You may not disclose the results of any
benchmark test of either the Server Software or Client Software to
any third party without Microsoft's prior written approval.

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[Catadmin]

Nice article. It certainly explains a lot. Thanks, onpnt!



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[onpnt]

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}