Friday, April 14, 2023

MS-SQL Server - SHLIVA, Slab & Ultimate Pivot

SHLIVA, Slab & Ultimate Pivot..


In terms of performance I am going to define SHLIVA today.

- Stored Procedure tuning
- History Cleanup (Maintenance, Agent Log)
- Logspace Shrinking
- Index Maintenance
- Virtual Log files
- Autogrowth & Autoupdate Statistics.


Slab based calculation

https://social.msdn.microsoft.com/Forums/en-US/6ee133e5-19f7-481c-8677-1d85b6a48982/slab-calculation-in-sql?forum=transactsql

Ultimate Pivot

https://amit-sqldbasupport.blogspot.com/2022/11/sql-server-ultimate-pivot-script.html?m=1


Additionally,

Understand Blocking with Analyze Blocking Data

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/understand-resolve-blocking


दर्पण (A Database Mirroring)

https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-sql-server?view=sql-server-ver16

Lock Table for Insert
TABLOCK is shared Lock
TABLOCKX for exclusive lock

SQL Syntax
"INSERT INTO dbo.table_name WITH (TABLOCK)"

https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql?view=sql-server-ver16


Best Regards


T. Amit Vaid S.

No comments: