Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?
Detecting Memory Pressure – SQL in Sixty Seconds #186
Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect memory pressure.Â
Snowflake – Query Result from Cache or Disk
Comprehensive Database Performance Health Check, The topic is how to identify on the Snowflake platform if the query result is from cache or disk.
MySQL Performance – 5 Parameters from Config File
I got lots of emails where people wanted to know more about such parameters. Let us discuss 5 Parameters from Config File which can help MySQL Performance.Â
MySQL Performance – Slow Query and innodb_buffer_pool_size
I have helped my clients with MySQL Performance when I know the solution. Let us discuss Slow Query and innodb_buffer_pool_size.Â
SQL SERVER – Dirty Pages vs Clean Pages in Memory
I was asked what is the difference between Dirty Pages and Clean Pages in SQL Server Buffer Memory and which one is better? Let us quickly discuss.
Get Memory Details – SQL in Sixty Seconds #165
My blog post SQL SERVER – 3 Queries to Detect Memory Issues. Lots of people wanted me to create a video on this topic – get memory details.