Posts From April, 2010

-October 2017+
SMTWTFS
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234
  • RSS
  • Add To My MSN
  • Add To Windows Live
  • Add To My Yahoo
  • Add To Google

Statistics

  • Entries (95)
  • Comments (0)

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 - 2017 Fort Worth SQL Server Users Group | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund