Increasing DB Server I/O


Increasing a DB Server Side Integrated DAS capacity to handle more sessions with similar i/o profiles or increasing the DB Server to handle more data i/o per session requires a systems architecture approach be used that includes the upstream front end processes accessing the DB server. In many legacy cases this means properly configuring the Application Server JDBC connector to handle the right number of sessions and per the expected individual read and write flows expected from each session. These sessions in turn are serving up stream processes which are either middleware or the session UI front end. The latter could be Web Client access to a Web Server, or remote private desktop screen and keyboard erelect client traffic communicating to a virtual machine instance of a guest operating system and set of applications dedicated to each session user.
In any of thee above use cases the DB Server is always bottlenecked by the read and write capacity of the DAS array connected via the PCIe Gen4 or Gen5 bus and the x4/8/16 bus bandwidth of the physical lanes assigned by TurboStorage to service each data flow
Scaling out DB Server I/O Capacity across RAID SAN Array networked TurboStorage Appliances is made easy with the TurboStorage Workload Volume Manager. Workloads can be individually mapped to specific File System, Capacity and Bandwidth configurations and performance information can be published to Application Performance Monitoring Manager Software per volume and Workload .
