0

I'm going to drop a database. I want to monitor if any user is still using the database for a couple of months. Besides profiler, is there a better way to monitoring activities on a database?

u23432534
  • 1,535
  • 4
  • 20
  • 31
  • I always just like to set the database offline and wait for someone to complain, at which point setting it back online is much easier than restoring a database you've dropped. The problem with monitoring for two months (or two weeks, or 6 months) is that you never know when someone is about to use the database. For example, does 2 months cover an entire business cycle? What if the CFO only runs some report against that database at the end of every quarter, or right before fiscal year-end? – Aaron Bertrand Jun 19 '14 at 20:47
  • Also see this blog post. – Aaron Bertrand Jun 19 '14 at 21:01

0 Answers0