[From Redmond Magazine
Have you ever had the feeling that your application was slowed down by SQL Server, but didn't know how to fix the problem?
SQL Server performance management is usually reactive and focused on server health. Database administrators (DBAs) respond to trouble rather than avoiding it in the first place. And visibility is largely restricted to watching the database server, rather than understanding how SQL Server directly affects application users.
The article continues at