Thread Drop Issue

Discussion in 'ASP General' started by A. Robinson, Aug 28, 2008.

  1. A. Robinson

    A. Robinson Guest

    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!
    A. Robinson, Aug 28, 2008
    #1
    1. Advertising

  2. A. Robinson wrote:
    > 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.
    >


    I'm not sure what this has to do with ASP ... especially classic ASP.
    Perhaps you should post this to a SQL Server group.
    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.
    Bob Barrows [MVP], Aug 28, 2008
    #2
    1. Advertising

  3. A. Robinson

    A. Robinson Guest

    Well....there is no generic .Net newsgroup that I could find, so I thought
    this would be the closest thing.

    Is there a .Net newsgroup?

    "Bob Barrows [MVP]" wrote:

    > A. Robinson wrote:
    > > 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.
    > >

    >
    > I'm not sure what this has to do with ASP ... especially classic ASP.
    > Perhaps you should post this to a SQL Server group.
    > --
    > Microsoft MVP -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >
    >
    A. Robinson, Aug 28, 2008
    #3
  4. I really think you should start with a sql server group, or at least
    with the developer of DBA Dashboard ... a google search just revealed
    Greg Larson as its developer
    (http://www.sql-server-performance.com/software/review/dba_dashboard_p1.
    aspx).

    After looking at that link, I am guessing that this is neither an
    ASP.Net nor a classic ASP (which is the focus of this group) question.
    No, there probably is not a generic .Net group (I assume you searched
    for groups with "dotnet" and/or "framework" in their names ... ), but
    I'm not sure such a group is what you need.

    A. Robinson wrote:
    > Well....there is no generic .Net newsgroup that I could find, so I
    > thought this would be the closest thing.
    >
    > Is there a .Net newsgroup?
    >
    > "Bob Barrows [MVP]" wrote:
    >
    >> A. Robinson wrote:
    >>> 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.
    >>>

    >>
    >> I'm not sure what this has to do with ASP ... especially classic ASP.
    >> Perhaps you should post this to a SQL Server group.
    >> --


    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.
    Bob Barrows [MVP], Aug 28, 2008
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page