benfit of 64bit windows os for sql 2000

I been reading quite a bit of documentation and am somewhat confused as to
whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQL
to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
specific settings but have found that SQL needs more memory. We cannot run
64bit SQL due to our application not supporting it. I understand that SQL
2000 will run under WOW on Win2K3 but will this truely offer us any better
performance?The answer is, 'it depends.' Whether or not running SQL2000 SP4 on Windows
Server 2003 x64 edition will give you any performance benefit truly depends
on the characteristics of your workloads. You have to test your app to tell;
I don't know a better way than actually testing.
It's very hard to predict how your specific app will behave in this
configuration from whatever you may read in general whitepapers.
Linchi
"Brian" wrote:
> I been reading quite a bit of documentation and am somewhat confused as to
> whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
> currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQL
> to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
> specific settings but have found that SQL needs more memory. We cannot run
> 64bit SQL due to our application not supporting it. I understand that SQL
> 2000 will run under WOW on Win2K3 but will this truely offer us any better
> performance?|||Thanks. I guess its time for some real world testing.
"Linchi Shea" wrote:
> The answer is, 'it depends.' Whether or not running SQL2000 SP4 on Windows
> Server 2003 x64 edition will give you any performance benefit truly depends
> on the characteristics of your workloads. You have to test your app to tell;
> I don't know a better way than actually testing.
> It's very hard to predict how your specific app will behave in this
> configuration from whatever you may read in general whitepapers.
> Linchi
> "Brian" wrote:
> > I been reading quite a bit of documentation and am somewhat confused as to
> > whether or not running SQL 2000 on 64bit Win2k3 is truly beneficial. We
> > currently run SQL 2000 on Win2k with 8 Gb mem, PAE enabled and configured SQL
> > to use 6 GB via AWE. Performance needs to be better. We've tweaked some SQL
> > specific settings but have found that SQL needs more memory. We cannot run
> > 64bit SQL due to our application not supporting it. I understand that SQL
> > 2000 will run under WOW on Win2K3 but will this truely offer us any better
> > performance?