By Texas Memory Systems | May 14, 2012
Often, additional processing power alone does little or nothing to improve SQL Server performance. This is because the processor, no matter how fast, finds itself constantly waiting on mechanical storage devices for its data. While every other component in the “data chain” is solid state, hard drives are mechanical, relying on physical movement around a magnetic platter to access information.
In the last twenty years, processor speeds have increased at a geometric rate. At the same time, however, conventional storage access times have only improved marginally. The result is a massive performance gap, felt most painfully by database servers, which typically carry out far more I/O transactions than other systems. Super fast processors and massive amounts of bandwidth are often wasted as storage devices take several milliseconds just to access the requested data.
By downloading this document, your details might be provided to the sponsor. If you cannot download the document, please contact us.