Optimizing SQL Server Performance{1}

In this journal article the authors state that many times efficiency and performance are the last criteria considered when designing and developing new applications using a database. Sometimes the application does not display the information requested to the database in a reasonable time or completely fails to display it. The reasons may be related to the application design, but in many cases the DBMS does not return the data quickly enough, due to the non-use of indexes, deficient design of the queries and/or database schema, excessive fragmentation, use of inaccurate statistics, failure to reuse the execution plans or improper use of cursors. The authors then review the objectives that should be considered in order to improve performance of SQL server instances. The most important objectives are: 1) Designing an efficient data schema, 2) Optimizing indexes, stored procedures and transactions, 3) Analyzing execution plans and avoiding recompiling them, 4) Monitoring access to data, 5) Optimizing queries. The authors conclude that optimization is an iterative process and includes identifying bottlenecks, solving them, measuring the impact of changes and reassessing the system from the first step as to determine if satisfactory performance is achieved. They also highlight the fact that a superior performance can be obtained by writing an efficient code at the application level and properly using the design and database development techniques.

Although we didn’t get to go over Chapter 6, this article relates very much to SQL. Chapter 6 doesn’t really go into SQL server performance, but this article gives a good idea about what to consider before you create your database and how to reach an optimum level for its performance.

It took me a while to digest all the information from this article because it was all new to me, but I liked that the article goes into detail about how to improve the performance of SQL server instances. It is definitely beneficial to know these things especially for anyone who works with databases and SQL.

Mercioiu, N., & Vladucu, V. (2010). Improving SQL server performance. Informatica Economica, 14(2), 55-60. Retrieved from http://search.proquest.com/docview/613368167?accountid=10357