I'm working on building out my product into the cloud (azure). This would be a shared product unlike my previous product where it was installed client side. Previously, I create a logging process that logged events (like login/logoff) to a MSSQL
DB. But that had an unattended side affect of growing the DB extremely large, very quick.
I acknowledge part of the issue was the built in logging that wasn't clearing out, but it grew past the sql express size limit in days.
So I ended up removing the active logging and using event viewer for the locally installed app I created.
Now that this is going into the cloud, I'm going to have to have a better method of logging things including login attempts.
I've never done anything on this scale before. Can anyone tell me what the best way to do this would be? I'm not even sure how long I should maintain the login attempts.... Any suggestions?
