Performance Dashboard

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  July 8, 2011 at 10:46 am

  #244118

  I am just wondering if anyone can explain the difference in the cache hit ratios displayed on the main page of performance dashboard report via management studio. There are two parts of the cache hit ratio report, one for user requests and one for user sessions.

  I believe I know what user requests is detailing, but what does user sessions report on. I have had a look at the procs the dashboard uses but am still a little confused, maybe having a senior moment.

  Andrew

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  July 8, 2011 at 11:05 am

  #1350527

  Sessions refers to users connected during that time-frame to the database.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events