MSSQL How long will data be in cache/buffer
admin How fast is data leving the cache, when it not access again. With this query, you can see how fast data will get expire, and overwritten by new data in…
December 21, 2018
MSSQL: Whitch database used most memory
With this query, you can see whitch database that is using most memory
MSSQL – See buffer hit ratio
Whit this code, you can see how much of query in percent at this moment is reading from the cache/buffer.