15 March 2009

DBMS: Performance Baseline (Definitions)

 "A set of metrics gathered during a performance analysis process that forms the basis of a performance tuning methodology." (Marilyn Miller-White et al, "MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance 70-444", 2007)

"A baseline is a known starting point for something. In the context of the MCITP Database Developer certification, it's a known starting point for a server. For example, when creating a performance baseline, we would measure the four core resources of a system: CPU, memory, disk, and network. A performance baseline would take a snapshot of the resources (perhaps every 30 minutes) over a period of about a week. Six months later, another counter log could be created, and by comparing it to the baseline, an administrator can identify what has changed." (Darril Gibson, "MCITP SQL Server 2005 Database Developer All-in-One Exam Guide", 2008)

"A baseline measurement is taken to serve as a point of comparison for subsequent measurement." (Laura Sebastian-Coleman, "Measuring Data Quality for Ongoing Improvement", 2012)

"In the context of AWR, the interval between two AWR snapshots that represent the database operating at an optimal level." (Oracle, "Database SQL Tuning Guide Glossary", 2013)

"The beginning point, based on an evaluation of output over a period of time, used to determine the process parameters prior to any improvement effort; the basis against which change is measured." (ASQ)

"Benchmark used as a reference point" (ITIL)


No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.