WISdom Advisor

New
  • Published on Jan 27, 2026
  • 6 minute(s) read
Prev Next

Overview

WISdom Advisor is an AI-powered assistant that allows you to query your monitoring data using natural language. Instead of navigating through multiple screens and filters, you can ask questions in plain English and receive instant, data-driven insights from your environment.

What You Can Do

  • Get executive summaries of complex performance data across databases and instances
  • Identify resource bottlenecks and performance issues with natural language queries
  • Receive actionable remediation recommendations based on your specific workload
  • Analyze job schedules, failures, and resource conflicts
  • Understand cost optimization opportunities without manual analysis

Example Questions

  • "Which databases have the highest CPU pressure this week?"
  • "Show me the top 10 most expensive queries by compute cost."
  • "What instances are experiencing memory pressure?"
  • "Are there any blocking issues affecting performance today?"
  • "Which databases are running in SQL 2012 compatibility mode?"

How to Use WISdom Advisor

Accessing WISdom Advisor

There are two ways to access WISdom Advisor:

  1. Global Access: Click the WISdom Advisor button in the upper right corner of any screen to ask questions about your entire environment

  2. Context-Specific Access: Click Ask WISdom buttons on specific pages (Query Statistics, Jobs, etc.) to ask questions relevant to the current screen's data

Asking Questions

  1. Click the WISdom Advisor button or an Ask WISdom button
  2. Type your question in natural language
  3. Review the AI-generated response with insights drawn from your monitoring data
  4. Rate the response using thumbs up/down to help improve accuracy
  5. Ask follow-up questions to dive deeper into specific areas

What Data Can WISdom Advisor Access?

WISdom Advisor currently provides insights from the Performance and Infrastructure modules, including:

  • Query Statistics: Query performance metrics, execution statistics, and cost calculations
  • Blocking Analysis: Blocking and contention issues affecting database performance
  • Server Resources: Host configurations, CPU, memory, disk, and capacity metrics
  • Instance Information: Database engine details, configurations, and resource allocation
  • Cost Optimization: Infrastructure spending and optimization opportunities
  • Inventory: Infrastructure information for hosts, instances, and databases

Writing Effective Questions

Be Specific About Scope

✅ Good:

  • "Show CPU pressure on the Production SQL cluster"
  • "Which databases in the Finance environment have high blocking?"

❌ Less Effective:

  • "Show me CPU"
  • "What's wrong?"

Include Time Frames

✅ Good:

  • "What were the top blocking queries yesterday?"
  • "Show me storage growth over the last 30 days"

❌ Less Effective:

  • "What are the top blocking queries?"
  • "Show me storage"

Ask for Actionable Insights

✅ Good:

  • "What's causing high wait times on DB-PROD-01 and how can I fix it?"
  • "Why are jobs failing on Instance-05 and what should I do?"

❌ Less Effective:

  • "Tell me about DB-PROD-01"
  • "Show me resource-intensive queries on DB-PROD-01."

When to Use WISdom Advisor

Best Uses for WISdom Advisor

  • Quick Executive Summaries: Get instant overviews across multiple instances without manual navigation
  • Exploratory Analysis: When you're not sure where to look for performance issues
  • Root Cause Investigation: Understanding what's causing specific problems
  • Cross-Database Comparisons: Comparing metrics across different time periods or resources
  • Remediation Guidance: Getting recommendations for fixing identified issues

When to Use Traditional Navigation

  • Detailed Drill-Down: Deep exploration of specific metrics with full filtering options
  • Configuration Changes: Modifying alerts, monitoring profiles, or system settings
  • Data Export: Exporting data for external reporting or analysis
  • Visual Analytics: Using detailed charts and visualizations for trend analysis

Privacy and Security

Your Data Stays Isolated

Each WISdom client has a dedicated database tenant in the Fortified Azure environment. WISdom Advisor can only access data within your specific tenant—it is technically impossible for the AI to access data from other WISdom clients.

How WISdom Advisor Works

  • No External Connections: WISdom Advisor uses industry-standard large language models hosted entirely within Fortified's Azure environment. It does not send data to external third-party AI services or connect to the public internet.

  • Tenant-Based Access: The AI engine only has access to your organization's monitoring data stored in your dedicated Azure database tenant.

  • Adaptive Learning: WISdom Advisor adapts to your environment independently, learning your specific workload patterns, database structures, naming conventions, and job schedules without any visibility into other clients' environments.

Query Logging and Feedback

What Gets Logged:
Fortified logs all WISdom Advisor queries and responses for feature improvement and quality assurance. These logs help refine AI accuracy and expand data access capabilities.

Your Feedback Matters:
After each response, you can rate the answer using thumbs up/down buttons. Your ratings are included in the logs and help Fortified improve WISdom Advisor's accuracy and usefulness.

Log Access:

  • Only Fortified personnel have access to query logs
  • Logs are never shared between clients or used for any other purpose
  • Your feedback ratings help improve the AI for all users

Data Security:

  • All data transmission uses TLS encryption
  • All data at rest is encrypted using Azure encryption standards
  • Access to query logs follows the same security protocols as your monitoring data

Current Capabilities and Limitations

What WISdom Advisor Can Do

  • Analyze performance metrics and identify bottlenecks
  • Explain complex data patterns in plain language
  • Provide actionable remediation recommendations
  • Compare metrics across instances, databases, and time periods
  • Explain cost optimization opportunities

Current Limitations

  • Read-Only: WISdom Advisor cannot modify configurations, create alerts, or execute changes—it provides insights and recommendations only
  • UI Access Only: Available exclusively through the WISdom web interface (not available via API)
  • Module Scope: Limited to Performance and Infrastructure modules (Query Statistics, Blocking, Jobs, Server Resources, Cost Data)
  • No External Data: Cannot search external documentation or knowledge bases

Best Practices

Getting the Most Value

  1. Start Broad, Then Narrow: Begin with general questions, then ask follow-up questions for specifics

    • "What are my biggest performance issues?" → "Tell me more about the blocking on DB-PROD-01"

  2. Provide Context: Include relevant details like instance names, time periods, or specific symptoms

    • Instead of "Why is it slow?" ask "Why is query performance slow on DB-Finance during business hours?"

  3. Ask for Explanations: Don't just ask for data—ask WISdom Advisor to interpret it

    • "What's causing the high CPU on Instance-03 and what should I do about it?"

  4. Use Follow-Up Questions: Build on previous answers to drill deeper

    • First: "Show me blocking issues"
    • Follow-up: "Which of these has the highest business impact?"

  5. Rate Responses: Use thumbs up/down to help improve accuracy for everyone

Example Conversations

Performance Investigation:

  • "What are the slowest queries this week?"
  • "Tell me more about the query consuming the most resources"
  • "How can I optimize this query?"

Resource Planning:

  • "Which instances are running out of disk space?"
  • "What's the storage growth rate on my production databases?"
  • "Should I add more capacity to any servers?"

Cost Optimization:

  • "Where am I spending the most on database infrastructure?"
  • "What are my biggest opportunities to reduce costs?"
  • "Which databases could be right-sized to save money?"

Frequently Asked Questions

Does WISdom Advisor access data from other WISdom clients?

No. Each client has a completely isolated database tenant. WISdom Advisor can only access your organization's monitoring data and cannot see data from other WISdom clients under any circumstances.

Can the AI make changes to my environment?

No. WISdom Advisor is read-only and provides insights and recommendations only. It cannot modify configurations, create alerts, execute queries, or make any changes to your systems.

What happens to my queries?

All queries and responses are logged by Fortified for feature improvement and quality assurance. Only Fortified personnel have access to these logs, and they are never shared between clients. Your thumbs up/down ratings are included to help improve accuracy.

How does WISdom Advisor learn about my environment?

WISdom Advisor adapts to your specific environment by analyzing your data patterns, workload characteristics, naming conventions, and operational behaviors. This learning happens independently for each client—your AI never sees data from other WISdom customers.

Is WISdom Advisor available via API?

Not currently. WISdom Advisor is only available through the WISdom web interface.

Does WISdom Advisor connect to the internet?

No. WISdom Advisor operates entirely within Fortified's Azure environment and does not connect to external third-party AI services or the public internet.

How accurate are the recommendations?

WISdom Advisor provides recommendations based on your actual monitoring data and industry best practices. However, every environment is unique—always review recommendations with your specific business requirements and change management procedures in mind. Your feedback (thumbs up/down) helps improve accuracy over time.

Getting Help

Have questions or feedback about WISdom Advisor?

  • Email Support: WISdomSupport@fortified.com
  • Rate Responses: Use thumbs up/down buttons to provide feedback directly in the interface
  • Documentation: Visit docs.fortifiedwisdom.com for additional resources