Re: perfmon and memory usage sql2k 32bit EE on w2k3 r2 x64 EE 2-node cluster

1) This is normal and expected. I haven't found a way to get the counters
working when running any edition of 32-bit SQL on a 64-bit host OS.

2) You will need to enable AWE in the SQL instance in order to use more
than 2GB of physical RAM. /PAE and /3GB are unnecessary due to the 64-bit
OS.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"maborg" <marco.boerger@xxxxxxx> wrote in message
news:1152866206.663784.147540@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
hi,

we have a 2-node cluster of sql2k EE 32bit running on w2k3 R2 x64 EE
sp1. so far so good.
it's running apparently fine and also the database works without
troubles. officially this seems to be a supported configuration and we
found others running it in the newsgroups. now to the problems:

1) we can't get any sql server objects in windows performance monitor.
usually we should see them after installing sql server. so what
happened to them? does perfmon on x64 w2k3 have other counter structure
than 32bit sql2k? can we manage to get these counters installed or
activated afterwards? otherwise, what went wrong with our installation?


2) having 4GB and more of ram per node on 32bit w2k and w2k3 we were
used to both activate AWE in sql2k and set all of /PAE /AWE /3GB
windows boot options. now we wonder what to do in our configuration.
does w2k3 x64 work like magic as regard to memory since it is
officially supporting AWE API? is there nothing else to do than
activate AWE in sql2k? or should we better not activate it at all? what
about the /PAE and /3GB? do these simply drop in w2k3 x64 and does
sql2k EE work fine without them? here we really didn't find any help
and since due to problem no. 1 above we can't measure the real memory
use, we have no clue.

thanks,



.

Relevant Pages

  • Re: SQL Server (?) performance issues
    ... I'd suggest that your DBA use the SQL Profiler to trace which specific ... SQL Server MVP ... exact counters are being watched, but we are being told that all the ... all is fine and there is plenty of spare capacity. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Performance Objects (sqlctr80.dll)
    ... I have the same problem with my SQL 2000 server ... - no sign of any performance counters. ... > Make sure the following keys with the value DO EXIST. ...
    (microsoft.public.sqlserver.setup)
  • Re: Wait State Script Output
    ... short on memory and could probably use a faster array for the data. ... How about the disk counters? ... SQL 2000 Performance tuning tips ... > Raid 5 for data, ...
    (microsoft.public.sqlserver.server)
  • RE: The error returned is: The specified counter path could not be
    ... performance log but few counters like processor, logical disk space and SQL ... Server Database Transactions. ...
    (microsoft.public.windows.server.sbs)
  • Re: Perfmon Counters Missing
    ... Usually just restarting the SQL Server will return the counters. ... sure you do not have anything such as perfmon running when you restart. ...
    (microsoft.public.sqlserver.tools)
Loading