Hi, Could anyone explain me the cycle of Transaction Log file. I came to know that it takes care of redo log as well as Transaction Rollback in SQL...
Hi, Yes, I read it, I understand that completely.., Log cache hit ratio is depicting whether the rollback transactions can find the data in cache...
Hi, Thanks for the link, IF you could let me know the specific solution to improve the log cache hit ratio..that would be really helpful. Thanks,...
Hi, My system shows only 50.12%.. Thanks, sai.
Hi, The counter is log cache hit rato only. give below for your reference. Log Cache Hit Ratio - Percentage of log cache reads satisfied from the...
Hi, I am a Oracle DBA..recently started supporting SQL Server Databases.. Started to learn the basics of sql server. I have few performance...
Separate names with a comma.