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!

    ApexSQL Audit Lab

    Popular

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

    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

    ApexSQL Audit Lab

    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

    Categories and tips

    • ►Auditing and compliance (50)
      • Auditing (40)
      • Data classification (1)
      • Data masking (9)
    • Azure (308)
    • Azure Data Studio (46)
    • Backup and restore (108)
    • ►Business Intelligence (486)
      • Analysis Services (SSAS) (47)
      • Biml (10)
      • Data Mining (14)
      • Data Quality Services (4)
      • Data Tools (SSDT) (13)
      • Data Warehouse (17)
      • Excel (20)
      • General (39)
      • Integration Services (SSIS) (125)
      • Master Data Services (6)
      • OLAP cube (15)
      • PowerBI (97)
      • Reporting Services (SSRS) (67)
    • Data science (21)
    • ►Database design (235)
      • Clustering (16)
      • Common Table Expressions (CTE) (11)
      • Concurrency (1)
      • Constraints (8)
      • Data types (11)
      • FILESTREAM (22)
      • General database design (106)
      • Partitioning (13)
      • Relationships and dependencies (12)
      • Temporal tables (12)
      • Views (16)
    • ►Database development (429)
      • Comparison (4)
      • Continuous delivery (CD) (5)
      • Continuous integration (CI) (11)
      • Development (151)
      • Functions (108)
      • Hyper-V (1)
      • Search (10)
      • Source Control (15)
      • SQL unit testing (23)
      • Stored procedures (35)
      • String Concatenation (2)
      • Synonyms (1)
      • Team Explorer (2)
      • Testing (35)
      • Visual Studio (14)
    • DBAtools (35)
    • DevOps (23)
    • DevSecOps (2)
    • Documentation (22)
    • ETL (76)
    • ►Features (213)
      • Adaptive query processing (11)
      • Bulk insert (16)
      • Database mail (10)
      • DBCC (7)
      • Experimentation Assistant (DEA) (3)
      • High Availability (36)
      • Query store (10)
      • Replication (40)
      • Transaction log (59)
      • Transparent Data Encryption (TDE) (21)
    • Importing, exporting (52)
    • Installation, setup and configuration (122)
    • Jobs (42)
    • ►Languages and coding (713)
      • Cursors (9)
      • DDL (9)
      • DML (6)
      • JSON (17)
      • PowerShell (77)
      • Python (38)
      • R (16)
      • SQL commands (206)
      • SQLCMD (7)
      • String functions (21)
      • T-SQL (291)
      • XML (15)
    • Lists (12)
    • Machine learning (37)
    • Maintenance (99)
    • Migration (50)
    • Miscellaneous (1)
    • ►Performance tuning (871)
      • Alerting (8)
      • Always On Availability Groups (82)
      • Buffer Pool Extension (BPE) (9)
      • Columnstore index (9)
      • Deadlocks (16)
      • Execution plans (125)
      • In-Memory OLTP (22)
      • Indexes (79)
      • Latches (5)
      • Locking (10)
      • Monitoring (100)
      • Performance (196)
      • Performance counters (28)
      • Performance Testing (9)
      • Query analysis (123)
      • Reports (20)
      • SSAS monitoring (3)
      • SSIS monitoring (10)
      • SSRS monitoring (4)
      • Wait types (11)
    • ►Professional development (71)
      • Professional development (27)
      • Project management (9)
      • SQL interview questions (35)
    • Recovery (33)
    • Security (85)
    • Server management (24)
    • SQL Azure (272)
    • SQL Server Management Studio (SSMS) (91)
    • SQL Server on Linux (22)
    • ►SQL Server versions (177)
      • SQL Server 2012 (6)
      • SQL Server 2016 (63)
      • SQL Server 2017 (49)
      • SQL Server 2019 (57)
      • SQL Server 2022 (2)
    • ►Technologies (357)
      • AWS (46)
      • AWS RDS (56)
      • Azure Cosmos DB (33)
      • Containers (12)
      • Docker (9)
      • Graph database (13)
      • Kerberos (2)
      • Kubernetes (3)
      • Linux (44)
      • LocalDB (2)
      • MySQL (56)
      • Oracle (12)
      • PolyBase (10)
      • PostgreSQL (42)
      • SharePoint (4)
      • Ubuntu (13)
    • Uncategorized (4)
    • Utilities (21)
    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