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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2010-04-06 : 08:15:09
|
| I'm including an image from Idera Diaganostic Mangager. Server is a Windows 2003 with 4gb of memory. I restarted the sql server service but we still ran into out of memory error. I tried running perfmon and this also failed. Here is the link for the screenshot.[url]http://yfrog.com/1goutofmemj[/url] |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-06 : 08:21:10
|
| When do you get the error? Do you have any other software running on the server?There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2010-04-06 : 08:32:17
|
| Its that AppDomain Error. We had this around 10 months ago but it never resurfaced. Here are some SQL Server Log entriesAppDomain 7 (master.dbo[runtime].6) created.AppDomain 7 (master.dbo[runtime].6) is marked for unload due to memory pressure.AppDomain 7 (master.dbo[runtime].6) unloaded.Yes there is other software loaded but its needed for production. |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-06 : 08:54:15
|
| What's the memory usage of the other software like? Is it possible this software has a memory leak?There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
|
|
|
Out of Memory Error.