But no matter what you do to the database, none of it makes any difference if your end users are not obtaining the performance they expect. In the end, the only true way to measure database efficiency is to talk to your end users. Are they happy with the database performance? If not, which aspects of the application are performing poorly in their opinion? I can write scripts all day long which give me a number and make a decision on that number on how well the database is performing. But if the end users are not happy, my number and its breaking point do not mean anything.