MS-SQL Server - Port and Fresh Security Tips

Port and Fresh Security Tips

Along with Port concept, I am providing some Fresh Security Tips...

Configure Port

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16

The 4 major Performance Tips are...

- Proper Indexing and Maintenance

- Performance Counters Capture the Data for anytime analysis.

- Tempdb Best Practices

- Table Partitioning

Transaction Performance, PLE & Virtual Machine

https://learn.microsoft.com/en-us/answers/questions/1182704/sql-server-2022-transaction-performance

PLE

https://techcommunity.microsoft.com/t5/sql-server-support-blog/sql-server-page-life-expectancy-ple/ba-p/318572

Virtual Machine

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview?view=azuresql

Additionally,

Buffer cache hit ratio between 90-97% is one of the hint of instance running fine.

Any query will be considered.

T. Amit Vaid S.