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.
2 comments:
[View time of Backup]
Checkpoint, Functions, Special Characters
https://learn.microsoft.com/en-us/sql/t-sql/functions/string-escape-transact-sql?view=sql-server-ver16
Storage Migration
Data Migration
Instance Migration
Keys & Constraints, Technicality of Updating Stats
Wait Stats
Netstat
Waittype
SOS_MEMORY_USAGE_ADJUSTMENT
Internal
VDI_CLIENT_OPERATION
Imp. Waittype
CXROWSET_SYNC
Post a Comment