This will probably sound like a strange issue but I'm a bit concerned our main database server isn't utilising all of the memory availbable to it. It is a 32-bit Windows 2003 / SQL Server 2005 Standard deployment. It is the only instance running on that box and has the default memory limit settings still applied. The server has 4GB RAM and has AWE turned on. We've had reports of database slowness recently so I went on to the server to take a look. I was surprised to see that the sqlserver.exe process was only using (and has peaked at) 137MB RAM. We have multiple SharePoint farms, several internet facing websites and multiple internal applications all running from this one database server, I would expect it to be using much more RAM than that.
Without knowing a better way to test this I wrote a SQL query that created a temp table and inserted some large strings hundreds of times (I'm actually a developer first and an admin second). On my local box when I ran this query the memory usage went up to nearly 2GB. On all other servers there was a marked increase in memory usage. However on our production server the memory did not change at all - it stayed at approx 137MB (The processor usage went up so it was definitely doing something).
All in all I'm a bit confused by this and was hoping that someone might be able to shed some light on this?