The code executing against the database engine is only the first step in ensuring maximum performance. Optimized code and use of proper execution hints is important. Equally important is the physical system design, including physical hardware, drive partitions, system database configuration (mainly tempdb) and placement of .mdb and .log file. These are critical factors in ensuring a system's maximum performance and throughput. Achieving an optimum hardware configuration to allow for maximum throughput and load balancing is just as important as the code written directly against the database engine.
Genesis Data Solutions has consulted with clients to build out data-warehouse and reporting servers from the ground up. We have also worked in the blade center/Hyper-V environment and are familiar with the Azure Cloud Platform. Let us manage your data infrastructure!