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 Variables: Basics and usage
    • SQL Convert Date functions and formats
    • The Table Variable in SQL Server
    • Understanding the SQL MERGE statement
    • SQL Server table hints – WITH (NOLOCK) best practices
    • Overview of SQL RANK functions
    • SELECT INTO TEMP TABLE statement in SQL Server
    • Recover a lost SA password
    • SQL CROSS JOIN with examples
    • SQL WHILE loop with simple examples
    • How to identify and resolve SQL Server Index Fragmentation
    • SQL Server functions for converting a String to a Date
    • SQL percentage calculation examples in SQL Server
    • Understanding the SQL Decimal data type
    • Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses
    • SQL Boolean Tutorial
    • SQL multiple joins for beginners with examples
    • How to UPDATE from a SELECT statement in SQL Server
    • Different ways to SQL delete duplicate rows from a SQL Table

    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