locked
Offload DirectAccess Inbox Accounting RRS feed

  • Question

  • We have an external load balanced cluster with DirectAccess running on a pair of 2012 R2 nodes.  We need the "Remote Access Reporting" usage reports, but the sqlserver.exe process is generating a significant amount of CPU usage.  Is there a way to offload the inbox accounting that is currently writing to the WID instance on the DA servers themselves perhaps to a remote SQL server?
    Monday, November 10, 2014 6:50 PM

All replies

  • Hi,

    I dont think it's possible. I've never seen the connections string to be used co connect to the WID. WID can be managed locally as described in this blog post to move DB files to a dedicated volume :

    http://simondavidhill.blogspot.fr/2013/11/moving-windows-internal-database-files.html

    Maybe we can change the number of CPU affected to WID but i'm not sure it's possible just for licencing reason. Let's try another approach and find out why your SQL Server consume so much CPU. Does WID also consume a lot of I/O? If Yes you might have not enought memory.


    BenoitS - Simple by Design http://danstoncloud.com/blogs/simplebydesign/default.aspx

    Tuesday, November 11, 2014 11:20 AM