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 Server table hints – WITH (NOLOCK) best practices
    • SQL Convert Date functions and formats
    • SQL WHILE loop with simple examples
    • SELECT INTO TEMP TABLE statement in SQL Server
    • Overview of SQL RANK functions
    • Understanding the SQL MERGE statement
    • The Table Variable in SQL Server
    • SQL Server functions for converting a String to a Date
    • SQL Boolean Tutorial
    • Implementing Slowly Changing Dimensions (SCDs) in Data Warehouses
    • SQL multiple joins for beginners with examples
    • How to identify and resolve SQL Server Index Fragmentation
    • SQL percentage calculation examples in SQL Server
    • How to UPDATE from a SELECT statement in SQL Server
    • SQL CROSS JOIN with examples
    • How to move SQL database files (MDF and LDF) to another location
    • Understanding the SQL Decimal data type
    • Learn SQL: Naming Conventions

    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