LabVantage supports Oracle and Microsoft SQL Server, two industry-leading database management systems. The database server is the repository for all LabVantage data, including metadata generated from LabVantage Web Page Designer, the user interface configuration tool within LabVantage. This metadata is used to drive the runtime architecture and determine business logic execution.
LabVantage has been designed to do most of its processing on the application server. As a result, the database server is not CPU intensive; rather, it tends to be I/O intensive. Therefore, a high throughput disk sub-system is recommended. When configuring the database server, organizations should consider the number of concurrent users, the amount of historical data, and which database engine will be used. Database connections are pooled by the application server, so database-level connection pooling is typically not required or recommended.