September 1, 2015 at 7:09 am
Hi guys,
We had this issue yesterday, for like an hour. Suddenly, our website started to get slow and get timeout errors.
After executing sp_who2 and sp_whoisactive, we found a system process blocking many other processes. Of course, it was impossible for us to kill it.
Under "Status" it said TASK MANAGER, "Login" sa, from sp_who2.
Under "sql_text" it was NULL, "program_name" empty, "open_tran_count" changed like this: 2,3,4,3,4,2,1 until it finished, and "database_name" changed from our database to master at the end, from sp_whoisactive.
Our CPU usage and memory at that moment were almost the same as any other day.
We don't do backups or execute jobs at that particular time. We don't even use "sa" account.
What could have happened? In the event viewer we've found nothing, nor in SQL server logs.
Once it finished everything was back to normal, we want to prevent this from happening again.
Regards,
Rogelio
September 3, 2015 at 6:43 am
anybody?
a colleague told me this had happened before, more than 18 months ago
so weird
December 9, 2015 at 6:14 am
Hi, it has happened again.
Do you think it can be caused by query notifications?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply