SQLTeam.com | Weblogs | Forums

Select count(*) from sys.server_audits


We have auditing established on a series of SQL Servers. It's been up and running for a couple of years now. When I run the above select statement against one particular server it goes away and never comes back; eventually I kill the query. All of the other servers return quickly with data. Any thoughts on what is going on or how to resolve this?


Discovered that a SQL Job was attempting to cycle the audit log file, got hung up and was blocking my query.