SQLShack

Skip to content

  • SQL Server training
  • Español
  • BROKER_EVENTHANDLER

    Description

    For databases using Service Broker. This wait accumulates while a Service Broker is waiting for events to process. As this is an idling wait high values are expected

    Resolved by

    DBAs

    Suggested solutions

    1. Safe to ignore

    Additional research

    Service Broker: Performance and Scalability Techniques
    How to troubleshoot Service Broker problems

    ⇐ Back to index

     

    Follow us!

    Popular

    • SQL Convert Date functions and formats
    • SQL Variables: Basics and usage
    • SQL PARTITION BY Clause overview
    • Different ways to SQL delete duplicate rows from a SQL Table
    • How to UPDATE from a SELECT statement in SQL Server
    • SQL Server functions for converting a String to a Date
    • SELECT INTO TEMP TABLE statement in SQL Server
    • How to backup and restore MySQL databases using the mysqldump command
    • Understanding the SQL MERGE statement
    • SQL WHILE loop with simple examples
    • Overview of SQL RANK functions
    • SQL Server table hints – WITH (NOLOCK) best practices
    • Understanding the SQL Decimal data type
    • SQL CROSS JOIN with examples
    • SQL Lag function overview and examples
    • The Table Variable in SQL Server
    • CASE statement in SQL
    • SQL multiple joins for beginners with examples
    • INSERT INTO SELECT statement overview and examples
    • DELETE CASCADE and UPDATE CASCADE in SQL Server foreign key

    Trending

    • SQL Server Transaction Log Backup, Truncate and Shrink Operations
    • Six different methods to copy tables between databases in SQL Server
    • How to implement error handling in SQL Server
    • Working with the SQL Server command line (sqlcmd)
    • Methods to avoid the SQL divide by zero error
    • Query optimization techniques in SQL Server: tips and tricks
    • How to create and configure a linked server in SQL Server Management Studio
    • SQL replace: How to replace ASCII special characters in SQL Server
    • How to identify slow running queries in SQL Server
    • SQL varchar data type deep dive
    • How to implement array-like functionality in SQL Server
    • All about locking in SQL Server
    • SQL Server stored procedures for beginners
    • Database table partitioning in SQL Server
    • How to drop temp tables in SQL Server
    • How to determine free space and file size for SQL Server databases
    • Using PowerShell to split a string into an array
    • KILL SPID command in SQL Server
    • How to install SQL Server Express edition
    • SQL Union overview, usage and examples

    Foglight banner

    Solutions

    • Read a SQL Server transaction log
    • SQL Server database auditing techniques
    • How to recover SQL Server data from accidental UPDATE and DELETE operations
    • How to quickly search for SQL database data and objects
    • Synchronize SQL Server databases in different remote sources
    • Recover SQL data from a dropped table without backups
    • How to restore specific table(s) from a SQL Server database backup
    • Recover deleted SQL data from transaction logs
    • How to recover SQL Server data from accidental updates without backups
    • Automatically compare and synchronize SQL Server data
    • Open LDF file and view LDF file content
    • Quickly convert SQL code to language-specific client code
    • How to recover a single table from a SQL Server database backup
    • Recover data lost due to a TRUNCATE operation without backups
    • How to recover SQL Server data from accidental DELETE, TRUNCATE and DROP operations
    • Reverting your SQL Server database back to a specific point in time
    • How to create SSIS package documentation
    • Migrate a SQL Server database to a newer version of SQL Server
    • How to restore a SQL Server database backup to an older version of SQL Server
    Helpers and best practices
    • BI performance counters
    • SQL code smells rules
    • SQL Server wait types
    

    © 2023 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy