Tags » SQL Performance

SQL SERVER - Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

While talking to one of the attendees after my session at GIDS, I realized that I don’t have much information available on my blog about the usage of one of the fantastic performance tuning tool called Database Engine Tuning Advisor. 402 more words

SQL Authority

SQL SERVER - Using "High Performance" Power Plan for SQL Server

A lot of times, I have seen DBA’s and administrators have their own startup tasks that they perform when rebuilding or bringing a new server online. 377 more words

SQL Authority

Impact of sp_ prefix on stored procedure performance

Naming conventions are integral part of a quality code but sometimes we need to pay additional care while deciding on the naming patterns. There are two type of programmers, one who prefix everything and the other who don’t. 411 more words

Technical

Experiences with #SQLTXPLAIN

I have recently used SQLTXPLAIN to solve a production performance issue. This post is about my experiences with this tool. 658 more words

SQL Knowledge

Random Notes on Direct Path Reads

We have been experiencing performance problems after upgrading to Oracle RDBMS 11.2.0.3 and 11.2.0.4 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