Introduction This topic seems so simple, and so obvious to me, and do not mean to insult anyone’s intelligence. However, it is shocking to me the number of people that I have talked to (running large databases) that are not taking advantage of one of the best performance, and manageability enhancements out there! Think about […]
Tag Archives: Performance
2008 Resource Governor – Does it work?
The resource governor in SQL Server 2008 is a powerful tool to help you gain control over your query runtimes.
Help – My disk performance III
Part III in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database partitioning and compression.
Help – My disk performance II
Part II in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers physical connection, and LUN layout on a SAN.
Help – My disk performance
Part I in a series of discussions about Data Warehouse disk configuration, monitoring, and performance.