Post reply

memory usage

  • February 14, 2006 at 2:22 am

    #110985

    Hi,

     

    I am bit confused about DBCC MEMUSAGE

    I executed DBCC MEMUSAGE to get the information what objects are there in the memory and how they are using memory.

    There are some data that doesnt exists in the database for example

    i got a object id that doesnt exists in the sysobjects of the  particular database.

    I want to know what is that and why it exists when we issue the command.

     

  • February 14, 2006 at 6:59 am

    #620658

    Hello Raj,

    What is the version of SQL Server?

    When you run DBCC MemUsage, you will get 5 columns with respect to SQL 2000. Check the database name and object name by running this query.

    select db_name(<dbid> ), object_name(<object_id> )

    you haven't given much information about the object_id which you have referred.

    Thanks and have a nice day!!!


    Lucky

  • February 14, 2006 at 2:24 pm

    #620836

    the object might have been dropped...

     

    Thx,

    Krishnan Kaniapapn

    -Krishnan

  • February 14, 2006 at 9:01 pm

    #620884

    Hi Lucky,

    Thanx for ur reply.

    The version of Sql Server is :

    Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002 14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

    SP4 Installed.

     

    AS u can see by the question that i had got a object id that doesnt exists in the specific database.

    What else information u need about the object.

    Dear Krishnan Kaniapapn,

    Thanx for ur help

    When we execute a query few temp tables are created and dropped as the query completes.

    These object id are the temp table id created by SQL Server on Query Execution.

    from

    Killer

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply