When You have assigned a task to optimize a database or performance tuning of an application. Then there could be various dimensions to perform this task because slow performance of application could be many more which can not describe on single page but it can be summary in a table like below I found this table that shows database performance and slow running application performance dimension and there activity start procedures.
Performance Dimensions | Percentage Values | Process Strength | Activity Strength | Remarks |
Application Design and Business process | 25.00% | Long Process | Lower priority | Module wise activity. |
Database Schema Design - Logical | 15.00% | Medium | Follow best practices | Required short downtime Module wise activity. |
Database Maintenance | 15.00% | Quick process | Required on OLTP | Short downtime weekly or monthly. |
Indexing | 15.00% | Quick process | Required on OLTP | Short downtime weekly or monthly Module wise activity. |
Server Hardware (CPU/Memory/other) | 12.00% | Medium process | Follow best practices | Long process and dependency on business process infrastructure & organization financial plans. |
Database Physical Layout (file/group) | 7.00% | Medium | Follow best practices | Required short downtime Dependency on all application modules. |
Platform Virtualization vs physical | 6.00% | Medium process | Follow best practices | Long process and dependency on business process infrastructure & organization financial plans. |
IO Subsystem Design/Tuning(RAID ) | 5.00% | Medium process F | ollow best practices | Long process and dependency on business process infrastructure & organization financial plans. |
Thanks for reading
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757