We help IT Professionals succeed at work.

SCOM Audit Collect Services DB Performance

472 Views
Last Modified: 2014-09-09
Windows Server 2012 R2

SCOM 2012 using Audit Collection Services

SQL Server 2012 for the OpsMngr Database Collector

All on the same 64bit box with two processors @ 2.7Ghz and 16GB RAM

Scenario
I have just set up ACS for the first time and learning about it.

Right now I have three servers with the Audit Collection Forwarding Service Agent installed on each of them. So they all are forwarding security audits to my Collector SQL DB.

My problem is that with only three forwarders sending events to my collector I am still seeing the "DB Backoff Threshold" and "Disconnect Threshold" maxed out. Which is causing one of my three forwarding agents to be dropped every now and again.

If you observe the screen shots I have attached you will notice that this is very odd problem to have with only three forwarding agents. Especially with such low events per second. The most traffic there has been was about 500 events according to the report shown in screenshot (Hourly_Event_Report)

So why am I having this issue when the DB_Queue (screenshot shown) is flat zero! There should be no reason for my thresholds to be maxing out and staying maxed out especially.

Please help!
Connected-Forwarders.GIF
DB-Backoff-Thresh.GIF
DB-Disconnect-Threshold.GIF
DB-Queue.GIF
Hourly-Event-Report.GIF
Incoming-Events-per-second.GIF
Comment
Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Wish there was more support for SCOM ACS somewhere on the web. Looks pretty dry out there in the www for this topic unfortunately not a lot of people talking.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.