Tracking SQL Server memory usage
-
Hi All, I've come in after the weekend to discover that my SQL Server instance (running some new software we've written) has climbed in memory usage a lot more than I'd expect. I'm checking all of the cursors and XML documents used for leaks, but what I'd really like is a tool to track allocations of resources such as these, to tell me straight out where the problem is. I'm sure this must exist... can someone point me in the right direction? Thanks!
-
Hi All, I've come in after the weekend to discover that my SQL Server instance (running some new software we've written) has climbed in memory usage a lot more than I'd expect. I'm checking all of the cursors and XML documents used for leaks, but what I'd really like is a tool to track allocations of resources such as these, to tell me straight out where the problem is. I'm sure this must exist... can someone point me in the right direction? Thanks!
SQL Server will try to keep everything in memory it can, so thats why you see a memory usage increase. First, to answer your question, run perfmon, and check out the performance counters from the SQLServer:Memory Manger performance object. If you'd like to set a maximum limit for memory usage go into SQL Enterprise Manager, right click your server and go to properties. On the memory tab slide the maximum bar down to a number you are comfortable with. Andy Gaskell, MCSD MCDBA
-
SQL Server will try to keep everything in memory it can, so thats why you see a memory usage increase. First, to answer your question, run perfmon, and check out the performance counters from the SQLServer:Memory Manger performance object. If you'd like to set a maximum limit for memory usage go into SQL Enterprise Manager, right click your server and go to properties. On the memory tab slide the maximum bar down to a number you are comfortable with. Andy Gaskell, MCSD MCDBA