Monday, October 13, 2014

3 Management Data Warehouse

MDW provide the new report that can help us to decide what table and store procedure that will be benefit most from migration to in-memory OLTP.

Start SQL Agent

image

Configure MDW

image

Select the database. If the database does not exist, we can create new one.

image

Select the account .

image

image

image

Configure Data Collection

image

image

image

image

lets generate the load

image

image

After upload the collection data, we can see the transaction performance analysis report.

image

image

This report will help us decide what table would be benefit from In-Memory OLTP.

image

3 comments:

  1. Hey I'm at work surfing around your blog from my new iphone 3gs! Just wanted to say I love reading through your blog and look forward to all your posts! Carry on the superb work!

    Review my page please: 풀싸롱

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates