The AMR tool analyzes usage data that has been collected in the Management Data Warehouse. Therefore before you use this tool you will need to set up the Management Data Warehouse and turn on the “Transaction Performance Collection Sets” of data collectors. The transaction performance collector in SQL Server Management Studio helps you evaluate if In-Memory OLTP will improve your database application’s performance. The transaction performance analysis report also indicates how much work you must do to enable In-Memory OLTP in your application.
After you identify a disk-based table to port to In-Memory OLTP, you can use the Memory Optimization Advisor, to help you migrate the table. Similarly, the Native Compilation Advisor will help you port a stored procedure to a natively compiled stored procedure. Generate transaction performance analysis reports to identify performance-critical tables and stored procedures. Right click Data Collection and select Tasks and then Configure Management Data Warehouse. The Configure Management Data Warehouse Wizard begins.Ĭlick Next to select the database that will act as the Management Data Warehouse.Ĭlick New to create a new database to hold the profile data. After you finish creating the database, click Next in the wizard. The next step in the wizard lets you add users and logins.
0 kommentar(er)
