BJJ

Mssql: Failed To Fetch Info Data (or No Data For 30m) [DIRECT 2026]

By November 26, 2022January 5th, 2023No Comments

Mssql: Failed To Fetch Info Data (or No Data For 30m) [DIRECT 2026]

On Linux-based monitoring agents, the ODBC Driver for SQL Server and mssql-tools must be correctly installed to execute remote queries.

| Category | Specific Cause | |----------|----------------| | | Network firewall dropping long‑living connections; DNS resolution issues; Azure SQL Gateway timeout. | | Query Performance | Blocking queries, deadlocks, or an inefficient sys.dm_os_performance_counters query that exceeds 30 min. | | Resource Exhaustion | TempDB full, transaction log full, or memory pressure stalling system DMV responses. | | Monitoring Agent Behavior | Hardcoded 30‑min socket timeout; missing retry logic; synchronous fetch from a busy sys.dm_exec_requests . | | SQL Server Configuration | remote query timeout set to 0 (unlimited) causing indefinite wait; query wait high. | | External Dependencies | Anti‑virus scanning .mdf/.ldf files; backup job holding shared locks on system tables. | mssql: failed to fetch info data (or no data for 30m)

If the SQL Server looks healthy, the issue may be with the monitoring agent itself. On Linux-based monitoring agents, the ODBC Driver for

Ritchie Yip

Ritchie Yip

Ritchie Yip is the Head Instructor for InFighting Training Centers located in Downtown Vancouver and Brentwood Burnaby. InFighting Training Centers offers programs in Kickboxing, Brazilian Jiu Jitsu, Bootcamp Conditioning Classes and Personal Training

mssql: failed to fetch info data (or no data for 30m)

Article by

Ritchie Yip

Ritchie Yip is a life long martial artist, BJJ Black Belt, and the head instructor of the InFighting Martial Arts Gym in Burnaby, British Columbia, Canada.

Do you live in the Greater Vancouver, or Brentwood Burnaby area?
Are you looking for a BJJ program specifically designed for the absolute beginner? Then, come check out our world class 7,000 sq ft facility directly across the street from the Amazing Brentwood Mall. 😃

Let’s Get Started
mssql: failed to fetch info data (or no data for 30m)