When the Microsoft network security team needed to scale its data store to 90 terabytes, while increasing already strained data loading beyond 1 terabyte a day and improving query performance, it turned to Microsoft® SQL Server® 2008 R2 Parallel Data Warehouse. Parallel Data Warehouse enables large tables to be spread across multiple physical nodes. Each node has dedicated CPU, memory, and storage, and each runs its own instance of SQL Server. The resulting computing power enables the team to process up to 4 terabytes of new information per day into its data warehouse. The team has seen a twentyfold improvement in query performance as a result.
So that’s the blurb – you can find the full story and watch the video here.