Make An Azure SQL Managed Instance General Purpose FASTER!
Ғылым және технология
@SQLBalls walks us through how to ensure we are getting the most IOPS out of our @azuresqlmanagedinstance General Purpose Database!
@JovanPopovicJocaPC GitHub for Query Performance Insights - github.com/JocaPC/qpi
@MicrosoftAzure Storage Premium SSD IOPS - learn.microsoft.com/en-us/azu...
@JovanPopovicJocaPC Storage layer in General Purpose Azure SQL Managed Instance - / file-layout-in-general...
@JovanPopovicJocaPC Running HammerDB on TPCC96 database on General Purpose Azure SQL Managed Instance - / running-hammerdb-on-tp...
HammerDB - hammerdb.com/
Chapters:
00:00 Synapsis
00:06 Intro Music
00:16 About our Channel
00:55 IOPs and Database Workloads
01:36 Azure Premium SSD's
01:59 Download & Install HammerDB
02:51 Configure Workload TPCC-C DB
04:57 Run HammerDB Workload Baseline 1
07:25 Increase Data File Size Baseline 2
09:05 Increase Log File Size Baseline 3
09:56 Do I need to do this for BC or just GP?
Пікірлер: 5
I love topics keep it up
@SQLBalls
Жыл бұрын
Thank you Mahmoud!
in 7:00, the results seem to be the IOPS for files of master database, I think it should be the files for tpcc_08 database.
@SQLBalls
Жыл бұрын
Hie Stephanie, sharp eyes! You are correct, that was my bad. I'm recording another video on this subject for a higher core count and larger warehouses. I will get this corrected in that video and add an updated link for that video here when it drops!
@Tales-from-the-Field
Жыл бұрын
Thank you for paying such close attention Stephanie!