Tags » SQL Performance

Random Notes on Direct Path Reads

We have been experiencing performance problems after upgrading to Oracle RDBMS and due to high Direct Path Read events. This post is a selection of MOS documents that could be relevant to our problems. 570 more words

Oracle RDBMS 11


In a store procedure that has loops or doesn’t have much output, setting ‘NOCOUNT ON’ will boost performance, as it wouldn’t send the count of rows affected to the client. 9 more words

SQL SERVER - 8 Performance Related Articles on Logical Reads

Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subject of SQL Server Performance. 556 more words

SQL Authority

SQL SERVER - Configuration and Performance of SQL Server is Now Easy to Master

This is one of the toughest topics to address, and I am always looking at new tools that can help me learn and understand SQL Server better. 1,392 more words

SQL Authority

SQL SERVER - Year 2014 Reflections by Tim Radney - Notes from the Field #060

[Notes from Pinal]: New Year’s Resolutions is a funny word. Everybody makes it on January 1st but breaks it in very few days. I used to make resolutions too, but for a while, I have stopped this practice. 672 more words

SQL Authority