Monitoring and Analyzing Database Activity
Users are complaining about database performance problems. What do you do? If activity is high, you might enable the performance database properties, create a replica of the database on another server (especially when the servers are clustered), or move the database to a more powerful server or a less heavily used disk.
Using Statlog to Monitor Activity
How do you know activity is high? The Statlog task is daily monitoring database activity. Run by default once a day at 5 a.m., the Statlog task reports database activity for the server's databases in Database Activity Log entries that you can open from the Database - Usage and Database - Sizes views of the Log (Log.nsf). Statlog also sends ...