HomeSQL Server 2016SQL Server 2016 real-time operational analytics

Comments

SQL Server 2016 real-time operational analytics — 2 Comments

  1. Thanks James. In theory, it’s great, and I hope it is a great success. The one question/concern I’d want to know is how OLTP concurrency is affected if we have a very heavy analytic load. Will OLAP queries launch locks which effectively block OLTP. And if not, will our OLAP query results be changing under our feet as the OLTP insert/updates the core data tables in mid query?

  2. Pingback:Microsoft Connect(); announcements | James Serra's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>