How To Install SQL Planner, Requirements

Leave a Comment / SQL Server, SQLPlanner

Software & Hardware Requirement :

  1. Windows Server 2012 or Higher OR Windows 8, 10, 11 or Higher
  2. SSD or Equivalent IO speed disk
  3. 16 GB Memory or Higher (For Trial 6GB is also Ok)
  4. CPU 4 Core or Higher (For Trial 1 Core is also Ok)
  5. Configure IIS service – Please follow instruction here to install : https://youtu.be/LUFWwmfHNlo
  6. SQL Server 2012 Higher to store SQL Planner repository (For Trial SQL Express Free Edition is also Ok)

Permission :

  1. Admin on Host machine where SQL Planner will be installed
  2. SQL Server – Sys Admin or Control Server SQL Server User Credential

Steps to install SQL Planner :

  1. Download SQL Planner setup file from http://mssqlplanner.com/download-product/
  2. Extract from Zip and Run SQLPlanner_Setup.exe
  3. Agree with License Terms and Click Next,
  4. Mention Local SQL Server name and SA Credential for SQL Planner to create its repository database and click install
  5. watch here how https://youtu.be/ipMw72BqXmU

Steps to Create a SQL Server Monitoring Job in SQL Planner

  • Login to  SQL Planner, Default User ID – Admin & Password is Admin , Navigate to Menu > Click Create Monitoring Or Health analysis Job
  • Mention the SQL Server Name and credential (SQL User Sys Admin or with Control Server Permission) 
  • Once connected, specify threshold definition to receive alerts – (we send alert for 60+ Categories but to simplify things only 15 of them are shown in this page, rest are automatic) 
  • Mention user email id who would receive alert notifications, you need to define your DB Email setting and add in SQL Planner setting to send email , else by default it sends you via Elastic Email company API through internet which is third party, We don’t recommend for production users. 

Watch you tube video for instruction here : https://youtu.be/6l7uwFai85w

Uninstall SQL Planner

Login to SQL Planner > On Dashboard Click Server Monitoring > If you see any server listed that are being monitored then click Action and click Delete > this will delete Job and few Extended event from Server.

Steps to Un-install SQL Planner :

  • Download SQL Planner setup file from http://mssqlplanner.com/download-product/
  • Extract from Zip and Run SQLPlanner_Setup.exe
  • Uninstall Tab > Specify SQL Planner repository Host SQL server sysadmin credential and Uninstall.

Leave a Comment

Your email address will not be published. Required fields are marked *