SQL Server on more than 4 CPUs??



Hi All,
I was browsing for recent articles and saw the attached...

Unisys also released a benchmark TPC-H on a 16 processor windows
machine....

But my question is how well is win 2003/sql server 2005 scaling on
windows now? I've recently upgraded some software I developed to
provide unlimited scalability on unix systems (more processes running
but no more memory)....I understood win2000+ to still be limited to
about 3GB memory though there is ability to request more but colleagues
say it sometimes does not work so well...

I'd be intersted to hear from anyone who is really doing sizable DWs on
win2003 in 32 bit mode....or even if you are doing 64 bit mode it might
be interesting.....

I would like to hear purely on the basis that when my clients ask if
sql server can support them my current answer is that if they need more
than 4 CPUs to support the ETL or query load I am saying they should
probably pass and go for solaris/AIX...


Thanks

Peter Nolan.

http://biz.yahoo.com/prnews/050621/sftu040.html?.v=15

.


Loading