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 PARTITION BY Clause overview
    • SQL Server table hints – WITH (NOLOCK) best practices
    • SQL Convert Date functions and formats
    • SQL Variables: Basics and usage
    • The Table Variable in SQL Server
    • How to identify and resolve SQL Server Index Fragmentation
    • Understanding the SQL MERGE statement
    • How to UPDATE from a SELECT statement in SQL Server
    • Overview of SQL RANK functions
    • SQL CROSS JOIN with examples
    • SELECT INTO TEMP TABLE statement in SQL Server
    • SQL WHILE loop with simple examples
    • Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses
    • SQL multiple joins for beginners with examples
    • Learn SQL: Naming Conventions
    • SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries
    • Understanding the SQL Decimal data type
    • Working with the SQL Server command line (sqlcmd)
    • Recover a lost SA password
    • How to create and configure a linked server in SQL Server Management Studio

    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
    

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