Managed to manage that Managed Instance

Turns out Managed Instance needs some tweaks.

See Martin?

Replay now supports redirecting commands to a different database.
This is achieved by specifying a "DatabaseMap" property in the .json file, like this:

{
    "__type": "ReplayConsumer",
    "ConnectionInfo": {
        "ServerName": "somedatabase.database.windows.net",
        "DatabaseName": "mario",
        "UserName": "itsame",
        "Password": "itsamario"
    },
    "DatabaseMap": {
        "Mario": "Luigi"
        "Peach": "Bowser"
    }
}

In this case, all commands originally captured on database "Mario" will be replayed on database "Luigi" and all command from database "Peach" will be replayed on db "Bowser".

Setup is as setup does

WorkloadTools is now installed with a .exe setup.
This allows two things:

• You now have a nice UI for the setup! Well, you have a UI. Nice will come next.
• WorkloadTools can redistribute prerequisite packages, like Microsoft Visual C++ 2013. It is an old version, but it is referenced by Microsoft.SqlServer.XEvent.Linq.dll and there is nothing I can do about it.

ConvertWorkload is real

Fixes DLL and binding redirects hell for ConvertWorkload. Now it uses LocalDB to convert the workload from trace and / or xe.

Spaghetti is as spaghetti does

Spaghettidba does spaghetti code, but at least he takes the time to release a couple of fixes here and there.
In this release we got a lot of synchronization issues fixed.

• the replay taking forever has been fixed
• reading events from an extended events file now works correctly (it used to skip some events)
• reading events from XE streaming has also been fixed
• the output has been made less verbose
• bigger better faster stronger

Milli to Micro

Keeps microseconds end to end, from collection to display

Lipstick

A lot of visual improvements

• Double click on query text open the query in SSMS or the associated program
• Connection editing with F8
• Server name and database name get copied to benchmark fields when editing connection info
• Mouse wheel scrolling disabled on charts
• Zooming charts also filters the data in the Queries tab

Multivalued filters enhancements

Now multivalued filters support NOT syntax.
Example:

"DatabaseFilter": ["master","model","^tempdb"]

means "all databases with name master, model but NOT tempdb (which is effectively, master and model)

"DatabaseFilter": ["^master","^model","^tempdb"]

means "all databases except master model and tempdb

New feature: WorkloadViewer pre-aggreagates the intervals when the capture is very big.
500 intervals (roughly 8 hours) gets preaggregation every 15 minutes
1000 intervals (roughly 16 hours) gets preaggregation every 30 minutes
1000 intervals (roughly 32 hours) gets preaggregation every 60 minutes

Spaghetti does spaghetti code

More bug fixes for custom events raised during replay (timeout/error)

JSON is evil

Fixed some errors in JSON parsing.