Impact of Disc Types on Database Performance

Databases are continuously migrated to the cloud environment. On the other hand, there are still many requirements to locate the data in a local repository due to legislative and security reasons. Database files are block oriented forming the storage. This paper aims to analyze the impact of disc storage on performance in an on-premise world, pointing to the data themselves, as well as indexes to split the workload into multiple disc-type environments. It provides the methodology for dealing with various storage types and access routes.