Direct Path Reads Solution Explained:
So, how do you solve the “ direct path reads ” problem (where the same data is being constantly re-read from disk)? There are a couple of suggestions.
I recommend that the first solution to this problem is to make sure that your system has sufficient memory for buffer cache. If AMM (Automatic Memory Management) or ASMM (Automatic Shared Memory Management) is used, make sure to set the floor for the buffer cache by setting db_cache_size.
You can experiment by setting event 10949 at the session level. If this provides the solution you are looking for, you can see if it helps or hurts at the system level. Never make changes to your system without testing thoroughly.
The importance of SQL Server Performance Baselines No one loves to hear they have performance problems, especially when it comes to their production SQL Server databases. If a database performance problem should occur knowing where…