Tag Archives: Performance

Warehouse Design Tip / Partitioning

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 […]

1 Comment Continue Reading →

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.

1 Comment Continue Reading →

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.

2 Comments Continue Reading →

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.

Leave a Comment Continue Reading →

Help – My disk performance

Part I in a series of discussions about Data Warehouse disk configuration, monitoring, and performance.

8 Comments Continue Reading →