Share on Facebook Tweet on Twitter Share on LinkedIn Share by email
Interactive Physical-Design Tuner

This is a .NET assembly with a PowerShell front end to enable interactive physical-design tuning sessions over SQL Server databases.


File NameIPDT.msi
Date Published30 August 2010
Download Size0.31 MB

Note By installing, copying, or otherwise using this software, you agree to be bound by the terms of its license. Read the license.

System Requirements

To run this software, you’ll need the following:

  • Windows Powershell v2.0 (comes preinstalled in Windows 7, or can be download here)
  • Microsoft SQL Server 2008 or later (any SKU works, including express)

Installation Instructions

To install the software, do the following:

  1. Download and install the .msi file (by default it should install the software in folder C:\Program Files\Microsoft Research\Interactive Physical Design Tuner)
  2. Open a Powershell window with administrative privileges and enable scripts by executing set-executionpolicy remotesigned
  3. 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)
  4. 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

Project Page


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.