I encountered a SQL server with multiple instances that was using a lot of memory. Some of the instances were not limited in their memory usage. I found a nice SQL query to lookup how much memory the instances were actually using.
Posts Tagged: sql server
We’re currently decommissioning our W2K3 servers. Part of the process is to move the datastore to a W2K8R2/SQL2008R2 server. Easy job, documented well. Here’s to another document about it 😎