Page History
...
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance list, choose the instance you want to analyze.
- On the Association controls in the Association area, click Latch Events. View the latch events listed in the Association area. Observe to which latch group an event belongs.
Compare the event in one latch group to an event in a different latch group to observe how much time each wait event spent in the SQL Server. - Drill down on a latch event entity and observe its performance over time.
- You can continue your analysis by viewing the hit ratio in the Memory (Buffer Pools) view. If the hit ratio is below 99% consider adding RAM to the SQL Server. If the hit ratio exceeds 99%, consider improving the speed of your I/O system.