This is a .NET assembly with a PowerShell front end to enable interactive physical-design tuning sessions over SQL Server databases.
Note By installing, copying, or otherwise using this software, you agree to be bound by the terms of its license. Read the license.
To run this software, you’ll need the following:
To install the software, do the following:
- Download and install the .msi file (by default it should install the software in folder C:\Program Files\Microsoft Research\Interactive Physical Design Tuner)
- Open a Powershell window with administrative privileges and enable scripts by executing set-executionpolicy remotesigned
- While in Powershell, navigate to the installation directory and execute the script ./Install-PDT.ps1 (this script would install Microsoft Charts if not already present, register the necessary .dll files in the GAC, and modify the powershell profile to start in the current directory)
- Any subsequent time, execute the script ./Init-PDT.ps1 to load the snapin. For a demo, look inside directory demo/ and execute script ./Start-Demo.ps1
Consider this an alpha release. Although we tested the tool in different environments, the large number of free variables (e.g., operating system, Powershell configuration, SQL Server backend, database instances, etc.) might result in problems under certain scenarios. Please send us feedback if you run into problems or have ideas for improvement or general comments.