Approved Enterprise Standards for Database Management Systems can be found at:
http://gotsource.ky.gov/dsweb/Get/Document-9358/2400+-+Database+Mnagement+Software.doc
System performance can be directly related to a number of components, including the database. In relation to the database performance, some key criteria are: query response, transactions/period of time, and elapsed time for ETL (extract, transform, and load). Sufficient capacity planning needs to be done during requirements gathering to understand who and how applications are to be used. For this reason, it is essential that proper benchmarking and system testing be conducted before any application is placed into a production environment. For Commonwealth Office of Technology-supported systems, this performance measurement will be performed by the Office of Infrastructure Service’s Database Administrators (DBAs) in conjunction with the Office of Application Development’s Quality Assurance Branch. Agencies with non-COT supported systems are encouraged to perform similar testing on their internally developed or commercially purchased software products before implementation. The Quality Assurance Branch will be available to assist other agencies with these services on request.
For systems in production, individual database performance tuning is the responsibility of the DBA assigned to the application. Additional items to be considered for measurement are application usage, production response time, hardware resource utilization, data dormancy and system user satisfaction. Many of these items can be monitored at the request of the customer or as part of post-implementation as agreed to during the Project Initiation Phase. System and data performance should be revisited if there are any changes in the system functionality or user/transaction volume.