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 Categorized: SQL Server 2008 (R2)
So this time an article to show you how to move your SQL Server 2008 (r2) system databases. In my case I want to move them to my G-drive (for data) and my F-drive (for logs). Here’s what you need to do.