User:Sohum2011

 Performance Tuning

In general, performance tuning is to make the most advantage of the system to the users, consistence and reliable. There are several tools for performance tuning. It allows us to monitor and regulate to increase its performance. “Hence it will enable the system to be on the same speed as the business is conducted and boost hardware usage.” These days, there are many tools for performance tuning. It allows to monitor and regulate to increase its performance. Hence it will enable the system to be on the same speed as the business is conducted and boost hardware usage.

Performance tuning is essential because it helps in extenuating the upgrade to uncompromising business executives who are considering for real return on their investment for infrastructure projects. There are numerous factors affecting performance tuning. According to Dewald, Baya and Kline, Kevin in their article about “Application Performance Tuning”, mentioned that “network topology and throughput, server hardware configuration (for database and web servers), front-end application code developed in Active Server Pages, Visual Basic, C++, PowerBuilder, Cold Fusion, or other languages, middle-tier components, typically written in Visual Basic or C++, database code, typically developed in T-SQL or PL-SQL, SQL Server (or other RDBMS) configuration settings, logical and physical database design, operating system settings, client hardware, overall application architecture, and any combination of the items above” might be the factors affecting performance tuning.

“Performance tuning is [boundless] task for DBA”. There could be several causes of this problem such as poorly designed applications and database schemas etc. First and foremost, it is necessary to identify the problem area and what hardware and network are used before conducting performance tuning. So that it can eliminate the problem. Then only it can give optimum results on investments and scalability. With the use of database resources, clients get the maximum benefit from performance tuning such as increase return on investment. It also reduces the need of systems upgrade along with database administration if tuning is properly done.

References:

1.Chan. I., (2008). Performance Tuning Guide10g Release 2 (10.2), Oracle Corporation 2.Choy, V., & Miler, C. (2011). Performance Tuning, Retrieved March 31, 2012, from http://confluence.atlassian.com 3.Dewald, B., & Klin, K. (2002). Factors Affecting Application Performance, Retrieved April 26, 2012 from http://www.informit.com 4.Larock, T., (2012). The 6 Performance Tuning Mistakes You Don’t want to Make Retrieved April 25, 2012 from http://thomaslarock.com 5.Lau, H., Microsoft SQL Server 7.0 Performance Tuning Guide, Retrieved April 24, 2012, from http://msdn.microsoft.com 6.Nelson, M., & Shukla, S. (2011). Performance Tuning for Oracle Business Process Management Suite 10g, Oracle Corporation 7.Oracle Base, Performance Tuning Enhancements in Oracle Database 10g, Retrieved April 1, 2012, from http://www.oracle-base.com