Re: Thread Dropped Issue

You should post this either in the SQL server newsgroup or in the CLR newsgroup for more specific help. It looks like there is some scavenging going on which is causing an issue.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Download OWC Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $15.00
Need a free copy of VSTS 2008 w/ MSDN Premium?
http://msmvps.com/blogs/alvin/Default.aspx
-------------------------------------------------------


"A. Robinson" <ARobinson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1D41B6CB-051F-4D1C-9D8F-F63DFE1A2C90@xxxxxxxxxxxxxxxx
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...

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.

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.

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...

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:

http://www.sqlserverexamples.com/v2/Products/tabid/76/Default.aspx

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

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

Any insight would be appreciated!



.

Relevant Pages

  • Thread Dropped Issue
    ... We have 12GB of RAM devoted exclusively to SQL Server, ... pressure. ... The stored procedure gets run every minute and gather stats ... on database activity. ...
    (microsoft.public.dotnet.framework.clr)
  • Thread Loss Issue
    ... We have 12GB of RAM devoted exclusively to SQL Server, ... pressure. ... The stored procedure gets run every minute and gather stats ... on database activity. ...
    (microsoft.public.dotnet.general)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)