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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-12-18 : 05:06:13
|
| when analyzing a trace - how can I figure out what is using more memory (not cpu) to find what's using all the servers memory |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-12-18 : 12:00:02
|
| That's more a job of Perfmon. You can differentiate between procedure cache, and buffer cache, but I am not certain if you can delve into the buffer cache at all more. cutting the procedure cache down can be accomplished by parameterizing any commands that come into the server.What problem are you trying to solve here? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-18 : 22:14:55
|
| DBCC Memorystatus will give you info about data cache,procedure cache and lot more info.you can also see memory consumption report in std reports. |
|
|
|
|
|
|
analyze a trace