RAM
So, I’ll divide readers with this post. Half will marvel at how dumb I am and the other half will be astonished by how simple the solution was.
So, I did a RAM upgrade on our sole server back on April 29th. It didn’t work out very well. Sure, nearly everything was great, but SQL Server 2005 wouldn’t connect to databases and had a list of cryptic error messages.
We have a guy on contract that’s been working with networks for a lot longer than I have been. He came in, put 4 characters in one file, and everything works swell. Go figure.
My initial error was Googling the cryptic SQL error messages, rather than searching by what I did… added RAM. So today I searched for Windows Server 2003 4GB RAM, and I came across Microsoft’s KB 283037. I’m curious now if the /PAE switch is a better one for us to use. Right now I’m not going to mess with it though - it’s working a TON better than it was before.