sql server not responding

Question

Post reply

sql server not responding

aman

SSC Enthusiast

Points: 187
More actions
February 7, 2025 at 3:54 am

#4531792

SQL server became slow before I ran exec sp_updatestats

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247094 More actions · Answer 1

aman wrote:

SQL server became slow before I ran exec sp_updatestats

Is this a blog post, or are you hoping for a response?

Jeffrey Williams SSC Guru Points: 90341 More actions · Answer 2

aman wrote:

SQL server became slow before I ran exec sp_updatestats

This would be the expected behavior - is there a question?

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Mary_Jen Newbie Points: 5 More actions · Answer 3

If this is a question, then it’s possible outdated statistics were affecting query performance. However, the real issue might not just be statistics. Сheck wait stats using to see if there’s a bottleneck (CPU, IO, or blocking). Also, monitor active queries to spot long-running transactions.