Why Developers should understand SQL Server Performance
There are many reasons why you as a developer should understand SQL Server Performance.
One of the biggest reasons is that, generally, the responsibility of the overall performance of the app is on the shoulders of the application development team and we all know that how much application performance is important for the user experience in today’s time. If our application is slow and unresponsive, or can’t scale to meet the number of users it needs, then the user is not satisfied with the app and looks for an alternative.
The second reason is, as an application developer, we have the view or scope for the whole system, Along with the knowledge of the application code we also have an idea of the use cases for the application and the data being used stored or accessed by the application.
Most important, we have a view of how all of the pieces of the application fit together into different features of our application, and how these features are used by our users. At the time of tuning SQL Statements or creating indexes in our database, it is always good if we understand the larger context of our application such as what the application is trying to do and how it is trying to do it. So our knowledge of how the application works is greatly benefitted in this case.
Finally, there will be no doubt at the times when you need to work closely with the DBA team at your company, this might be to search for an issue from your application, or do some database design work, or any other reason. By better knowing how SQL Server works, you’ll be able to engage or help your DBAs more efficiently. You’ll be able to work together more effectively analyzing problems, and you will better understand what tools are available and how they can help solve these problems.