SQL Server Performance Forum – Threads Archive
Memory on sqlserver
HiHow do you do to fix dynamic memory ;we have an application oscar who use
512 Megas We have a process of sqlserver who occupied 99% of cpu ;I diminuate dynamicly
the memory and the performance is better What do you advertize ?
Look at sp_configure and max_memory in BOL. Derrick Leggett
You can also use Enterprise Manager by right-click on Server and select Properties, then goto Memory and select Dynamically configure SQL Server memory. You need to restart MSSQLServer service to affect new settings. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks for your answer
But we have diminuate the memory and the problem persist ;Maybe its a problem with
a process ;How do you check up the memory use by process ? Thanks Regards
Contract the PERFMON counter PROCESS and also MEMORY counters. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>