Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Joefuss2k
Starting Member
4 Posts |
 Posted - 2013-03-29 : 13:26:24
|
| Hello all. Is there a place in SQL server that I can look to see what SQL is doing to eat up so much memory? I can see the SQLAGENT in my windows processes, but I would like to know why it is using 18 GB of memory. Any help is appreciated, thanks in advance.Joefuss |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-03-30 : 01:21:43
|
| What is max server memory set to? It will use as much memory as you let it.-Chad |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-31 : 02:43:21
|
| If you'd like a more detailed breakdown of how SQL Server is consuming the memory - use the sys.dm_os_memory_objects and sys.dm_os_memory_clerks views - these views will detail what memory objects are SQL Server allocated - use this script - http://www.sqlserver-dba.com/2013/03/memory-objects-allocated-by-sql-server.htmlJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Resources