线程卸载错误 [英] Thread Unload Error

查看:80
本文介绍了线程卸载错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我们在我不太熟悉的SQL Server日志中看到一个错误,并希望她的某个人可以对这个问题有所了解...

 

We are seeing an error in our SQL Server logs I'm not very familiar with, and was hoping someone on her ecould shed some light on the subject...

我在我们的其中一个盒子上安装了SS DBA仪表板.此框是运行SQL Server 2005 64位的64位Windows Server 2003 SP2(应用了累积更新3的Service PAck 2).整个盒子有16GB或RAM和16个处理器.我们有12GB的RAM专用于SQL Server,它是在启动时分配的.

I installed the SS DBA Dashboard on one of our boxes. This box is a 64 bit Windows Server 2003, SP2 running SQL Server 2005 64 bit, Service PAck 2 with Cumulative Update 3 applied. The entire box has 16GB or RAM and 16 processors. We have 12GB of RAM devoted exclusively to SQL Server, which is allocated on start up.

这是我们得到的错误:

2008/08/26 04:55:04,spid147,未知,创建了AppDomain 62(SS_DBA_Dashboard.dbo [runtime] .61).
2008年8月26日04:54:59,spid1s,未知,AppDomain 61(SS_DBA_Dashboard.dbo [runtime] .60)已卸载.
08/26/2008 04:54:59,spid1s,Unknown,AppDomain 61(SS_DBA_Dashboard.dbo [runtime] .60)被标记为由于内存压力而卸载.
08/26/2008 04:49:06, spid91,Unknown,AppDomain 61(SS_DBA_Dashboard.dbo [runtime] .60)已创建.
08/26/2008 04:48:17,spid1s,Unknown,AppDomain 60(SS_DBA_Dashboard.dbo [runtime] .59)已卸载.
08/26/2008 04:48:17,spid1s,Unknown,由于内存压力,AppDomain 60(SS_DBA_Dashboard.dbo [runtime] .59)被标记为要卸载.

Here is the error we're getting:

08/26/2008 04:55:04,spid147,Unknown,AppDomain 62 (SS_DBA_Dashboard.dbo[runtime].61) created.
08/26/2008 04:54:59,spid1s,Unknown,AppDomain 61 (SS_DBA_Dashboard.dbo[runtime].60) unloaded.
08/26/2008 04:54:59,spid1s,Unknown,AppDomain 61 (SS_DBA_Dashboard.dbo[runtime].60) is marked for unload due to memory pressure.
08/26/2008 04:49:06,spid91,Unknown,AppDomain 61 (SS_DBA_Dashboard.dbo[runtime].60) created.
08/26/2008 04:48:17,spid1s,Unknown,AppDomain 60 (SS_DBA_Dashboard.dbo[runtime].59) unloaded.
08/26/2008 04:48:17,spid1s,Unknown,AppDomain 60 (SS_DBA_Dashboard.dbo[runtime].59) is marked for unload due to memory pressure.

这些AppDomain似乎承受某种压力,然后被卸载,然后创建一个新的.每分钟都有一个存储过程在运行...

These AppDomains appear to be under some kind of pressure, then get unloaded, then a new one gets created. There is a stored procedure that runs every minute...

DBA仪表板由一个.dll,两个分散的过程和一个非常小的数据库组成.存储过程每分钟运行一次,并收集有关数据库活动的统计信息.这是应用程序的链接:

The DBA Dashboard consists of one .dll, two sptored procedures and a very small database. The stored procedure gets run every minute and gather stats on database activity. Here's a link to the application:

我一直在阅读并不断遇到这个问题,但是只在32位平台上运行的商店中看到过它.

I've been reading and keep coming across this issue, but have only seen it in relation to shops running on 32 bit platofrms.

我不知道这里的独家新闻,但是我假设它与.Net有某种关系

I have no idea what the scoop is here, but am assuming it's got something to do with .Net somehow

任何见识将不胜感激!

推荐答案

感谢您的发帖!我建议在一个MS论坛中发布您的问题,

Thank you for your post!  I would suggest posting your question in one of the MS Forums,

MSDN论坛 » » <一个class = lnk3> Transact-SQL
MSDN Forums » SQL Server » Transact-SQL


这篇关于线程卸载错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆