Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blakmk
Starting Member
45 Posts |
 Posted - 2008-05-23 : 05:14:03
|
| I’m having a few issues with a server that keeps grinding to a halt and having frequent system issues requiring a reboor. It is Sql 2000 32 bit enterprise edition running 64 bit 2003 server. Im not sure of the impact of having the AWE switch set for this server because even though it has 8Gb of RAM it is only using 262Mb and is used extensively. It is set to dynamically configure sql server memory with a minuimum memory of 3075 and maximum of 6144Is it worth me removing the AWE option or are there any more tweaks I can make to make this system run more effectively? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-23 : 10:52:24
|
| First of all, Why are you running 32-bit SQL 2000 in 64-bit platform?Check in Performance monitor what exactly is causing it? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-23 : 22:21:26
|
| What's sql2k sp level? Original sp4 has awe related bug, need apply post sp4 hotfix. By the way, you have to check sql memory usage in perfmon. |
|
|
|
blakmk
Starting Member
45 Posts |
Posted - 2008-05-28 : 10:38:22
|
| I didnt set this up unfortunatly and the perfmon counters are missing for some reason.! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2008-05-28 : 11:47:50
|
quote:
Originally posted by blakmk
I didnt set this up unfortunatly and the perfmon counters are missing for some reason.!
1. you need to run atleast sql 2000 sp4 for it to work on 64bit host. we use build 2187 and that gets around the bug sodeep mentioned regarding AWE memory2. since you are running on a 64bit host the 64bit perfmon utility only sees performance counters that correspond to other 64bit software. you need to run the 32bit perfmon located in the windows\syswow64 folder in order to see the SQL 2000 counters. Please read the readme that is includeed with SQL 2000 SP4 as it goes over much of this for you.-ec |
|
|
|
|
|
|
Sql 2000 32 bit running on 64 bit 2003 server with