Tag Archives: fn_dump_dblog()

Posted on

How To Analyze Database Activity If You Don’t Have A Monitoring Tool Part 2

In part 1 of this series of blog posts, we started looking at how you can analyze database activity by looking at the contents of the transaction log backups. If you’ve followed the steps provided in the previous blog post, you should be able to create a worktable that contains the aggregated values of INSERTS, […]

Posted on

How To Analyze Database Activity If You Don’t Have A Monitoring Tool Part 1

You overheard your managers discussing whether or not the recent product launch was successful. The director of sales was very confident about his claims and calling it a success. The director of marketing was challenging the claims. Your new boss, the director of IT, is still trying to figure out what was happening since he just took over the […]