How can I pump near real-time IIS log data into a SQL database?

487 Views Asked by At

Prior to Windows Server 2022 we used "Advanced Logging" to rollover a file every minute to read and save to a table. Unfortunately Microsoft has removed this tool on 2022 so we have no way to get real-time data about requests coming in across our farm. We use this for reporting, troubleshooting and load balancing.

The best option I've seen so far that wouldn't slow down IIS is using a COM registered object for IIS to send the log data to, but I'd really prefer not to go down that road. Also Microsoft says use this as a last resort only so what am I missing?

0

There are 0 best solutions below