Installation
FAQ
Load impact, security, email alerts, support, trials and customization — answers to common SQL Planner questions.
3 min readUpdated
Frequently asked questions about monitoring load, security, email, support and services.
If I monitor my prod server, how much load will it generate on SQL Server?
Overall it is always 0.2% or lesser CPU consumption when SQL Planner pulls resource usage data. The tool is designed to pull only necessary data on specific frequencies: for example, Heartbeat and CPU Usage at 1-minute intervals, Block and Deadlock at 10-minute intervals, and Storage usage at 6-hour intervals — to ensure minimal load.
Will the production server be impacted when analyzing reports in SQL Planner?
No. SQL Planner is generally installed on a non-production machine. It pulls production server usage into the SQL Planner database, meaning any analysis load is generated on the SQL Planner machine itself, not the production server.
If I monitor my prod server, how much I/O pressure will be generated?
It pulls only about 100 rows per minute, which is 100 KB at maximum. Wait-related data is pulled at night; the amount of data captured by extended events is generally approximately 30 MB per day.
Is SQL Planner safe and secure?
Yes — it has multiple levels of security:
- SQL Server security: utilizes your existing SQL security protocols
- Application security: all credentials are saved in an encrypted format
- Network control: as a self-hosted solution, the product resides within your own network / firewall
- Certified clean: SQL Planner is certified as 100% clean and secure by Softpedia Lab
Why am I not receiving email notifications for alerts or job status?
If using the default “Send via Application Email Server,” check your spam folder and mark the email as safe. If using public servers (Gmail / Hotmail), verify your SMTP settings. You can also switch to a DB Mail profile. Note: the trial version is limited to 100 emails per day.
Configure Email Alert
Set up and link email alerts with SQL Planner.
Why did you develop this software?
To enable DBAs to manage several SQL Servers from one central location, saving significant time and money. By making it web-based, we provide an “online house” for your SQL Servers — accessible from anywhere you choose.
Why do I see the login page after some interval of time?
For security reasons, the application automatically logs out when it senses an inactive session. Simply log back in with your credentials to resume activity.
How do you support us?
Support is primarily provided via email. If required and permitted, we can connect via AnyDesk, Zoom or Teams for screen-sharing assistance.
Contact support
Reach the SQL Planner team by email or contact form.
Do you have a money-back or extended trial plan?
SQL Planner itself is absolutely free. We only charge for support or AMC. Visit the Pricing / services page to purchase a plan. For any customization needs, please discuss them with us before buying.
Pricing & services
Installation, AMC and professional services.
Can you customize it for my organization?
Yes. We can analyze your requirements and implement custom development. Connect with us to discuss.
Can you perform database, ETL or report development for me?
Yes. We can establish an agreement and begin development using an agile process.
