AdventureWorks Sample
Get Rid of Deadlocks
https://techcommunity.microsoft.com/t5/sql-server-blog/get-rid-of-deadlocks/ba-p/383947
Always On availability groups: a high-availability and disaster-recovery solution
Scan vs Seek
https://techcommunity.microsoft.com/t5/sql-server-blog/scans-vs-seeks/ba-p/383115
&
Waittypes
HADR_NOTIFICATION_DEQUEUE
Internal Use only
SESSION_WAIT_STATS_CHILDREN
FT_IFTS_CRAWL_CHILDREN
Best Regards
T. Amit Vaid S.
4 comments:
Subscribe to Publications
https://learn.microsoft.com/en-us/sql/relational-databases/replication/subscribe-to-publications?view=sql-server-ver16
Additionally,
SQL - Peak Hours Performance Monitoring.
During peak hours we can monitor performance using PerfMon.
पांच मिनट अगर SQL Services बंद होती हैं, तो अंदर क्या हो रहा है ये performance monitor कुछ हद तक बता देता है, घुम घुमा के यही एक मात्र विकल्प रह जाता है, perfmon में सभी हैं समाए!
Create a Job Schedule using Object Explorer
https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-schedule?view=sql-server-ver16
Joins, Primary and Unique Keys
https://learn.microsoft.com/en-us/sql/relational-databases/performance/joins?view=sql-server-ver16
Primary and Unique Keys
https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-unique-constraints?view=sql-server-ver16
COM Objects
https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/development/run-dll-based-com-object#more-information
CXPACKET, FT_IFTS_STOPLIST_CACHE_MANAGER, HADR_BACKUP_BULK_LOCK
Topics
Commit, Rollback, Sort Transactions, Performance, Service Master Key and waittypes
CHECK_TABLES_THREAD_BARRIER,
DISPATCHER_QUEUE_SEMAPHORE
Post a Comment