SQL Server Performance

How to check the performance issue in procedure cache in sql 2000

Discussion in 'Performance Tuning for DBAs' started by DuraiRaj, Jun 20, 2008.

  1. DuraiRaj New Member

    Hi,
    Pls let me know how to identify the performance issues in procedure cache using syscacheobjects.
  2. Luis Martin Moderator

    I don't know exactly what you want.
    You can run
    select * from syscacheobjects
    to find out what do you have there.
    But issues?
    Could you explain a little more?

Share This Page