July 8, 2011 at 10:46 am
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
July 8, 2011 at 11:05 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply