Limited SQL instances but server still struggling
Recently we came across an issue whereby one of our servers was having terrible memory issues (worse than Dory from Finding Nemo). This should be a simple one, limit the SQL instances, we thought! The setup was a Windows Server 2008 R2 Standard (64-bit) )with 2 SQL instances running, one for each of our main applications. To make things a little more interesting SQL Server 2005 and SQL Server 2008 were in play. This shouldn't be an issue though, limiting the memory is the same process for both versions! Limiting Memory Usage for an SQL Instance Open SQL Server Management Studio Log into the first instance Right-click on the instance name at the top of the Object Explorer and select Properties Select the Memory page from the left-hand menu Enter the size of memory you want to limit your instance to (in MegaBytes) Press OK Repeat steps 1 - 6 for each instance you have configured within your SQL server(s) Now at this point we thought we could sit back, thr...