What are good resources for monitoring a database?
I was wondering if anyone can point me towards some good resources (websites, technical articles / magazines, books, etc.) related to database monitoring / performance?
I want to write a paper that explores what statistics are useful for monitoring a database and to whom they are useful.
So, I figured I'd ask the experts ...
(For my research, I'll focus mainly on PostgreSQL, but I'm going to collect resources from many different databases.)
Any suggestions would be appreciated, thanks!
source to share
Not sure about PostgreSQL, but I found www.sql-server-performance.com to be a wonderful resource in database setup (MS SQL Server).
Here is a page on this site that lists links to various performance related topics. http://www.sql-server-performance.com/tips/all_main.aspx
You may be able to apply some of the methods described here for PostgreSQL.
source to share
I don't think this is a question with the right answer, because your question is trying to cover the entire domain of database programming in one question.
In most cases, database vendors produce a good set of tools for monitoring analysis goals. Example: Oracle. You can also use them.
And a simple google search gave me hundreds of good resources that seem to fit your question.
source to share