SQLBits 2024

Load Testing Fabric - What is our hold capacity?

This session covers how to test Fabric for larger workloads. The default demo data is usually relatively small whereas a lot of companies process a lot more. This session aims at those use cases where a large dataset needs to be processed. The session goes from data ingestion to data presentation with PowerBI.
We've all seen the standard Fabric demos online; running data from AdventureWorks, WideWorldImporters or NY taxi through Fabric and quickly create wonderful reports.
But, Is this really the amount of data you're going to process? Can you really tell if Fabric will perform with your data volume?

These were question I had and I tried to get some kind of answer to them.

It's time to let your Fabric work!

In this session, I'll take you along with the steps I took to give Fabric a run for it's capacity units so you can do this as well. The data I'm using has nothing secretive in it, so you can happily share the results with the entire world. From data ingestion to report (yes, I will touch PowerBI), let's see how much Fabric can handle.

When I've finished, you'll leave with an extra tool in your set to check if your chosen capacity unit is good enough for your production load.