I suspect we may just have to configure AWE correctly and let it be for the time being (Unless this is a bad idea?). I feel the server should have SQL reinstalled as 64 bit in order to fully utilise the hardware platform, however it is currently heavily in production this will be no easy task. I suspect that AWE has not been configured at all, and therefore the server will be significantly under-utilised (remembering that the OS is 64 bit) if SQL is simply using a 32bit address space. Task manager reports about 3.5GB memory usage for sqlservr.exe (The server has 16GB physical). Now, that being the case, the question arises about how much memory this '32 bit' install can use. If I do the same checks on a confirmed 64 bit installation, it does give back the expected 64 bit readings, which can only prove that this server in question is only running in 32 bit. However sqlservr.exe is not shown with '* 32' in taskmgr, does anyone know why this is the case, if it is in fact 32 bit as claimed? Despite this, it does seem to be running out of the x86 program files folder. SELECT shows Microsoft SQL Server 2005. I now suspect that it is in fact only 32 bit SQL, however I'd like to verify this. Now, I always thought this second server was Server 2003 圆4 + SQL 2005 圆4 (from what I'd been told), but I now have my doubts about this. While reinstalling SQL on the new Windows installation, I went to another of our DB servers to verify a couple of settings. Recently I was performing an OS upgrade on one of our DB servers, moving from Server 2003 to Server 2008.
0 Comments
Leave a Reply. |