Server error: Server too busy (SOLVED)

system · October 8, 2013, 12:53am

IEM (TEM\Bigfix) version 9.0.777 (5 days after upgrade)

Problem (SOLVED):

Error message upon console logon, Server error: Server too busy

Fix:

This log file helped me identify the problem; \Program Files (x86)\BigFix Enterprise\BES Server\BESRelay.log

Log entry; Database Error: A database transaction encountered a deadlock and has been terminated.

Stopping ALL of the TEM services one-by-one, then re-starting MSSQL, then starting ALL of the TEM services one-by-one solved the problem.

greenb · November 22, 2013, 11:13am

(imported comment written by BrianPGreen)

If this happens to you a lot, it would be useful if you could collect the deadlock log from SQL server. I don’t have the documentation in front of me, but this looks like it’s probably correct to enable tracing:
http://sqlserverplanet.com/troubleshooting/turn-on-deadlock-trace-flag
. (Sorry for the super late response).