April 16, 2012 at 12:21 pm
We have a virtual SQl server, 64 bits, 4 GB RAM.
Recently I see in SQL log:
Appdomain4 (mssqlsystemreource.sys[runtime].3) is marked for unload due to memory pressure.
Appdomain4 (mssqlsystemreource.sys[runtime].3) is unloaded.
Appdomain5(mssqlsystemreource.sys[runtime].4) is created.
I see above 3 statement happen once every day.
I know the developer is using spatial data type.
For now we don't see any performance issues.
what does this mean, can I ignore this message?
THanks
April 17, 2012 at 4:02 am
I'm not familiar with this particular error, but I have seen appdomain errors in the past as being caused by the SQL buffer pool taking up all available memory on the server.
Limit the max-memory setting to 2-3 GB to allow 1-2 GB for the O/S and non-buffer-pool memory.
If you haven't changed the default value for max-memory, the SQL buffer pool will take all available memory on the server, starving all other areas of memory.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
April 18, 2012 at 10:34 am
As you told, I reset max memory, I have not seen theat error since yesterday, hopefully it will last.
Thanks,
Any one knows if spatial data load use a lot of memory, and when loading are they using the memory in buffer pool or some other area?
If they use buffer pool, if I set the max memory to prevent it from running out all of memory of server, it will use less memory, so it will load slowly?
I would like to better understand this process.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply