Querisma

Querisma's eleven capabilities

In three groups: performance, security, visibility.

How Querisma works

Performance

  • Last SQL Bender

    In-flight query rewrite

    Rewrites inefficient queries into optimized versions on the wire, with no application change and no deployment.

    Case study

  • Cache Flash

    Smart query cache

    Pro and above

    Keeps the answers to frequently run queries inside Querisma, so repeated queries never reach the database.

  • Plan Architect

    Execution plan intelligence

    Breaks down complex execution plans, points at the operator that costs you, and suggests the fix.

  • Index Master

    Intelligent index advisor

    Goes past missing index hints: proposes the indexes that pay off against your real workload, and flags the ones that do not.

Security

  • Key Breaker

    SQL injection blocking

    Recognises SQL injection attempts by known attack patterns and blocks them before they reach SQL Server. For each pattern you choose block, alert or allow.

    Security rules: block, alert or allow, per attack signature.Security rules: block, alert or allow, per attack signature.

    Security rules: block, alert or allow, per attack signature.

  • Shield Guardian

    Database firewall

    Blocks requests from suspicious addresses and harmful queries before they reach SQL Server, and shuts the source address after repeated failed logins. This protection is included in every plan. With the anomaly detection add-on it also catches out-of-hours bulk data pulls and anything else that stops looking normal in traffic, timing or volume.

  • Data Sentinel

    Data masking

    Enterprise-only add-on

    Masks sensitive fields such as national ID, phone, e-mail and card numbers in the result set, in real time.

Visibility

  • Observer

    Real-time SQL observability

    Live metrics and logs for every session: who is querying, what, when, and how long it took.

    Live monitor: SQL Server right now; rewindable with DVR.Live monitor: SQL Server right now; rewindable with DVR.

    Live monitor: SQL Server right now; rewindable with DVR.

  • Audit Keeper

    Tamper-evident audit

    Every query captured with full context and chained, so any later change to a record is detected. Server setting changes (configuration audit) and permission changes (access audit) are recorded too.

  • Report Wizard

    AI reporting & analytics

    You build the dashboard once; reports are generated automatically and land in the executive's inbox every morning. Service level (SLA) reports and custom metrics are part of it.

    Report designer: query with SQL, build the dashboard by drag and drop.Report designer: query with SQL, build the dashboard by drag and drop.

    Report designer: query with SQL, build the dashboard by drag and drop.

  • Oracle AI

    AI advisor

    Reads queries, plans, indexes and system behaviour together, then explains what is wrong and what to do about it.

See it on your own traffic

Let's look at which of these capabilities pays off for you, on your own queries.

Request a demo