Your report queries are too slow.
You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your growing data. It’s already up over 250GB, and they’re not letting you purge old data.
Will columnstore indexes help?
Next Tuesday, you’ll learn:
- How columnstore data is stored, and how that impacts your architecture choices
- How to do a hands-on self-assessment of your workloads, data, and server to figure out whether columnstore indexes make sense for you
- Why partitioning makes so much sense for columnstore indexes
- How to do a proof-of-concept implementation with initial creation, querying, ongoing loads, and index maintenance
No registration required – just add this event to your calendar, then show up at BrentOzar.com/training/live/ on next Tuesday at 8AM UTC. This is a Europe-friendly time zone class – folks in other parts of the world will either need to get up at an oddball time, or else buy the recordings.
If you’d like to follow along with the demos during class – totally optional, not required – here’s how to set up a lab VM. This requires a specialized full-size 300GB copy of the Stack Overflow database. This is not the kind of class where you wanna follow along on a low-end laptop: this requires the Mastering-level setup because columnstore is all about big data.
See you in class!
12 Comments. Leave new
April 1st comes around quicker every year! 😉
No fooling – the class is free.
That’s my kinda price! I had to ask, bearing in mind what day it is today!
Thanks for giving back to the community!
2:00 AM until10:00 AM?
Martin – read through the post nice and slow. I know the words look big, but I believe in you. Don’t listen to what your friends and family say: you can do this!
Martin’s referring to the linked calendar event – which is 8 hours long – and probably trying to confirm if the class is actually 8 hours long or a mistake on the event file. For me it’s 1AM -9AM, but still 8 hours and I scratched my head at it as well.
Yes, it’s an all day class.
4 AM EDT! ZZZzzzzz Awesome that it is free!
Thank you for the course yesterday. It was very informative and I picked up a lot of things I plan to try and see if I can apply to the various environments I work in.
You’re welcome, glad you liked it!
Doh! Missed it. Is it on youtube
Warren – read the post really carefully about how to get recordings. Thanks!