In this blog post, I will show you how to set up Fabric Capacity operation events.

You can find more information here: https://learn.microsoft.com/en-us/fabric/real-time-hub/explore-fabric-capacity-operation-events

This feature is currently in preview. The experience and terminology may change before it becomes generally available.

Setup

Before using Fabric Capacity operation events, you need to have a Fabric capacity.

In my testing, Capacity Operation Events consumed approximately 230,000 CUs per day.

Based on my usage, an F4 capacity was required to run this continuously each day.

NOTE: This is based on my usage. Your consumption may be slightly higher or lower.

Creating the Eventstream

The first step is to create the Eventstream.

  • First, I made sure that I was in the workspace where I wanted to create the Eventstream and Eventhouse.
  • Next, I selected Real-Time.
    • NOTE: If you do not see Real-Time, select the ellipsis (…) and then select Real-Time.
  • In the Real-Time hub, I selected “Fabric events”.
  • I then selected “Fabric capacity operation events”.
  • When the page opened, I selected “Create eventstream”.
  • I configured my Eventstream using the settings shown below.
  • 1. I kept the default Event type.
  • 2. For Event scope, I kept the default option, “By Capacity”.
    • NOTE: I had to configure a separate Eventstream for each capacity.
  • 3. I selected the capacity that I wanted to monitor.
  • 4. On the right-hand side, I selected the workspace where I wanted the Eventstream to be created.
  • 5. I renamed the Eventstream.
    • NOTE: Changing the Eventstream name also changes the “Stream name”.
  • I then selected Next.
  • After reviewing the Eventstream configuration, I selected Connect.
  • After receiving confirmation that it had been created, I selected “Open Eventstream”.
  • Once in the Eventstream, I waited a minute or two and could then see the data streaming.

Creating the Output

Next, I created an output destination to store the data.

  • I selected “Transform events or add destination”.
  • I then selected Eventhouse.
  • I already had an Eventhouse and the required table created, as shown below.
    • NOTE: If you do not have an Eventhouse, you can create one from the window shown below. You can also create the required table.
  • I selected Save.
  • The final step is to select Publish in the upper-right corner so that the changes take effect.

Running a KQL Query to View the Data

The final step is to run a query against the Eventhouse to confirm that data is being ingested successfully.

  • I opened my Eventhouse.
  • To view the records, I completed the following steps.
  • I selected my CapacityEvents table.
  • I then selected “Query with code”.
  • I selected “SQL”.
  • Finally, I selected “Show any 100 records”.
  • I could then see the incoming records, as shown below.

Summary

In this blog post, I have shown you how to connect to Fabric Capacity operation events and store the data in a KQL database within an Eventhouse.

In the next blog post, I will show you how I aggregate and save the data to a Lakehouse and then create a report for analysis.