Issue: SQL connection memory usage is growing steadily (8G after only 2 days). It can keep increasing to use all rest system memory.
System: SQL 2008 R2 on Windows R2 with 64G RAM. Max SQL memory setting: 56G. Both Buffer Cache and Procedure Cache are normal. CPU usage is normal. Average number of user connection 70-100.
Is there a way we can find out the connection memory usage details? Can we release connection memory usage without restart SQL?