(Companion SQL Server Latch Classes Library)
This site lists all wait types in SQL Server 2005 onward and gives detailed information about where they occur inside SQL Server. All waits have an infographic showing how prevalent that wait is, based on the previous month’s aggregated monitoring data from man thousands of SentryOne-monitored instances. I created this site to be a comprehensive resource for the SQL Server community as this information is not available anywhere else. I hope it helps you with SQL Server performance tuning and understanding SQL Server in more depth.
Usage: you may link to/use this information any way you want, except you may not include this information in a commercial product/website, or republish information from this library in any form without *first* getting permission from me.
For info on how to help gathering data for this site, and to submit general feedback (or even just to let me know that you found it useful and/or tell me how you used it), please send me email.
Thanks!
Paul
People who have helped/are helping gather data for the wait types library: Greg Gonzalez and the SentryOne team, Arun Sirpal (top contributor!), Jonathan Kehayias, Erin Stellato, Tim Radney, Anthony Nocentino, Tim Chapman (MSFT), Steve Stedman
SQL Server Wait TypesWait types covered: 898 with detailed information on 303 (updated 5/10/17)
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
A
ABRAM_INDBUILD_ALLOCATIONAM_SCHEMAMGR_UNSHARED_CACHEASSEMBLY_FILTER_HASHTABLEASSEMBLY_LOADASYNC_DISKPOOL_LOCKASYNC_IO_COMPLETIONASYNC_NETWORK_IOASYNC_OP_COMPLETIONASYNC_OP_CONTEXT_READASYNC_OP_CONTEXT_WRITEASYNC_SOCKETDUP_IOAUDIT_GROUPCACHE_LOCKAUDIT_LOGINCACHE_LOCKAUDIT_ON_DEMAND_TARGET_LOCKAUDIT_XE_SESSION_MGR
B
(Back to top)BACKUPBACKUP_CLIENTLOCKBACKUP_OPERATORBACKUPBUFFERBACKUPIOBACKUPTHREADBAD_PAGE_PROCESSBLOB_METADATABMPALLOCATIONBMPBUILDBMPREPARTITIONBMPREPLICATIONBPSORTBROKER_CONNECTION_RECEIVE_TASKBROKER_DISPATCHERBROKER_ENDPOINT_STATE_MUTEXBROKER_EVENTHANDLERBROKER_FORWARDERBROKER_INITBROKER_MASTERSTARTBROKER_RECEIVE_WAITFORBROKER_REGISTERALLENDPOINTSBROKER_SERVICEBROKER_SHUTDOWNBROKER_STARTBROKER_TASK_SHUTDOWNBROKER_TASK_STOPBROKER_TASK_SUBMITBROKER_TO_FLUSHBROKER_TRANSMISSION_OBJECTBROKER_TRANSMISSION_TABLEBROKER_TRANSMISSION_WORKBROKER_TRANSMITTERBUILTIN_HASHKEY_MUTEX
C
(Back to top)CHANGE_TRACKING_WAITFORCHANGESCHECK_PRINT_RECORDCHECK_SCANNER_MUTEXCHECK_TABLES_INITIALIZATIONCHECK_TABLES_SINGLE_SCANCHECK_TABLES_THREAD_BARRIERCHECKPOINT_QUEUECHKPTCLEAR_DBCLR_AUTO_EVENTCLR_CRSTCLR_JOINCLR_MANUAL_EVENTCLR_MEMORY_SPYCLR_MONITORCLR_RWLOCK_READERCLR_RWLOCK_WRITERCLR_SEMAPHORECLR_TASK_STARTCLRHOST_STATE_ACCESSCMEMPARTITIONEDCMEMTHREADCOLUMNSTORE_BUILD_THROTTLECOLUMNSTORE_COLUMNDATASET_SESSION_LISTCOMMIT_TABLECONNECTION_ENDPOINT_LOCKCOUNTRECOVERYMGRCREATE_DATINISERVICECURSORCURSOR_ASYNCCXPACKETCXROWSET_SYNC
D
(Back to top)DAC_INITDBCC_SCALE_OUT_EXPR_CACHEDBMIRROR_DBM_EVENTDBMIRROR_DBM_MUTEXDBMIRROR_EVENTS_QUEUEDBMIRROR_SENDDBMIRROR_WORKER_QUEUEDBMIRRORING_CMDDBSEEDING_FLOWCONTROLDBSEEDING_OPERATIONDBSTATEDBTABLEDEADLOCK_ENUM_MUTEXDEADLOCK_TASK_SEARCHDEBUGDIRECTLOGCONSUMER_LISTDIRTY_PAGE_POLLDIRTY_PAGE_SYNCDIRTY_PAGE_TABLE_LOCKDISABLE_VERSIONINGDISKIO_SUSPENDDISPATCHER_PRIORITY_QUEUE_SEMAPHOREDISPATCHER_QUEUE_SEMAPHOREDLL_LOADING_MUTEXDPT_ENTRY_LOCKDROP_DATABASE_TIMER_TASKDROPTEMPDTCDTC_ABORT_REQUESTDTC_RESOLVEDTC_STATEDTC_TMDOWN_REQUESTDTC_WAITFOR_OUTCOMEDTCNEW_ENLISTDTCNEW_PREPAREDTCNEW_RECOVERYDTCNEW_TMDTCNEW_TRANSACTION_ENLISTMENTDTCPNTSYNCDUMP_LOG_COORDINATORDUMP_LOG_COORDINATOR_QUEUEDUMPTRIGGER
E
(Back to top)ECEE_PMOLOCKEE_SPECPROC_MAP_INITENABLE_EMPTY_VERSIONINGENABLE_VERSIONINGERROR_REPORTING_MANAGEREXCHANGEEXECSYNCEXECUTION_PIPE_EVENT_INTERNALEXTERNAL_RG_UPDATEEXTERNAL_SCRIPT_PREPARE_SERVICEEXTERNAL_SCRIPT_SHUTDOWNEXTERNAL_WAIT_ON_LAUNCHER
F
(Back to top)FABRIC_HADR_TRANSPORT_CONNECTIONFABRIC_REPLICA_CONTROLLER_LISTFABRIC_REPLICA_CONTROLLER_STATE_AND_CONFIGFABRIC_REPLICA_PUBLISHER_EVENT_PUBLISHFABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LISTFABRIC_WAIT_FOR_BUILD_REPLICA_EVENT_PROCESSINGFAILPOINTFCB_REPLICA_READFCB_REPLICA_WRITEFEATURE_SWITCHES_UPDATEFFT_NSO_DB_KILL_FLAGFFT_NSO_DB_LISTFFT_NSO_FCBFFT_NSO_FCB_FINDFFT_NSO_FCB_PARENTFFT_NSO_FCB_RELEASE_CACHED_ENTRIESFFT_NSO_FCB_STATEFFT_NSO_FILEOBJECTFFT_NSO_TABLE_LISTFFT_NTFS_STOREFFT_RECOVERYFFT_RSFX_COMMFFT_RSFX_WAIT_FOR_MEMORYFFT_STARTUP_SHUTDOWNFFT_STORE_DBFFT_STORE_ROWSET_LISTFFT_STORE_TABLEFILE_VALIDATION_THREADSFILESTREAM_CACHEFILESTREAM_CHUNKERFILESTREAM_CHUNKER_INITFILESTREAM_FCBFILESTREAM_FILE_OBJECTFILESTREAM_WORKITEM_QUEUEFILETABLE_SHUTDOWNFORWARDER_TRANSITIONFS_FC_RWLOCKFS_GARBAGE_COLLECTOR_SHUTDOWNFS_HEADER_RWLOCKFS_LOGTRUNC_RWLOCKFSA_FORCE_OWN_XACTFSAGENTFSTR_CONFIG_MUTEXFSTR_CONFIG_RWLOCKFT_COMPROWSET_RWLOCKFT_IFTS_RWLOCKFT_IFTS_SCHEDULER_IDLE_WAITFT_IFTSHC_MUTEXFT_IFTSISM_MUTEXFT_MASTER_MERGEFT_MASTER_MERGE_COORDINATORFT_METADATA_MUTEXFT_PROPERTYLIST_CACHEFT_RESTART_CRAWLFT_RESUME_CRAWLFULLTEXT GATHERER
G
(Back to top)GDMA_GET_RESOURCE_OWNERGHOSTCLEANUPSYNCMGRGLOBAL_QUERY_CLOSEGLOBAL_TRAN_CREATEGLOBAL_TRAN_UCS_SESSIONGUARDIAN
H
(Back to top)HADR_AG_MUTEXHADR_AR_CRITICAL_SECTION_ENTRYHADR_AR_MANAGER_MUTEXHADR_AR_UNLOAD_COMPLETEDHADR_ARCONTROLLER_NOTIFICATIONS_SUBSCRIBER_LISTHADR_BACKUP_BULK_LOCKHADR_BACKUP_QUEUEHADR_CLUSAPI_CALLHADR_COMPRESSED_CACHE_SYNCHADR_CONNECTIVITY_INFOHADR_DBSEEDINGHADR_DBSEEDING_LISTHADR_DATABASE_FLOW_CONTROLHADR_DATABASE_VERSIONING_STATEHADR_DATABASE_WAIT_FOR_RECOVERYHADR_DATABASE_WAIT_FOR_RESTARTHADR_DATABASE_WAIT_FOR_TRANSITION_TO_VERSIONINGHADR_DB_COMMANDHADR_DB_OP_COMPLETION_SYNCHADR_DB_OP_START_SYNCHADR_DBR_SUBSCRIBERHADR_DBR_SUBSCRIBER_FILTER_LISTHADR_DBSTATECHANGE_SYNCHADR_FABRIC_CALLBACKHADR_FILESTREAM_BLOCK_FLUSHHADR_FILESTREAM_FILE_CLOSEHADR_FILESTREAM_FILE_REQUESTHADR_FILESTREAM_IOMGRHADR_FILESTREAM_IOMGR_IOCOMPLETIONHADR_FILESTREAM_MANAGERHADR_FILESTREAM_PREPROCHADR_GROUP_COMMITHADR_LOGCAPTURE_SYNCHADR_LOGCAPTURE_WAITHADR_LOGPROGRESS_SYNCHADR_NOTIFICATION_DEQUEUEHADR_NOTIFICATION_WORKER_EXCLUSIVE_ACCESSHADR_NOTIFICATION_WORKER_STARTUP_SYNCHADR_NOTIFICATION_WORKER_TERMINATION_SYNCHADR_PARTNER_SYNCHADR_READ_ALL_NETWORKSHADR_RECOVERY_WAIT_FOR_CONNECTIONHADR_RECOVERY_WAIT_FOR_UNDOHADR_REPLICAINFO_SYNCHADR_SEEDING_CANCELLATIONHADR_SEEDING_FILE_LISTHADR_SEEDING_LIMIT_BACKUPSHADR_SEEDING_SYNC_COMPLETIONHADR_SEEDING_TIMEOUT_TASKHADR_SEEDING_WAIT_FOR_COMPLETIONHADR_SYNC_COMMITHADR_SYNCHRONIZING_THROTTLEHADR_TDS_LISTENER_SYNCHADR_TDS_LISTENER_SYNC_PROCESSINGHADR_THROTTLE_LOG_RATE_GOVERNORHADR_TIMER_TASKHADR_TRANSPORT_DBRLISTHADR_TRANSPORT_FLOW_CONTROLHADR_TRANSPORT_SESSIONHADR_WORK_POOLHADR_WORK_QUEUEHADR_XRF_STACK_ACCESSHCCO_CACHEHK_RESTORE_FILEMAPHKCS_PARALLEL_MIGRATIONHKCS_PARALLEL_RECOVERYHTBUILDHTDELETEHTMEMOHTREINITHTREPARTITIONHTTP_ENDPOINT_COLLCREATEHTTP_ENUMERATIONHTTP_STARTHTTP_STORAGE_CONNECTION
I
(Back to top)IMP_IMPORT_MUTEXIMPPROV_IOWAITINSTANCE_LOG_RATE_GOVERNORINDEX_USAGE_STATS_MUTEXINTERNAL_TESTINGIO_AUDIT_MUTEXIO_COMPLETIONIO_QUEUE_LIMITIO_RETRYIOAFF_RANGE_QUEUE
J
(Back to top)
K
(Back to top)KSOURCE_WAKEUPKTM_ENLISTMENTKTM_RECOVERY_MANAGERKTM_RECOVERY_RESOLUTION
L
(Back to top)LATCH_DTLATCH_EXLATCH_KPLATCH_NLLATCH_SHLATCH_UPLAZYWRITER_SLEEPLCK_M_BULCK_M_BU_ABORT_BLOCKERSLCK_M_BU_LOW_PRIORITYLCK_M_ISLCK_M_IS_ABORT_BLOCKERSLCK_M_IS_LOW_PRIORITYLCK_M_IULCK_M_IU_ABORT_BLOCKERSLCK_M_IU_LOW_PRIORITYLCK_M_IXLCK_M_IX_ABORT_BLOCKERSLCK_M_IX_LOW_PRIORITYLCK_M_RIn_NLLCK_M_RIn_NL_ABORT_BLOCKERSLCK_M_RIn_NL_LOW_PRIORITYLCK_M_RIn_SLCK_M_RIn_S_ABORT_BLOCKERSLCK_M_RIn_S_LOW_PRIORITYLCK_M_RIn_ULCK_M_RIn_U_ABORT_BLOCKERSLCK_M_RIn_U_LOW_PRIORITYLCK_M_RIn_XLCK_M_RIn_X_ABORT_BLOCKERSLCK_M_RIn_X_LOW_PRIORITYLCK_M_RS_SLCK_M_RS_S_ABORT_BLOCKERSLCK_M_RS_S_LOW_PRIORITYLCK_M_RS_ULCK_M_RS_U_ABORT_BLOCKERSLCK_M_RS_U_LOW_PRIORITYLCK_M_RX_SLCK_M_RX_S_ABORT_BLOCKERSLCK_M_RX_S_LOW_PRIORITYLCK_M_RX_ULCK_M_RX_U_ABORT_BLOCKERSLCK_M_RX_U_LOW_PRIORITYLCK_M_RX_XLCK_M_RX_X_ABORT_BLOCKERSLCK_M_RX_X_LOW_PRIORITYLCK_M_SLCK_M_S_ABORT_BLOCKERSLCK_M_S_LOW_PRIORITYLCK_M_SCH_MLCK_M_SCH_M_ABORT_BLOCKERSLCK_M_SCH_M_LOW_PRIORITYLCK_M_SCH_SLCK_M_SCH_S_ABORT_BLOCKERSLCK_M_SCH_S_LOW_PRIORITYLCK_M_SIULCK_M_SIU_ABORT_BLOCKERSLCK_M_SIU_LOW_PRIORITYLCK_M_SIXLCK_M_SIX_ABORT_BLOCKERSLCK_M_SIX_LOW_PRIORITYLCK_M_ULCK_M_U_ABORT_BLOCKERSLCK_M_U_LOW_PRIORITYLCK_M_UIXLCK_M_UIX_ABORT_BLOCKERSLCK_M_UIX_LOW_PRIORITYLCK_M_XLCK_M_X_ABORT_BLOCKERSLCK_M_X_LOW_PRIORITYLOG_POOL_SCANLOG_RATE_GOVERNORLOGBUFFERLOGCAPTURE_LOGPOOLTRUNCPOINTLOGGENERATIONLOGMGRLOGMGR_FLUSHLOGMGR_PMM_LOGLOGMGR_QUEUELOGMGR_RESERVE_APPENDLOGPOOL_CACHESIZELOGPOOL_CONSUMERLOGPOOL_CONSUMERSETLOGPOOL_FREEPOOLSLOGPOOL_MGRSETLOGPOOL_REPLACEMENTSETLOGPOOLREFCOUNTEDOBJECT_REFDONELOWFAIL_MEMMGR_QUEUE
M
(Back to top)MD_AGENT_YIELDMD_LAZYCACHE_RWLOCKMEMORY_ALLOCATION_EXTMETADATA_LAZYCACHE_RWLOCKMIRROR_SEND_MESSAGEMISCELLANEOUSMSQL_DQMSQL_SYNC_PIPEMSQL_XACT_MGR_MUTEXMSQL_XACT_MUTEXMSQL_XPMSSEARCH
N
(Back to top)NET_WAITFOR_PACKETNETWORKSXMLMGRLOADNODE_CACHE_MUTEX
O
(Back to top)OLEDBONDEMAND_TASK_QUEUE
P
(Back to top)PAGEIOLATCH_DTPAGEIOLATCH_EXPAGEIOLATCH_KPPAGEIOLATCH_NLPAGEIOLATCH_SHPAGEIOLATCH_UPPAGELATCH_DTPAGELATCH_EXPAGELATCH_KPPAGELATCH_NLPAGELATCH_SHPAGELATCH_UPPARALLEL_BACKUP_QUEUEPARALLEL_REDO_DRAIN_WORKERPARALLEL_REDO_FLOW_CONTROLPARALLEL_REDO_LOG_CACHEPARALLEL_REDO_TRAN_LISTPARALLEL_REDO_TRAN_TURNPARALLEL_REDO_WORKER_SYNCPARALLEL_REDO_WORKER_WAIT_WORKPERFORMANCE_COUNTERS_RWLOCKPHYSICAL_SEEDING_DMVPOOL_LOG_RATE_GOVERNORPREEMPTIVE_ABRPREEMPTIVE_AUDIT_ACCESS_EVENTLOGPREEMPTIVE_AUDIT_ACCESS_SECLOGPREEMPTIVE_CLOSEBACKUPMEDIAPREEMPTIVE_CLOSEBACKUPTAPEPREEMPTIVE_CLOSEBACKUPVDIDEVICEPREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROLPREEMPTIVE_COM_COCREATEINSTANCEPREEMPTIVE_COM_COGETCLASSOBJECTPREEMPTIVE_COM_CREATEACCESSORPREEMPTIVE_COM_DELETEROWSPREEMPTIVE_COM_GETCOMMANDTEXTPREEMPTIVE_COM_GETDATAPREEMPTIVE_COM_GETNEXTROWSPREEMPTIVE_COM_GETRESULTPREEMPTIVE_COM_GETROWSBYBOOKMARKPREEMPTIVE_COM_LBFLUSHPREEMPTIVE_COM_LBLOCKREGIONPREEMPTIVE_COM_LBREADATPREEMPTIVE_COM_LBSETSIZEPREEMPTIVE_COM_LBSTATPREEMPTIVE_COM_LBUNLOCKREGIONPREEMPTIVE_COM_LBWRITEATPREEMPTIVE_COM_QUERYINTERFACEPREEMPTIVE_COM_RELEASEPREEMPTIVE_COM_RELEASEACCESSORPREEMPTIVE_COM_RELEASEROWSPREEMPTIVE_COM_RELEASESESSIONPREEMPTIVE_COM_RESTARTPOSITIONPREEMPTIVE_COM_SEQSTRMREADPREEMPTIVE_COM_SEQSTRMREADANDWRITEPREEMPTIVE_COM_SETDATAFAILUREPREEMPTIVE_COM_SETPARAMETERINFOPREEMPTIVE_COM_SETPARAMETERPROPERTIESPREEMPTIVE_COM_STRMLOCKREGIONPREEMPTIVE_COM_STRMSEEKANDREADPREEMPTIVE_COM_STRMSEEKANDWRITEPREEMPTIVE_COM_STRMSETSIZEPREEMPTIVE_COM_STRMSTATPREEMPTIVE_COM_STRMUNLOCKREGIONPREEMPTIVE_CONSOLEWRITEPREEMPTIVE_CREATEPARAMPREEMPTIVE_DEBUGPREEMPTIVE_DFSADDLINKPREEMPTIVE_DFSLINKEXISTCHECKPREEMPTIVE_DFSLINKHEALTHCHECKPREEMPTIVE_DFSREMOVELINKPREEMPTIVE_DFSREMOVEROOTPREEMPTIVE_DFSROOTFOLDERCHECKPREEMPTIVE_DFSROOTINITPREEMPTIVE_DFSROOTSHARECHECKPREEMPTIVE_DTC_ABORTPREEMPTIVE_DTC_ABORTREQUESTDONEPREEMPTIVE_DTC_BEGINTRANSACTIONPREEMPTIVE_DTC_COMMITREQUESTDONEPREEMPTIVE_DTC_ENLISTPREEMPTIVE_DTC_PREPAREREQUESTDONEPREEMPTIVE_FILESIZEGETPREEMPTIVE_FSAOLEDB_ABORTTRANSACTIONPREEMPTIVE_FSAOLEDB_COMMITTRANSACTIONPREEMPTIVE_FSAOLEDB_STARTTRANSACTIONPREEMPTIVE_FSRECOVER_UNCONDITIONALUNDOPREEMPTIVE_GETRMINFOPREEMPTIVE_HADR_LEASE_MECHANISMPREEMPTIVE_HTTP_EVENT_WAITPREEMPTIVE_HTTP_REQUESTPREEMPTIVE_LOCKMONITORPREEMPTIVE_MSS_RELEASEPREEMPTIVE_ODBCOPSPREEMPTIVE_OLE_UNINITPREEMPTIVE_OLEDB_ABORTORCOMMITTRANPREEMPTIVE_OLEDB_ABORTTRANPREEMPTIVE_OLEDB_GETDATASOURCEPREEMPTIVE_OLEDB_GETLITERALINFOPREEMPTIVE_OLEDB_GETPROPERTIESPREEMPTIVE_OLEDB_GETPROPERTYINFOPREEMPTIVE_OLEDB_GETSCHEMALOCKPREEMPTIVE_OLEDB_JOINTRANSACTIONPREEMPTIVE_OLEDB_RELEASEPREEMPTIVE_OLEDB_SETPROPERTIESPREEMPTIVE_OLEDBOPSPREEMPTIVE_OS_ACCEPTSECURITYCONTEXTPREEMPTIVE_OS_ACQUIRECREDENTIALSHANDLEPREEMPTIVE_OS_AUTHENTICATIONOPSPREEMPTIVE_OS_AUTHORIZATIONOPSPREEMPTIVE_OS_AUTHZGETINFORMATIONFROMCONTEXTPREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSIDPREEMPTIVE_OS_AUTHZINITIALIZERESOURCEMANAGERPREEMPTIVE_OS_BACKUPREADPREEMPTIVE_OS_CLOSEHANDLEPREEMPTIVE_OS_CLUSTEROPSPREEMPTIVE_OS_COMOPSPREEMPTIVE_OS_COMPLETEAUTHTOKENPREEMPTIVE_OS_COPYFILEPREEMPTIVE_OS_CREATEDIRECTORYPREEMPTIVE_OS_CREATEFILEPREEMPTIVE_OS_CRYPTACQUIRECONTEXTPREEMPTIVE_OS_CRYPTIMPORTKEYPREEMPTIVE_OS_CRYPTOPSPREEMPTIVE_OS_DECRYPTMESSAGEPREEMPTIVE_OS_DELETEFILEPREEMPTIVE_OS_DELETESECURITYCONTEXTPREEMPTIVE_OS_DEVICEIOCONTROLPREEMPTIVE_OS_DEVICEOPSPREEMPTIVE_OS_DIRSVC_NETWORKOPSPREEMPTIVE_OS_DISCONNECTNAMEDPIPEPREEMPTIVE_OS_DOMAINSERVICESOPSPREEMPTIVE_OS_DSGETDCNAMEPREEMPTIVE_OS_DTCOPSPREEMPTIVE_OS_ENCRYPTMESSAGEPREEMPTIVE_OS_FILEOPSPREEMPTIVE_OS_FINDFILEPREEMPTIVE_OS_FLUSHFILEBUFFERSPREEMPTIVE_OS_FORMATMESSAGEPREEMPTIVE_OS_FREECREDENTIALSHANDLEPREEMPTIVE_OS_FREELIBRARYPREEMPTIVE_OS_GENERICOPSPREEMPTIVE_OS_GETADDRINFOPREEMPTIVE_OS_GETCOMPRESSEDFILESIZEPREEMPTIVE_OS_GETDISKFREESPACEPREEMPTIVE_OS_GETFILEATTRIBUTESPREEMPTIVE_OS_GETFILESIZEPREEMPTIVE_OS_GETFINALFILEPATHBYHANDLEPREEMPTIVE_OS_GETLONGPATHNAMEPREEMPTIVE_OS_GETPROCADDRESSPREEMPTIVE_OS_GETVOLUMENAMEFORVOLUMEMOUNTPOINTPREEMPTIVE_OS_GETVOLUMEPATHNAMEPREEMPTIVE_OS_INITIALIZESECURITYCONTEXTPREEMPTIVE_OS_LIBRARYOPSPREEMPTIVE_OS_LOADLIBRARYPREEMPTIVE_OS_LOGONUSERPREEMPTIVE_OS_LOOKUPACCOUNTSIDPREEMPTIVE_OS_MESSAGEQUEUEOPSPREEMPTIVE_OS_MOVEFILEPREEMPTIVE_OS_NETGROUPGETUSERSPREEMPTIVE_OS_NETLOCALGROUPGETMEMBERSPREEMPTIVE_OS_NETUSERGETGROUPSPREEMPTIVE_OS_NETUSERGETLOCALGROUPSPREEMPTIVE_OS_NETUSERMODALSGETPREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYPREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREEPREEMPTIVE_OS_OPENDIRECTORYPREEMPTIVE_OS_PDH_WMI_INITPREEMPTIVE_OS_PIPEOPSPREEMPTIVE_OS_PROCESSOPSPREEMPTIVE_OS_QUERYCONTEXTATTRIBUTESPREEMPTIVE_OS_QUERYREGISTRYPREEMPTIVE_OS_QUERYSECURITYCONTEXTTOKENPREEMPTIVE_OS_REMOVEDIRECTORYPREEMPTIVE_OS_REPORTEVENTPREEMPTIVE_OS_REVERTTOSELFPREEMPTIVE_OS_RSFXDEVICEOPSPREEMPTIVE_OS_SECURITYOPSPREEMPTIVE_OS_SERVICEOPSPREEMPTIVE_OS_SETENDOFFILEPREEMPTIVE_OS_SETFILEPOINTERPREEMPTIVE_OS_SETFILEVALIDDATAPREEMPTIVE_OS_SETNAMEDSECURITYINFOPREEMPTIVE_OS_SQLCLROPSPREEMPTIVE_OS_SQMLAUNCHPREEMPTIVE_OS_VERIFYSIGNATUREPREEMPTIVE_OS_VERIFYTRUSTPREEMPTIVE_OS_VSSOPSPREEMPTIVE_OS_WAITFORSINGLEOBJECTPREEMPTIVE_OS_WINSOCKOPSPREEMPTIVE_OS_WRITEFILEPREEMPTIVE_OS_WRITEFILEGATHERPREEMPTIVE_OS_WSASETLASTERRORPREEMPTIVE_REENLISTPREEMPTIVE_RESIZELOGPREEMPTIVE_ROLLFORWARDREDOPREEMPTIVE_ROLLFORWARDUNDOPREEMPTIVE_SB_STOPENDPOINTPREEMPTIVE_SERVER_STARTUPPREEMPTIVE_SETRMINFOPREEMPTIVE_SHAREDMEM_GETDATAPREEMPTIVE_SNIOPENPREEMPTIVE_SOSHOSTPREEMPTIVE_SOSTESTINGPREEMPTIVE_SP_SERVER_DIAGNOSTICSPREEMPTIVE_STARTRMPREEMPTIVE_STREAMFCB_CHECKPOINTPREEMPTIVE_STREAMFCB_RECOVERPREEMPTIVE_STRESSDRIVERPREEMPTIVE_TESTINGPREEMPTIVE_TRANSIMPORTPREEMPTIVE_UNMARSHALPROPAGATIONTOKENPREEMPTIVE_VSS_CREATESNAPSHOTPREEMPTIVE_VSS_CREATEVOLUMESNAPSHOTPREEMPTIVE_XE_CALLBACKEXECUTEPREEMPTIVE_XE_CX_FILE_OPENPREEMPTIVE_XE_CX_HTTP_CALLPREEMPTIVE_XE_DISPATCHERPREEMPTIVE_XE_ENGINEINITPREEMPTIVE_XE_GETTARGETSTATEPREEMPTIVE_XE_SESSIONCOMMITPREEMPTIVE_XE_TARGETFINALIZEPREEMPTIVE_XE_TARGETINITPREEMPTIVE_XE_TIMERRUNPREEMPTIVE_XETESTINGPRINT_ROLLBACK_PROGRESSPRU_ROLLBACK_DEFERREDPWAIT_ALL_COMPONENTS_INITIALIZEDPWAIT_COOP_SCANPWAIT_DIRECTLOGCONSUMER_GETNEXTPWAIT_EVENT_SESSION_INIT_MUTEXPWAIT_FABRIC_REPLICA_CONTROLLER_DATA_LOSSPWAIT_HADR_ACTION_COMPLETEDPWAIT_HADR_CHANGE_NOTIFIER_TERMINATION_SYNCPWAIT_HADR_CLUSTER_INTEGRATIONPWAIT_HADR_FAILOVER_COMPLETEDPWAIT_HADR_JOINPWAIT_HADR_OFFLINE_COMPLETEDPWAIT_HADR_ONLINE_COMPLETEDPWAIT_HADR_POST_ONLINE_COMPLETEDPWAIT_HADR_SERVER_READY_CONNECTIONSPWAIT_HADR_WORKITEM_COMPLETEDPWAIT_HADRSIMPWAIT_LOG_CONSOLIDATION_IOPWAIT_LOG_CONSOLIDATION_POLLPWAIT_MD_LOGIN_STATSPWAIT_MD_RELATION_CACHEPWAIT_MD_SERVER_CACHEPWAIT_MD_UPGRADE_CONFIGPWAIT_PREEMPTIVE_AUDIT_ACCESS_WINDOWSLOGPWAIT_QRY_BPMEMORYPWAIT_REPLICA_ONLINE_INIT_MUTEXPWAIT_RESOURCE_SEMAPHORE_FT_PARALLEL_QUERY_SYNCPWAIT_SECURITY_CACHE_INVALIDATIONPWAIT_XTP_FSSTORAGE_MAINTENANCEPWAIT_XTP_HOST_STORAGE_WAIT
Q
(Back to top)QDS_ASYNC_CHECK_CONSISTENCY_TASKQDS_ASYNC_PERSIST_TASKQDS_ASYNC_PERSIST_TASK_STARTQDS_ASYNC_QUEUEQDS_BCKG_TASKQDS_BLOOM_FILTERQDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEPQDS_CTXSQDS_DB_DISKQDS_DYN_VECTORQDS_EXCLUSIVE_ACCESSQDS_LOADDBQDS_PERSIST_TASK_MAIN_LOOP_SLEEPQDS_QDS_CAPTURE_INITQDS_SHUTDOWN_QUEUEQDS_STMTQDS_STMT_DISKQDS_TASK_SHUTDOWNQDS_TASK_STARTQE_WARN_LIST_SYNCQNMANAGER_ACQUIREQPJOB_KILLQPJOB_WAITFOR_ABORTQRY_MEM_GRANT_INFO_MUTEXQRY_PARALLEL_THREAD_MUTEXQUERY_ERRHDL_SERVICE_DONEQUERY_EXECUTION_INDEX_SORT_EVENT_OPENQUERY_NOTIFICATION_MGR_MUTEXQUERY_NOTIFICATION_SUBSCRIPTION_MUTEXQUERY_NOTIFICATION_TABLE_MGR_MUTEXQUERY_NOTIFICATION_UNITTEST_MUTEXQUERY_OPTIMIZER_PRINT_MUTEXQUERY_TASK_ENQUEUE_MUTEXQUERY_TRACEOUTQUERY_WAIT_ERRHDL_SERVICE
R
(Back to top)RECOVER_CHANGEDBRECOVERY_MGR_LOCKREDO_THREAD_PENDING_WORKREDO_THREAD_SYNCREMOTE_DATA_ARCHIVE_MIGRATION_DMVREMOTE_DATA_ARCHIVE_SCHEMA_DMVREMOTE_DATA_ARCHIVE_SCHEMA_TASK_QUEUEREPL_CACHE_ACCESSREPL_HISTORYCACHE_ACCESSREPL_SCHEMA_ACCESSREPL_TRANFSINFO_ACCESSREPL_TRANHASHTABLE_ACCESSREPL_TRANTEXTINFO_ACCESSREPLICA_WRITESREQUEST_DISPENSER_PAUSEREQUEST_FOR_DEADLOCK_SEARCHRESERVED_MEMORY_ALLOCATION_EXTRESMGR_THROTTLEDRESOURCE_GOVERNOR_IDLERESOURCE_QUEUERESOURCE_SEMAPHORERESOURCE_SEMAPHORE_MUTEXRESOURCE_SEMAPHORE_QUERY_COMPILERESOURCE_SEMAPHORE_SMALL_QUERYRG_RECONFIGROWGROUP_OP_STATSROWGROUP_VERSIONRTDATA_LIST
S
(Back to top)SATELLITE_CARGOSATELLITE_SERVICE_SETUPSATELLITE_TASKSCAN_CHAR_HASH_ARRAY_INITIALIZATIONSEC_DROP_TEMP_KEYSECURITY_CRYPTO_CONTEXT_MUTEXSECURITY_DBE_STATE_MUTEXSECURITY_KEYRING_RWLOCKSECURITY_MUTEXSECURITY_RULETABLE_MUTEXSEMPLAT_DSI_BUILDSEQUENCE_GENERATIONSEQUENTIAL_GUIDSERVER_IDLE_CHECKSERVER_RECONFIGURESESSION_WAIT_STATS_CHILDRENSHARED_DELTASTORE_CREATIONSHUTDOWNSLEEP_BPOOL_FLUSHSLEEP_BUFFERPOOL_HELPLWSLEEP_DBSTARTUPSLEEP_DCOMSTARTUPSLEEP_MASTERDBREADYSLEEP_MASTERMDREADYSLEEP_MASTERUPGRADEDSLEEP_MEMORYPOOL_ALLOCATEPAGESSLEEP_MSDBSTARTUPSLEEP_RETRY_VIRTUALALLOCSLEEP_SYSTEMTASKSLEEP_TASKSLEEP_TEMPDBSTARTUPSLEEP_WORKSPACE_ALLOCATEPAGESLO_UPDATESMSYNCSNI_CONN_DUPSNI_CRITICAL_SECTIONSNI_HTTP_ACCEPTSNI_HTTP_WAITFOR_0_DISCONSNI_LISTENER_ACCESSSNI_TASK_COMPLETIONSOAP_READSOAP_WRITESOCKETDUPLICATEQUEUE_CLEANUPSOS_CALLBACK_REMOVALSOS_DISPATCHER_MUTEXSOS_LOCALALLOCATORLISTSOS_MEMORY_TOPLEVELBLOCKALLOCATORSOS_MEMORY_USAGE_ADJUSTMENTSOS_OBJECT_STORE_DESTROY_MUTEXSOS_PHYS_PAGE_CACHESOS_PROCESS_AFFINITY_MUTEXSOS_RESERVEDMEMBLOCKLISTSOS_SCHEDULER_YIELDSOS_SMALL_PAGE_ALLOCSOS_STACKSTORE_INIT_MUTEXSOS_SYNC_TASK_ENQUEUE_EVENTSOS_VIRTUALMEMORY_LOWSOSHOST_EVENTSOSHOST_INTERNALSOSHOST_MUTEXSOSHOST_RWLOCKSOSHOST_SEMAPHORESOSHOST_SLEEPSOSHOST_TRACELOCKSOSHOST_WAITFORDONESP_PREEMPTIVE_SERVER_DIAGNOSTICS_SLEEPSP_SERVER_DIAGNOSTICS_BUFFER_ACCESSSP_SERVER_DIAGNOSTICS_INIT_MUTEXSP_SERVER_DIAGNOSTICS_SLEEPSQLCLR_APPDOMAINSQLCLR_ASSEMBLYSQLCLR_DEADLOCK_DETECTIONSQLCLR_QUANTUM_PUNISHMENTSQLSORT_NORMMUTEXSQLSORT_SORTMUTEXSQLTRACE_BUFFER_FLUSHSQLTRACE_FILE_BUFFERSQLTRACE_FILE_READ_IO_COMPLETIONSQLTRACE_FILE_WRITE_IO_COMPLETIONSQLTRACE_INCREMENTAL_FLUSH_SLEEPSQLTRACE_LOCKSQLTRACE_PENDING_BUFFER_WRITERSSQLTRACE_SHUTDOWNSQLTRACE_WAIT_ENTRIESSRVPROC_SHUTDOWNSTARTUP_DEPENDENCY_MANAGER
T
(Back to top)TDS_BANDWIDTH_STATETDS_INITTDS_PROXY_CONTAINERTEMPOBJTERMINATE_LISTENERTHREADPOOLTIMEPRIV_TIMEPERIODTRACE_EVTNOTIFTRACEWRITETRAN_MARKLATCH_DTTRAN_MARKLATCH_EXTRAN_MARKLATCH_KPTRAN_MARKLATCH_NLTRAN_MARKLATCH_SHTRAN_MARKLATCH_UPTRANSACTION_MUTEX
U
(Back to top)UCS_ENDPOINT_CHANGEUCS_MANAGERUCS_MEMORY_NOTIFICATIONUCS_SESSION_REGISTRATIONUCS_TRANSPORTUCS_TRANSPORT_STREAM_CHANGEUTIL_PAGE_ALLOC
V
(Back to top)VDI_CLIENT_COMPLETECOMMANDVDI_CLIENT_GETCOMMANDVDI_CLIENT_OPERATIONVDI_CLIENT_OTHERVERSIONING_COMMITTINGVIA_ACCEPTVIEW_DEFINITION_MUTEX
W
(Back to top)WAIT_FOR_RESULTSWAIT_SCRIPTDEPLOYMENT_REQUESTWAIT_SCRIPTDEPLOYMENT_WORKERWAIT_XTP_ASYNC_TX_COMPLETIONWAIT_XTP_CKPT_AGENT_WAKEUPWAIT_XTP_CKPT_CLOSEWAIT_XTP_CKPT_ENABLEDWAIT_XTP_CKPT_STATE_LOCKWAIT_XTP_GUESTWAIT_XTP_HOST_WAITWAIT_XTP_OFFLINE_CKPT_BEFORE_REDOWAIT_XTP_OFFLINE_CKPT_LOG_IOWAIT_XTP_OFFLINE_CKPT_NEW_LOGWAIT_XTP_PROCEDURE_ENTRYWAIT_XTP_RECOVERYWAIT_XTP_SWITCH_TO_INACTIVEWAIT_XTP_TASK_SHUTDOWNWAIT_XTP_TRAN_COMMITWAIT_XTP_TRAN_DEPENDENCYWAITFORWAITFOR_PER_QUEUEWAITFOR_TASKSHUTDOWNWAITSTAT_MUTEXWCCWINDOW_AGGREGATES_MULTIPASSWINFAB_API_CALLWINFAB_REPLICA_BUILD_OPERATIONWINFAB_REPORT_FAULTWORKTBL_DROPWRITE_COMPLETIONWRITELOG
X
(Back to top)XACT_OWN_TRANSACTIONXACT_RECLAIM_SESSIONXACTLOCKINFOXACTWORKSPACE_MUTEXXDB_CONN_DUP_HASHXDES_HISTORYXDES_OUT_OF_ORDER_LISTXDES_SNAPSHOTXDESTSVERMGRXE_BUFFERMGR_ALLPROCESSED_EVENTXE_BUFFERMGR_FREEBUF_EVENTXE_CALLBACK_LISTXE_CX_FILE_READXE_DISPATCHER_CONFIG_SESSION_LISTXE_DISPATCHER_JOINXE_DISPATCHER_WAITXE_FILE_TARGET_TVFXE_LIVE_TARGET_TVFXE_MODULEMGR_SYNCXE_OLS_LOCKXE_PACKAGE_LOCK_BACKOFFXE_SERVICES_EVENTMANUALXE_SERVICES_MUTEXXE_SERVICES_RWLOCKXE_SESSION_CREATE_SYNCXE_SESSION_FLUSHXE_SESSION_SYNCXE_STM_CREATEXE_TIMER_EVENTXE_TIMER_MUTEXXE_TIMER_TASK_DONEXIO_CREDENTIAL_MGR_RWLOCKXIO_CREDENTIAL_RWLOCKXIO_LEASE_RENEW_MGR_RWLOCKXTP_HOST_DB_COLLECTIONXTP_HOST_LOG_ACTIVITYXTP_HOST_PARALLEL_RECOVERYXTP_PREEMPTIVE_TASKXTP_TRUNCATION_LSNXTPPROC_CACHE_ACCESSXTPPROC_PARTITIONED_STACK_CREATE
Y
SQL Server Wait Types Library
标签:solution cursor event bad garbage dwr sas lun com
小编还为您整理了以下内容,可能对您也有帮助:
VS2008安装失败!Microsoft Visual Studio Web 创作组件
解决方案一:找到Office 2007的安装文件
第一步:因为除Visual Studio本身以外,VS安装过程中安装的其他附带安装的组件,基本上都是有单独安装包的。先找到Visual Studio Web 创作组件的安装包,试试单独安装能不能成功。果然,在安装DVD的\WCU\WebDesignerCore文件夹中找到了“Visual Studio Web 创作组件”的安装程序。将其复制到硬盘上并解压缩,可以发现该组件使用的是Office 2007的安装方式,运行其中的setup.exe,出现与Office 2007相同的安装程序界面。单击“立即安装”,结果出现找不到office.zh-cn文件夹中文件的对话框,选择了安装程序所在的正确位置并确定,又再一次弹出同样的窗口,安装无法继续。
第二步:仔细核对文件名,确定安装文件夹中的确有需要的文件,但为什么还是提示找不到呢?
既然这个组件使用Office 2007的安装方式,文件夹中也有office.zh-cn这个和Office 2007共有的组件,那会不会是因为Office 2007的问题,导致Visual Studio Web 创作组件无法安装呢?
第三步:打开Vista中的“程序和功能”,选择Office 2007,并单击”更改“按钮,在弹出的安装程序界面中,选择”修复“,并继续,果然不出所料,这时也出现了同样的找不到安装文件的对话框,基本确定是因为Office 2007的问题导致Visual Studio 安装失败。
第四步:这时想起来,在安装Office时,安装程序默认情况下会将安装文件缓存在系统分区的隐藏文件夹MSOCache中,安装完成后并不会将其删除。由于这个文件夹实在是太大了,平常用Office其实并不需要它,因此安装完Office之后就手动将其删除了,而在修复Office组件时,需要访问MSOCache文件夹中的安装文件,所以就出现了以上问题。以往的经验是,已删除MSOCache文件夹时,可以放入Office原来的安装光盘,即可顺利修复。于是直接放入Office 2007的安装光盘,在弹出寻找文件的对话框时,指向安装盘中office.zh-cn文件夹所在的位置(一般是光驱根目录),Office 2007被成功修复,这时再安装Visual Studio Web 创作组件,也顺利的安装上了
第五步:接下来启动Visua Studio 2008安装程序,也顺利的安装,没有再遇到问题。安装完成后可以再次删除安装Visual Studio Web 创作组件时缓存下来的MSOCache文件夹(注意是隐藏文件夹)。
至此终于找到原因,原来是因为Office 2007的安装源缓存MSOCache文件夹被用户删除导致的。只要找到Office 2007的安装文件,即可顺利安装Visual Studio Web 创作组件。
最后还要考虑一个问题,为什么指向Visual Studio Web 创作组件安装程序中的office.zh-cn文件夹无法通过验证,而Office 2007安装盘中的office.zh-cn文件就可以呢?对比两个文件夹发现,其中只有OfficeLR.cab、officemui.msi、officemui.xml三个文件不同,而前两个主要文件,仅仅是数字签名日期不同。可能是由于系统中已经安装了Office 2007,而记录了这些安装程序的哈希值,安装程序只承认Office 2007的安装文件版本,而不接受其他的版本。
解决方案二:清理office2007
第一步:使用Windows Installer 清理实用工具,清理Microsoft Office system即可。
Windows Installer 清理实用工具下载地址:http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-983a48d5e1bd/msicuu2.exe
第二步:清理有2007版office的bate版。
解决方案三:终结者(本人使用的方法,推荐哦)
据我个人经历,大概几天前吧,我试过了上述及网上其他一些乱起八糟的所有方法(可能是因为我电脑“中毒太深”,又安装过VC6.0,又安装过VS2005,还安装者office 2007),综合各方面因素考虑,与其网上四处搜罗解决方法,不如重装系统来的痛快,所以,解决方案三就是:终结者–系统重装。
在重新安装系统之后也要注意一点,首先,无可非议,office 2007应该最后安装,另外如果你要使用SQL Server 2005的话(VS2008默认安装是没安装它的),你得先安装SQL Server 2005,你可以理解成VS2008默认安装的只是SQL Server 2005的一个精简版本,所以在此提供两种方案供要使用SQL Server 2005的用户选择:
方案3.1:先单独安装SQL Server 2005,然后安装VS2008,记住,这里要自定义安装,把默认安装选项里的SQL Server 2005去掉,最后安装office 2007.
方案3.2:直接默认安装VS2008,然后到微软官方下载SQL Server Management Studio Express,具体地址可查看:http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=Microsoft%20SQL%20Server%20Management%20Studio%20Express&DisplayLang=zh-cn
用SQL Server 创建图书馆管理数据库
1、首先,在键盘上按下Ctrl+N创建一个SQL查询。
2、然后,就能利用【create database ....】关键字创建。
3、关键字写完后,写上新建的数据库名称。
4、这时,就能点击分析查看是否存在错误。
5、然后点击立即执行,可以看到命令已完成。
6、接下来,刷新数据库就能看到这个新增的【myDb】数据库,就完成了。
sql server 安装时 提示应用程序发生无法处理的异常
将C:Users<当前用户>AppDataLocalMicrosoft_Corporation文件夹下的LandingPage.exe*文件夹删除,再运行安装程序即正常。
安装SQL2008是出现提示Could not open key
操作步骤:
解决SQL Server 2008 R2安装过程中提示Could not open key的解决方法:
以管理员身份运行CMD命令提示符,输入以下语句并运行就OK了
secedit /configure /cfg %windir%infdefltbase.inf /db defltbase.sdb /verbose
重新安装就可以了。
出现以下错误:
无法打开项 UNKNOWNComponents2E150E7796CEE1346A5A4943610AE4428FA1C0DEF3A89C74D8DB93E469D420F2。 请验证您是否具有足够的权限访问该项,或者与支持人员联系。
有关帮助信息,请单击: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.2100.60&EvtType=0xDF039760%25401201%25401
按钮:确定
该项我已经找到了 在注册表
HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionInstallerUserDataS-1-5-18Components
这个目录下,该项内容为空,属性 拒绝访问.
为何内存数据库姗姗来迟,SQL Server 2014新特性知多少
内存数据库
在传统的数据库表中,由于磁盘的物理结构,表和索引的结构为B-Tree,这就使得该类索引在大并发的OLTP环境中显得非常乏力,虽然有很多办法来解决这类问题,比如说乐观并发控制,应用程序缓存,分布式等。但成本依然会略高。而随着这些年硬件的发展,现在服务器拥有几百G内存并不罕见,此外由于NUMA架构的成熟,也消除了多CPU访问内存的瓶颈问题,因此内存数据库得以出现。
内存的学名叫做Random Access Memory(RAM),因此如其特性一样,是随机访问的,因此对于内存,对应的数据结构也会是Hash-Index,而并发的隔离方式也对应的变成了MVCC,因此内存数据库可以在同样的硬件资源下,Handle更多的并发和请求,并且不会被锁阻塞,而SQL Server 2014集成了这个强大的功能,并不像Oracle的TimesTen需要额外付费,因此结合SSD AS Buffer Pool特性,所产生的效果将会非常值得期待。
SQL Server内存数据库的表现形式
在SQL Server的Hekaton引擎由两部分组成:内存优化表和本地编译存储过程。虽然Hekaton集成进了关系数据库引擎,但访问他们的方法对于客户端是透明的,这也意味着从客户端应用程序的角度来看,并不会知道Hekaton引擎的存在。如图1所示