Posts From April, 2010

-March 2024+
SMTWTFS
252627282912
3456789
10111213141516
17181920212223
24252627282930
31123456
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (106)
  • Comments (0)

Archives

Apr 21, 2010 Jason Massie Running Mixed Workloads on SQL Server 

Sunday, April 18, 2010 8:21:00 AM Categories: Meeting

 

Those of you who have had the privilege to hear MVP Jason Massie speak know the surprising new twists and depths he brings to a topic. Check out his blog: http://statisticsio.com/  And come check him out this Wednesday. 

 

 

In an ideal world, you can separate your OLTP traffic and reporting so the databases can be optimized for their respective workloads. In the real world, this is not always an option. Business requirements may require real time data which means reporting off of the OLTP environment. We will first look at the shortcomings of different reporting solutions. We will then look at features that help a mixed workloads play nicely together. Some of these features include filtered indexes, indexes views, persisted computed columns, data compression, resource governor, partitioning and others. We will also touch on database design concepts that can help mixed workloads and leave you with topics to research further so you master the juggling act that is mixed workloads

Site Map | Printable View | © 2008 - 2024 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund