When we are talking about performance then we have broad area to discuss, if we are Developer we will think about our Query, if we are DBA then we will think about database level either response time, execution time or real time execution. Performance tuning is the improvement of system performance. This is typically a computer systems. The motivation for such activity is called a performance problem, which can be real or anticipated. Most systems will respond to increased load with some degree of decreasing performance.
Here we will discuss only for SQL query later on will discuss at DBA stand point.
Before we proceed to discuss on performance we have lots of question in mind ,why? what? where ?
why?
If we are writing query then we must think to give output within fraction of seconds or real time so any application which is dependent on SQL transaction query but allow user to work proficiently. If on application screen response time will be too high due to SQL query not performing good in that case user will avoid to use application.
If we have data in TB (Tera byte) and trying to retrieve data this will take time to give result.
so our approach should be like that even we work in huge data response time should be less.
What?
We can achieve our goal by applying multiple concept or approach.
like, indexing, optimize etc.
Where?
This is most critical question where we need to increase performance, some time query approach is excellent but still response time is high.
This can be due to Hardware issues, network issues, DB issues, memory issues.
We must be able to identify the issues before we start working on performance tuning.
------
We welcome all your feed back and input.
No comments:
Post a Comment