SQL Connection memory usage is growing steadily

  • 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?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply