7.8/10 (Expert Score)
Product is rated as #10 in category Database

SQL Planner is a professional SQL server monitor and health analysis tool that is designed to pinpoint server bottlenecks and identifies the root cause of server slowness. This tool will provide fast, deep analytical reports that convert complex data into actionable insights, empowering users with the information needed to make informed decisions swiftly. Furthermore, its purview extends to vigilant surveillance against unauthorized logins and unauthorized server alterations through a meticulous auditing process, you will get immediate warnings in case of any anomalies.

SQL Planner also provides the SQL Database backup solution to back up all your SQL Server database hosted on Cloud VM, on-premise, Linux from one place & from Mobile, Tablet, and Laptop having any Operating System. You also can use it to encrypt and compress the native SQL server as well as schedule Backup.

1

SQL Planner Discount Coupon Codes

Coupon Code

Last updated: December 01, 2024Get the best SQL Planner promo code for all products.

No coupon exists!

2

SQL Planner Pro Full Free Download

Giveaway Details
3

How to install SQL Planner on your Windows/ Server?

Instructions

Download and install Microsoft SQL Server Express and SSMS to your computer.
Download the SQL Planner setup file above then extract it, and run the SQLPlannerSetup.exe file to start! You should click on the “Read Instruction First – Install” or “Watch in Youtube” to read their instructions (install ISS, Turn windows feature on or off,…):

Sql Planner Installation
Sql Planner 1

Open SSMS and log in the SQL server by Windows Authentication method:

Sql Planner Connect Sql Server By Windows Authentication
Sql Planner 2

Now you should change the SA account password if you don’t have this information. In the Object Explorer, expand Security and then Logins, double click the SA login:

Sql Planner Change Sql Server Sa Account Password
Sql Planner 3

On the General page, enter the desired password and confirm it => Click OK

Sql Planner Change Sa Account Password
Sql Planner 4

Switch to the Status page, enable the login by SA account as below picture:

Sql Planner Enable Sa Account
Sql Planner 5

Next, you need to change server authentication mode:
– In SQL Server Management Studio (SSMS) Object Explorer, right-click the server, and then select Properties
– On the Security page, under Server authentication, select the new server authentication mode, and then select OK.

Sql Planner Sql Server Enable Login Mode
Sql Planner 6

In Object Explorer, right-click your server, and then select Restart. If SQL Server Agent is running, it must also be restarted.
Go back to SQL Planner, enter the SA account then click “Install” to finish installation:

Sql Planner Success Installation
Sql Planner 7

Access http://localhost/SQLPlanner/ and login with Admin/Admin:

Sql Planner Login Server
Sql Planner 8

Get started!

Sql Planner Get Started
Sql Planner 9

SQL Planner screenshots:

Sql Planner Main Dashboard
Sql Planner 10
Sql Planner Server Analysis
Sql Planner 11
Sql Planner Server Audit Report
Sql Planner 12
Sql Planner Deadlock Summary
Sql Planner 13
4

Main Features

Feature Highlights
  • SQL Planner offers 2 levels of security: fortification of your individual SQL server’s security, and application-level security, which goes the extra mile by encrypting and safeguarding all user credentials.
  • This application allows you to seamlessly connect with the regardless of your location or device (laptop, mobile phone, or PC), granting you the freedom to oversee your SQL server operations comprehensively.
  • The tool harnesses cutting-edge technology to generate swift and profound analytical reports to convert complex data into actionable insights that empower informed decision-making.
  • It can easily manage all tasks of your SQL server including automation of SQL Health Analysis, Monitoring, Alerts, Backup and validation, Index de-fragmentation, Stats maintenance, and Automation.
  • The SQL Health Analysis function will examine performance metrics, system resources, and databases to offer insights into possible optimisation possibilities or areas of concern. It also makes sure that any impending issues are spotted early, allowing you to address them before they become more serious.
  • You may use the Monitoring tool to keep a close eye on your SQL server’s current performance, including CPU consumption, memory usage, query execution times, and disc activity. From that quickly spot any anomalies, bottlenecks, or usage spikes that might affect the server’s effectiveness.
  • The Alerts function in SQL Planner will notify you of any abrupt spikes in resource usage, response times, or any other predefined parameter breaches so you can take prompt action to stop downtime or performance deterioration.
  • You can schedule routine backups using the Backup and Validation tool, and validation procedures assure the integrity of these backups. You may be sure that your data is now reliably verified in addition to being periodically backed up.
5

Technical Details

Product specification
Language SupportEnglish
Money Back Guarantee30-Day
Operating SystemWindows server 2012 or higher or Windows 8, 10, 11 or higher
ShippingRegister code will be sent to your email in minutes
SubscriptionLifetime
Support ServicesEmail, Phone
6

User’s and Editor’s scores

Add your rating
7.8Expert Score
7.5/10

The health server is monitored using SQL Planner, a browser-based SQL server comprehensive monitoring solution. In order to assist the Organisation in saving millions of dollars on Database administration tasks, it will give more than 100 analytics reports with both live and historical data.

Overall
7.9
Functionality
7.8
Ease-of-use
7.5
Customer Support
8
5/5 - (32 votes)

Affiliate Disclosure: Thank you for visiting WinningPC. We want to let you know that some of the links on our website are affiliate links. By clicking on these links and making a purchase, we may receive a small commission. This is at no extra cost to you. Our content, including the guidance we provide on software choices, is created with integrity and based on the practical assessment and feedback from our community of users. We focus on helping you find the best tools to meet your needs, while the affiliate commissions we earn are reinvested into enhancing our platform. We appreciate your support and trust in our recommendations!

Elenor
Elenor

We will be happy to hear your thoughts

Leave a reply

Your total score

WinningPC
Logo
Register New Account