An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.
2
votes
1answer
322 views
Create a custom log table in MySQL
Is it possible to create a custom log table. For example I have 10 schema and I would like to log if somebody is using the "areva" schema. I want to know the last executed command time and the user. ...
8
votes
3answers
2k views
Monitor MySQL activity per database?
What is the best way to monitor activity on each database of my server ?
I tried mtop/mytop which display activity in real time but aren't very practical to see all the queries executed on it.
I ...
15
votes
3answers
3k views
Which PowerShell technique should I use to talk to SQL Server?
I'd ultimately like to use PowerShell to replace the old KornShell scripts we use for SQL instance monitors. I'm having a hard time, though, getting my brain around all the different ways that ...
7
votes
1answer
352 views
alert when any job in a job category fails
Is it possible to set up an alert in SQL Server 2008 that will send an e-mail anytime a job in a specific category fails?
I am wondering because I would like to set up an e-mail anytime an SSRS ...
3
votes
5answers
1k views
MySQL Performance Monitoring
I already have system availability monitoring for all my MySQL instances in Nagios. I'm looking to get some trending monitoring going for activity. It'd be nice to see how all the information_schema ...
4
votes
1answer
1k views
How can I monitor the call count per stored procedure per timespan?
In order to diagnose some performance issues I would like to get a better understanding of the number of times certain procedures are called compared to the system performance. Is there a way to get ...
1
vote
1answer
141 views
Is there an Oracle rdbms monitoring API?
We have about a thousand customers with our application installed out of which 500 have an oracle database.
Monitoring the database is only one of the requirements.
Installing Oracle Enterprise ...
