Monday, October 13, 2014

0 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

0 comments:

Post a Comment

 

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