FAQ

Q: If I monitor my prod server how much load it will generate on SQL Server?
A: Overall it is always 0.2% or lesser CPU consumption when SQL Planner pulls resource usage data. Our tool is designed to pull only necessary data on specific frequencies: for example, Heartbeat and CPU Usage are pulled at 1-minute intervals, Block and Deadlock at 10-minute intervals, and Storage usage at 6-hour intervals to ensure minimal load.

Q: Will the production server be impacted when analyzing reports in SQL Planner?
A: 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.

Q: If I monitor my prod server how much IO pressure will be generated?
A: It pulls only 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.

Q: Is SQL Planner safe and secure?
A: 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.

Q: Why am I not receiving email notifications for alerts or job status?
A: 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.

Q: Why did you develop this software?
A: 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.

Q: Why do I see the login page after some interval of time?
A: For security reasons, the application automatically logs out when it senses an inactive session. Simply log back in with your credentials to resume activity.

Q: How do you support us?
A: Support is primarily provided via Email. If required and permitted, we can connect via AnyDesk, Zoom, or Teams for screen-sharing assistance.

Q: Do you have a money-back or extended trial plan?
A: Our SQL Planner Product is absolutely Free. We only charge for support or AMC. Please visit our Service Page to purchase a plan. For any customization needs, please discuss them with us before buying.

Q: Can you customize it for my organization?
A: Yes. We can analyze your requirements and implement custom development. Kindly connect with us to discuss.

Q: Can you perform database, ETL, or report development for me?
A: Yes. We can establish an agreement and begin development using an agile process.