Saturday, September 21, 2024

MS-SQL Server - Relationships (Foreign Keys), Run job duration in minutes & IO_COMPLETION

Run job duration in minutes & IO_COMPLETION.


Relationships (Foreign Keys)


https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-foreign-key-relationships?view=sql-server-ver16



https://learn.microsoft.com/en-us/answers/questions/1095362/query-that-shows-run-start-and-duration-on-sql-age


IO_COMPLETION


Occurs while waiting for I/O operations to complete. This wait type generally represents non-data page I/Os. Data page I/O completion waits appear as PAGEIOLATCH_* waits.



Thankyou



T. Amit Vaid S.

No comments: