FAQ
Frequently asked questions
Straight answers about what SQL Planner does, how it deploys, and how teams get started.
20 questions across the platform
SQL Planner is a database and infrastructure operations platform. It brings monitoring, wait-time analysis, multi-engine database management, schema compare, data modeling, Windows Server monitoring, BI & reporting, backup, security and AI-assisted workflows into one self-hosted console.
Depending on the module: SQL Server is deeply supported across monitoring and backup; Wait-Time Analysis covers SQL Server, PostgreSQL, MySQL and Oracle; Database Manager also supports MariaDB, Percona Server and Amazon Aurora. See each product page for the exact matrix.
No. SQL Planner is designed to run in your environment — typically an ASP.NET web console, a Windows collector service and a SQL Server repository you control. Telemetry stays on your network.
Instead of jumping between monitoring, backup, schema, reporting and desktop query tools, your team works from one browser platform with shared context, history and governance.
SQL Server health, live activity, waits, storage, Always On and analytical reports — plus Windows Server CPU, memory, disk and event logs so host and database signals stay connected.
Yes. SQL Planner includes Azure SQL monitoring workflows so cloud-hosted SQL can appear alongside on-premise and VM-based instances in the same operational console.
Windows Server monitoring is part of the SQL Planner suite. It is designed to sit next to SQL Server monitoring so infrastructure and database teams share one source of truth.
Wait-time analysis measures how long sessions spend waiting — and on what. It attributes delay to specific SQL and wait categories (I/O, locking, memory, network and more), ranking work by user impact rather than noisy server-level symptoms.
No. SQL Planner connects over the network and reads the session and statistics views your database already publishes. Nothing is installed on monitored servers, which is why managed cloud services are supported.
Read-only catalog/monitor rights — for example VIEW SERVER STATE on SQL Server, pg_monitor on PostgreSQL, PROCESS plus SELECT on performance_schema for MySQL, and SELECT_CATALOG_ROLE on Oracle. Application table access is not required. Built-in wizards can generate the exact GRANT scripts.
Very little in steady state. Sampling is designed as lightweight indexed reads with buffered writes, and plan capture avoids re-explaining the same statement shape repeatedly.
Yes. It runs in the browser from your SQL Planner server. Team members do not need separate desktop installs for day-to-day querying, object work, dashboards and audit history.
Yes. Saved dashboards can be scheduled with recipient lists, custom subjects and optional thresholds so email only fires when results cross a chosen row count.
Those are primarily single-user desktop tools. SQL Planner Database Manager is multi-user and web-based, with roles, audit trail, scheduled reporting and multi-engine coverage in one console.
In a SQL Server repository that you own, on your own network. No telemetry leaves your environment as part of the core self-hosted architecture.
Optional AI features are designed to avoid sending row data and credentials. Where schema context is shared, SQL Planner can show what will be sent before anything leaves your control — confirm enablement and policy with your deployment.
Typically: web console (IIS / ASP.NET), Windows collector service, and a SQL Server repository database. See Documentation → Getting Started for the operational checklist.
Use Start Free on the download page, or Book a Demo to schedule a live walkthrough tailored to your estate. For pricing and license questions, email support@mssqlplanner.com.
Yes. WebSQL provides installation, annual maintenance and SQL Server professional services (migration, development and performance tuning). Details are on the Pricing page.
All current YouTube product videos are collected on the Product Videos page — covering AI administration, performance tuning, schema compare, wait analysis, dashboards, alerts and installation. New demos are added to the SQL Planner playlist as they ship.
Still have a question?
Book a demo or email support@mssqlplanner.com.
