MS-SQL Server - Partitioning & Much of Gulal (By Waittypes)

Partitioning

https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16

Additionally,

Well, we can create colorful graph by analysing some of the key waittypes.

select * from sys.dm_os_wait_stats where wait_type in ('ASYNC_NETWORK_IO','PAGELATCH_SH','PAGELATCH_EX','PAGEIOLATCH_SH','PAGEIOLATCH_EX','IO_COMPLETION','WRITELOG','ASYNC_IO_COMPLETION','CxPACKET','HADR_FILESTREAM_IOMGR_IOCOMPLETION','OLEDB','MSSQL_XP','LCK_M_IX','LCK_M_X','LCK_M_U','SOS_SCHEDULAR_YIELD','DEADLOCK_ENUM_MUTEX')

Best Regards

T. Amit Vaid S.