Performance Monitor for SQL Server v2.2.0 Release!
This is a big one for efficiency and, well, performance.
* Compacted LOB data
* Major UI responsiveness improvements
* Smarter use of Parquet files
There's a lot in the release notes for this one.
github.com/erikdarlingd...
the entity framework team is desperately in need of adult database supervision.
learn.microsoft.com/en-us/ef/cor...
Quite fibrous.
I converted it to JSON.
travel days are always the most exciting computer days.
last week before heading to nashville, i had a bios update.
this week before heading to chicago, i have low disk space and a 2.2tb xml file called "health_plan".
Wow that is luxurious
New Performance Studio Release: Ever wanted to look at a query plan and instantly see all the important stuff you normally have to go digging for, with expert-level analysis done automatically?
Works on Windows and Macs.
github.com/erikdarlingd...
Ken, we know.
@motherduck.com thanks for the duck!
on a bit of a building spree, and wanted to gives performance tuning dbas and performance-curious developers a standlone, cross-platform tool to analyze, compare, and get advice on sql server query plans.
github.com/erikdarlingd...
What Do You Call A Join That Isn't A Semi Join?
What Do You Call A Join That Isn't A Semi Join? There's a gap in SQL Server database terminology that's been bugging me as long as I've been teaching...
https://erikdarling.com/what-do-you-call-a-join-that-isnt-a-semi-join/
Free, open source SQL Server performance monitoring that doesn't suck.
New in 2.1.0:
- 18 *new* plan analysis rules
- Standalone plan viewer
- Light themes for the dark mode haters
- Timezone toggles
- Tons more fixes and improvements
github.com/erikdarlingd...
i'm on dat dere max plan
That’s it I’m finally voting
Who makes you sleep with a shirt on
For all the nice folks out there who still like to hit F5 to troubleshoot SQL Server, here are some spring script updates: github.com/erikdarlingd...
I like to think of it as a paintbrush. Depending on who you give it to, you get very different results.
Currently working on surfacing query plan stuff you should know about in my free SQL Server Monitoring tool. Interesting statement level information, Missing index memes, and a Wait Stats graph. Plus, more query analysis rules!
github.com/erikdarlingd...
i could say a lot about all the features and improvements, but c'mon: native query plan viewing.
1. view cached plans from just about anywhere
2. get actual execution plans right in the dashboard
3. have my brand of plan analysis built right in
github.com/erikdarlingd...
Get AI-Ready With Erik: Helping Vectors Rank Better With Keyword Boosts
Get AI-Ready With Erik: Helping Vectors Rank Better With Keyword Boosts https://youtu.be/iLZXG0ATh6k Video Summary In this...
https://erikdarling.com/get-ai-ready-with-erik-helping-vectors-rank-better-with-keyword-boosts/
If you're like me, and you forget which PerfMon counters to use for problems, you're gonna love the PerfMon packs coming to my free SQL Server Monitoring Tool.
github.com/erikdarlingd...
Get AI-Ready With Erik: Full Text Keyword Search In SQL Server
Get AI-Ready With Erik: Full Text Keyword Search In SQL Server https://youtu.be/xt74-ELR05g Video Summary In this video, I dive into the...
https://erikdarling.com/get-ai-ready-with-erik-full-text-keyword-search-in-sql-server/
Coming soon to my free SQL Server Monitoring tool: native plan viewing, getting actual execution plans, and plan analysis rules that I've always wanted to see in SSMS. Check it out here: github.com/erikdarlingd...
Looking for feedback on filtering, alert muting, and exclusions with my free SQL Server monitoring tool: github.com/erikdarlingd...
SQL Server Performance Office Hours Episode 49
SQL Server Performance Office Hours Episode 49 https://youtu.be/U4z0UZrrCn0 Query Store shows this plan has the lowest average duration, so it must be the best plan. Should...
https://erikdarling.com/sql-server-performance-office-hours-episode-49/
Emulating GETDATE() on Azure SQL Database
GETDATE() always uses the UTC time zone on Azure SQL Database which can be a compatibility issue for applications that assume that GETDATE() is using a different time zone....
NOT ENOUGH
a friday release! free sql performance monitoring for the people! lots of bug fixes and improvements in this one. as always, check the release notes and readme, and use github for questions, comments, concerns, and support: github.com/erikdarlingd...
reading and wondering why people are so mean to databases: learn.microsoft.com/en-us/sql/sq...
