@sqL_handLe@sqlstudent144 Wow, an oldie but a goodie! Great explanations @sqL_handLe ! @sqlstudent144 just remember that optimize for sequential key doesn't necessarily make things faster, it makes them more predictable. It smoothes out the spikes so the server doesn't come crashing down.
๐Big News!๐ I/O Performance Analysis for SQL Server on Azure VMs is now Generally Available (GA)!
This powerful Azure portal feature allows you to:
- Identify I/O bottlenecks from Azure VM or disk throttling
- Analyze storage health with detailed metrics
- Optimize performance using actionable insights
- Evaluate storage related best practices to help ensure performance and stability
With the 'I/O Performance Analysis for SQL Server on Azure VMs' you can say goodbye to the guesswork and get a quick evaluation of your storage health and apply storage best practices!
Get precise data on latency, impact levels, and timestamps to ensure your SQL Server workloads run smoothly.
Learn more: https://t.co/86Mgwr8f9H
#Azure #SQLServer #AzureSQL #AzureSQLVM
At #MSBuild? Join us for BRK170 @ 1:45 pm/PT to learn how @SAS went on their own journey through application and database modernization on Azure. Weโll share demos and cover the tools and programs you need to get started. See you there: https://t.co/ECF5B8aF4p #AzureSQL
@bobwardms Why yes I do! Thursday at 1:45PM PDT in room 425! We'll be talking about SAS's modernization journey from SQL Server on Azure VM to Azure SQL Managed Instance! #AzureSQL#MSBuild
Day 1 of #MSBuild is almost in the books and it's so exciting to feel the buzz in the air!!! I'm especially excited for this session coming up on Thursday with our CVP Shireesh Thota talking about #AzureSQL in the new era of AI! With demos by the great @bobwardms of course!
Join us May 23 @ 8:30AM PT to hear CVP of Azure Databases, Shireesh Thota share how to bring the power of AI to #AzureSQL workloads with the latest AI-ready and AI-enhanced features. With demos from SQL expert @BobWard, you wonโt want to miss it! https://t.co/S2CeGCPT1S #MSBuild
We're celebrating #MaytheFourthBeWithYou with a special Data Exposed Exclusive on availability sets & zones for #SQLServer on Azure VMs with Princess @AnalyticAnna, Grogu @SQLGoddess & Obiwan Johnobi @sqlrus.
Watch๐บ๐โญ: https://t.co/hI882OPLIK
I've always been passionate about sharing my SQL knowledge with developers, so I'm super happy to be speaking at #MSBuild again this year! #AzureSQL https://t.co/Zj2dSW6CW7
Not an April Fool's joke I promise, check out the amazing work @dpless and team did on our new Premium SSD v2 deployment experience! Now in Public Preview! #AzureSQL https://t.co/S8vSXb3iIz
Public preview for Premium SSD v2 on Azure SQL VM is available!
Premium SSD v2 storage is perfect for IO-intensive workloads requiring sub-millisecond disk latencies, higher IOPS & throughput at a lower TCO.
Learn more: https://t.co/b75ORqPmiY
#AzureSQLVM#AzureSQL#SQLServer
@bobwardms@AnalyticAnna@SQLServer@slava_oks@AnalyticAnna does it have the CD inside?? If I remember correctly this book shipped with the first version of some killer tools. I never owned it myself, but my career at Microsoft is built on its legacy โค๏ธ