Wilfred van Dijk (11/19/2008)
You probably mentioned the "... a significant amout of memory has been paged out ..." errors you'll see in the errorlog.The solution is simple:
1) make sure the Os has enough memory available by defining a min and max memory setting for SQL
2) enable "lock pages in memory"
3) enabling AWE is not necessary in a 64bit environment, this option is ignored (but confusing)
4) DTS doesn't work unless you wrap it in SSIS, there are some compatibility problems you might run into.
Microsoft has a very good list of Items that are not compatible with 64 bit 2005