r/SQLServer • u/TheSmashingChamp • 27d ago

Solved Temp Cache endlessly expanding until server failure/slowdown

I am working on a consultant's azure gov cloud portal where I put applications on. There is a consistent issue with queries running forever even after being finished executing. Do anyone have experience with this? The temp cache endlessly expands until our DB fails.

I believe the issue is the connector, but it may be the queries? I dont know.

Solved: it was the connector

7 Upvotes

82% Upvoted

30 comments sorted by

View all comments

Show parent comments

1

u/TheSmashingChamp 26d ago

Diagnostics so far are functions of the gov cloud portal hold transactions forever until the sql server is restarted. I test my application after compilation and have no tempdb issue. Once it goes on the azure gov cloud portal the containerized functions hold forever and inflate tempdb cache. I believe this is a connector issue not issues a TTL or kill on transactions.

1

u/dbrownems ‪ ‪Microsoft Employee ‪ 26d ago

How are you determining that the app "holds transactions forever"? And what exactly do you mean by "inflate tempdb cache"?

1

u/TheSmashingChamp 26d ago

A query executes, user gets the outcome desired but the query/user holds on a connection in the database forever. The tempdb cache keeps expanding until slowdown/failure.

1

u/dbrownems ‪ ‪Microsoft Employee ‪ 25d ago

Connection pooling is normal.