Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Unanswered: Objects in Procedure or Data Cache

    I am having some performance issues on my server and wish to track down the particular objects responsible.

    Is there any way of determining which objects are in memory?

    Many thanks.

    Don

  2. #2
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    table "syscacheobjects" in master database, for cache usage.
    setting up a trace in SQL Profiler is also useful

    des

  3. #3
    Join Date
    Oct 2002
    Posts
    3
    Thanks Des,
    It provides some of what I am looking for. I don't seem to find objects of type 'user table' being generated. My SQL Server reports to be using something like 1.4 GB memory from Sysmon. I was hoping that syscacheobjects will shed like on the objects in memory. However, I will continue with the profiler.

    Many thanks once more.

    Don


    Originally posted by DesmondX
    table "syscacheobjects" in master database, for cache usage.
    setting up a trace in SQL Profiler is also useful

    des

  4. #4
    Join Date
    Jun 2003
    Location
    cape town, south africa
    Posts
    102
    an easy way to keep unnecessary stuff out of memory is to run a scheduled "checkpoint" command on each database every few hours, to flush the memory to disk...

    good luck sorting it out...
    des

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •