MS-SQL Server - Business RFC, Waittypes, Buffer Manager & Limit

Business RFC, Waittypes, Buffer Manager & Limit..

RFC is nothing but request for change and this needs following things attached

- Implementation Plan
- Signoff & Approval Documents
- Team Involved with Contacts
- Rollback Plan

Imp. Waittypes
FS_GARBAGE_COLLECTOR_SHUTDOWN

Internal Use
FABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSING
FT_IFTS_CHUNK_BUFFER_CLIENT_MANAGER

Buffer Manager

https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-buffer-manager-object?source=recommendations&view=sql-server-ver16

Limit
https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

And 7818

Creating a join on 2 SQL Tables in the gallery

https://powerusers.microsoft.com/t5/Building-Power-Apps/Creating-a-join-on-2-SQL-Tables-in-the-gallery/td-p/29188

Performance Metrics

https://learn.microsoft.com/en-us/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver16

SQL Server Type of Replication

https://learn.microsoft.com/en-us/sql/relational-databases/replication/types-of-replication?view=sql-server-ver16

Best Regards

T. Amit Vaid S.