dual-core server

I'm looking at purchasing a new SQL Server - a Proliant of course. My
research tells me that the new Intel dual-core Xeon is the way to go. I'm
also hearing that the new SAS drives are the new standard, and also slightly
faster than U320 SCSI.
I'm wondering if anyone out there is using either the dual-core cpu or the
SAS drives? If so, are you pleased with their performance? Any issues to
report?
Thanks, AndreI'm using a new AMD Opteron Dual core and I'm very happy with it.
I'm not using SAS drives.
its an "home made" server based on a Tyan motherboard for development usage:
1 dual core; 4Gb; 4 * SATA2 drives; SQL 2005 x64
I'm in a datawarehouse usage; not OLTP;
from some benchmarks; Opterons CPU are better then Xeon CPU for SQL Server
usage (look at the tpc.org site)
in my case, internal benchmark results are excellent
"Andre" <no@.spam.com> wrote in message
news:%23nghNNdLGHA.668@.TK2MSFTNGP11.phx.gbl...
> I'm looking at purchasing a new SQL Server - a Proliant of course. My
> research tells me that the new Intel dual-core Xeon is the way to go. I'm
> also hearing that the new SAS drives are the new standard, and also
> slightly faster than U320 SCSI.
> I'm wondering if anyone out there is using either the dual-core cpu or the
> SAS drives? If so, are you pleased with their performance? Any issues to
> report?
> Thanks, Andre
>|||My personal choice would be DL585 dual-core which uses four-socket AMD
Opteron dual core. With pure SQL processor workloads (i.e. measuring pure
processing power with no storage I/Os), I see excellent scalability from
DL585 single core to DL585 dual core.
Linchi
"Andre" <no@.spam.com> wrote in message
news:%23nghNNdLGHA.668@.TK2MSFTNGP11.phx.gbl...
> I'm looking at purchasing a new SQL Server - a Proliant of course. My
> research tells me that the new Intel dual-core Xeon is the way to go. I'm
> also hearing that the new SAS drives are the new standard, and also
> slightly faster than U320 SCSI.
> I'm wondering if anyone out there is using either the dual-core cpu or the
> SAS drives? If so, are you pleased with their performance? Any issues to
> report?
> Thanks, Andre
>

DTS Vs SSIS

Does anyone has done a research on

1) What is the major difference between DTS & SSIS

2) What all issues need to be taken care of before migrating the DTS to SSIS? (PLs note: - Not just runing the DTS package using the SSIS provided DTS 2000 runtime)

Thanks,

Sanjay

Probably more here than can be answered in a simple post. A simple MSN or Google search yielded much.

Jamie has a series of DTS articles on his blog:

http://blogs.conchango.com/jamiethomson/archive/2006/08/07/4313.aspx

Allan Mitchell did an article about this:

http://www.simple-talk.com/content/print.aspx?article=207

Brian Knight did an article as well:

http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp

And I cover upgrading in my book in fair detail.

HTH

Kirk Haselden
Author "SQL Server Integration Services"

|||Thanks much.