May 26, 2009 at 8:53 am
Has anyone watched this in the Performance Monitor. I think we have a memory leak because of our use of some CLR procedures.
We are running version 9.0.3050. An Keep getting app unloads in the logs dues to memory pressure. When I look at the server it has
40000 GC Handles and they seem to be growing. I'm guessing that its the issue identified here. http://support.microsoft.com/kb/953497
What's an abnormal amount of Handles?
May 26, 2009 at 4:34 pm
It depends on your workload. That CU might fix your problem, but then again it might not either. What type of server is it; x86, x64? How much memory is in the server? What boot.ini parameters are set for memory; /3gb, /PAE, /USERVA? What are your CLR routines doing, and are they SAFE, EXTERNAL, or UNSAFE?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply