MSSQL

HOW TO: Find Currently Running Long SQL Agent Jobs

HOW TO: Find Currently Running Long SQL Agent Jobs

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I’ve been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you want the opportunity(…)

VM Snapshots and Performance or: How I Learned to Love My Martian Data Center

VM Snapshots and Performance or: How I Learned to Love My Martian Data Center

It takes a radio signal just about 1.28 seconds to get to the Moon (about 239,000 miles away), and about 2.5 seconds for round trip communication between our secret moon base and Earth. So, therefore this common SQL Server error message number 833… SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15(…)

Load More