3.SQLOS

Let us quickly learn what is SQLOS and how it works in SQL Server. 📚 ►Previous recommended sessions: 1. https://youtu.be/zN8VyLZvhQc 2. https://youtu.be/3mGq9AJUFiA 📚 ►Full course on Troubleshooting CPU Spike in SQL Server: https://youtube.com/playlist?list=PLxuuX6jGq7kmDoqafhow70kQH2l8Z_Xm0&si=lIrrZo_cqj-YYQBy 🧑‍💼►Follow me on LinkedIn - https://www.linkedin.com/in/bobirmirzo-arslanov-548960173 Watch all my playlists here: 🚀►Full course on Troubleshooting sessions: https://youtube.com/playlist?list=PLxuuX6jGq7kmlUblaWyfIh-iT5r0EWrJX&si=gC5FAhH9i6_b0waY 🚀►Full course on Encrypting connections to SQL Server- https://youtube.com/playlist?list=PLxuuX6jGq7kmqOCqYa1lFxQOKFgTfb8j8&si=bBwHhLsu6m5CjFft 🚀 ►SQL Server replication session: https://youtube.com/playlist?list=PLxuuX6jGq7km5E54qm0zc7REGXw6WD4C8&si=fQ_PVoGQ1S8SeI6X 🚀 ►SQL Server Always On Availability Group: https://youtube.com/playlist?list=PLxuuX6jGq7klnjr9OIGt8R1SN76pQzuEB&si=zZVr_sJnc7I9H8d3 🚀 ► SQL Server internals: https://youtube.com/playlist?list=PLxuuX6jGq7kk5_OkxbZ8QDZ2HFBDy2XZ2&si=U2rRfgS2y87t5SU4 🚀 ► Course in On-memory OLTP: https://youtube.com/playlist?list=PLxuuX6jGq7kmt6gfHUW5KhfXGaoSiDXOB&si=fVS1s2L6If36Zg-r Queries used: =============== SELECT scheduler_id, cpu_id, status, is_online, current_tasks_count, runnable_tasks_count, current_workers_count, pending_disk_io_count FROM sys.dm_os_schedulers SELECT r.session_id, t.task_address, task_state, start_time, --status as request_status, database_id, blocking_session_id, wait_type, wait_time, wait_resource, cpu_time, total_elapsed_time, r.scheduler_id, reads as number_of_reads, writes as number_of_writes, logical_reads as number_of_logical_reads, SUBSTRING (REPLACE (REPLACE (SUBSTRING (ST.text, (r.statement_start_offset/2) + 1, ((CASE statement_end_offset WHEN -1 THEN DATALENGTH(ST.text) ELSE r.statement_end_offset END - r.statement_start_offset)/2) + 1) , CHAR(10), ' '), CHAR(13), ' '), 1, 512) AS statement_text FROM sys.dm_exec_requests r LEFT JOIN sys.dm_os_tasks t ON t.session_id = r.session_id AND t.task_address = t.task_address CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS ST ===============