SQL Beacon

Categories

JUMP TO ANOTHER FORUM

  1. At the moment when you sync scripts you have to sync them all, some clients may have custom scripts running and this would cause them to be wiped. I would like the ability to sync just 1 script

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  2. I would like to be able to see which clients arent currently using the master scripts, and which scripts are different

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  3. Include warning on Log filter page with special regex characters to avoid

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  4. We should monitor Power Automate for job failures

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  5. We need to change our Security Audit check to not use the default trace, as this is getting erased before 24 hrs and before the check runs.
    we could use SQL Auditing to capture this information as well as other security info

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  6. It would be beneficial if we could alter the Subject (and perhaps the Body) of the emails for Check Failures - this would reduce confusion for staff and clients when they receive the email.

    Example: Check failure for Instance Restart-

    Subject: [CLIENT] [SERVER] SQL Instance has been restarted

    The SqlInstanceHasRestartedCheck could not be performed on SERVER because a Microsoft.SqlServer.Management.Common.ExecutionFailureException occurred. This could be because 'SERVER' does not exist or access is denied. Error(s):
    1) An exception occurred while executing a Transact-SQL statement or batch.
    2) A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. It would be great if we could specify individual checks when adding a maintenance window.

    For example, adding a window for AG alerts at a specific time due to data loads, without needing to increase the AG thresholds.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  8. Could we include an Index Fragmentation check and add the report to the Performance portal?

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  9. Beacon needs to detect stack dumps and alert accordingly.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Just adding for discussion:
    Client had an issue with SSRS becoming unresponsive, but the SSRS Service was still running. Is there a way to check/confirm that the web servers are up and running (ie. check http://.../Reports/Pages).
    Refer to Ticket # 30287 for specific info.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  11. Rather than a generic "The job failed" alert message. I find it extremely helpful to provide the step failure details. This allows a support person with lower SQL Server privileges to assess the failure and make a call on actions to take without wading through SQL Agent Job history.

    We currently have a process in place that pull this out of the sysjobhistory and sysjobactivity tables.

    DECLARE @job_id uniqueidentifier = ''; -- our process gets job id passed in via SQL Agent [JOBID] token

    SELECT
    jHst.[stepname] as [Step Name:]
    , isnull(cast(jHst.[sql
    messageid] as varchar(20)), '') as [Error #:]

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  12. Automate fresh installation of SQL Beacon Agent or Manager to avoid issues introduced with manual installation.

    1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  13. To avoid timeouts when parsing large SQL Server Errorlogs filter the log.

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  14. Implement the ability to Snooze an alert for a specific period eg. a number of hours or until a specified date. The alerts that are snoozed should be shown in the Daily Healthcheck report.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  1 comment  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  15. We should monitor SQL Elastic Agents

    0 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?