Pages

▼

Saturday, July 22, 2023

MS-SQL Server - Topics & Waittypes

Topics


Backup, high availability and year datatypes hangs, prerequisites, keys, OLE Automation,

Document of Storage, HADR_FILESTREAM_FILE_REQUEST

QPJOB_KILL

WINFAB_REPLICA_BUILD_OPERATION

QPJOB_WAITFOR_ABORT

DISPATCHER_QUEUE_SEMAPHORE

PREEMPTIVE_COM_LBREADAT

PREEMPTIVE_HADR_LEASE_MECHANISM






Any query will be considered.


T. Amit Vaid S.
at

8 comments:

  1. AnonymousJuly 22, 2023 at 12:10 PM

    RAID, Scheduled jobs, triggers, year data type, Profiler, Group by, Create/Drop Index, Show Statistics, SAN, Standard Edition and Types of Hangs

    Technical Documentation, Joins, Azure Managed Instance, RAISE Error, Memory, Scheduler, Analysis Services, RMO Concepts & Always On

    Server Roles, high availability, Named instance

    ReplyDelete
  2. AnonymousJuly 22, 2023 at 6:26 PM

    Some of the imp. waittypes.
    SERVER_RECONFIGURE
    PWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOG
    TRAN_MARKLATCH_EX
    WAIT_XLOGREAD_SIGNAL
    XTPPROC_PARTITIONED_STACK_CREATE
    WINDOW_AGGREGATES_MULTIPASS
    QUERY_NOTIFICATION_SUBSCRIPTION_MUTEX
    SOS_MEMORY_USAGE_ADJUSTMENT

    ReplyDelete
  3. AnonymousJuly 22, 2023 at 10:51 PM

    Analysis Services, Get table definition
    https://learn.microsoft.com/en-us/sql/relational-databases/tables/view-the-table-definition?view=sql-server-ver16

    Database Backup, SA Account default password.
    https://learn.microsoft.com/en-us/answers/questions/602203/what-default-sa-sql-admin-user-password

    ReplyDelete
  4. AnonymousJuly 23, 2023 at 8:29 AM

    Determine which version and edition of SQL Server Database Engine is running.

    https://learn.microsoft.com/en-us/troubleshoot/sql/releases/find-my-sql-version

    Many Sleeping Connections & All Versions Explained
    https://learn.microsoft.com/en-us/answers/questions/100075/sleeping-sessions-with-old-open-transactions-issue

    https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates

    Table Partitioning and Indexes, Pooling & Strings
    https://learn.microsoft.com/en-us/sql/relational-databases/partitions/partitioned-tables-and-indexes?view=sql-server-ver16

    https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling

    https://learn.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=sql-server-ver16

    ReplyDelete
  5. AnonymousJuly 23, 2023 at 8:56 AM

    CheckDB Repair & System Monitor
    https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver16

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

    Waittypes
    PREEMPTIVE_COM_LBSETSIZE
    MD_LAZYCACHE_RWLOCK
    PREEMPTIVE_OLEDB_RELEASE
    XIO_IOSTATS_BLOBLIST_RWLOCK

    ReplyDelete
  6. AnonymousJuly 23, 2023 at 9:04 PM

    Topics
    - Monitoring & Threads Architecture, Logspace

    ReplyDelete
  7. AnonymousJuly 24, 2023 at 10:33 AM

    Imp. Waittypes.
    HADR_THROTTLE_LOG_RATE_GOVERNOR
    HADR_TDS_LISTENER_SYNC_PROCESSING
    AM_SCHEMAMGR_UNSHARED_CACHE
    DISPATCHER_QUEUE_SEMAPHORE
    FT_IFTS_DOCID_INTERFACE_LIST
    FABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIG
    FCB_REPLICA_READ

    ReplyDelete
  8. AnonymousAugust 19, 2023 at 10:34 PM

    Topics

    Joins, Awaiting headers errors
    https://learn.microsoft.com/en-us/answers/questions/1194132/how-to-handle-client-timeout-exceeded-while-awaiti

    Naming conventions, Data type and maximum values
    https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16

    View any definition & Year and last month
    https://learn.microsoft.com/en-us/sql/relational-databases/views/get-information-about-a-view?view=sql-server-ver16

    https://learn.microsoft.com/en-us/answers/questions/1188651/sql-query-last-month

    SQL Server 2022 Express Edition
    https://www.microsoft.com/en-US/download/details.aspx?id=104781

    ReplyDelete