How Much Memory Does SQL Server Need?


I know it's now become a cliche joke amongst DBAs and SQL Server users over the years, but it's become that way for a reason.

Outside of writing queries, stored procedures and the like, I don't have much to do with SQL Server administration in my day-to-day. However, today I had a reason look at the SQL Server itself to check on an issue. This is the server that houses the SQL Server backend for our BizTalk Cluster, to be honest, I didn't know much about the specs of it until now.

Well apparently it has 64GB of Memory...and SQL Server isn't shy about using it all:


I have nothing more today, except this little gem that took me by surprise. It may just be that I haven't been exposed to big servers very often, but I thought it was neat.