Pages

▼

Monday, May 1, 2023

MS-SQL Server - AdventureWorks Sample

AdventureWorks Sample


https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms


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


https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-availability-groups-sql-server?view=sql-server-ver16


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.

at

4 comments:

  1. AnonymousMay 13, 2023 at 5:19 PM

    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

    ReplyDelete
  2. AnonymousMay 27, 2023 at 7:56 PM

    COM Objects

    https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/development/run-dll-based-com-object#more-information

    ReplyDelete
  3. AnonymousJuly 9, 2023 at 2:24 PM

    CXPACKET, FT_IFTS_STOPLIST_CACHE_MANAGER, HADR_BACKUP_BULK_LOCK

    ReplyDelete
  4. AnonymousSeptember 29, 2023 at 11:30 PM

    Topics
    Commit, Rollback, Sort Transactions, Performance, Service Master Key and waittypes
    CHECK_TABLES_THREAD_BARRIER,
    DISPATCHER_QUEUE_SEMAPHORE

    ReplyDelete