The activity-monitor tag has no wiki summary.
1
vote
1answer
141 views
Monitoring real-time statistics on PostgreSQL
I need to monitor the DB performance on a distributed system with multiple databases. Some of the database servers use pgbouncer to pool connections and in those servers I can connect to pgbouncer and ...
4
votes
1answer
318 views
Exporting SQL Server 2008 R2 Activity Monitor Log
In SQL Server 2008 R2, admin users are allowed to view the Activity Monitor and under "Recent Expensive Queries", there is a list of SQL statements being ran on the server.
Is there a way to export ...
1
vote
1answer
691 views
Production SQL Server High CPU for a Single Query
I have a single query which is consuming a larger amount of CPU than I would expect in SQL 2008. I am not able to determine why the CPU is spiking for this single query.
I can trigger an ...
1
vote
1answer
273 views
Replication Broken, List Out of Sync Tables
In a master-slave setup on MySQL 5.5 on RHEL 6.1, when db replication breaks (for whatever reason), what is a good way to:
check (and alert) replication is broken?
get a list of tables that are out ...
3
votes
1answer
4k views
SQL Server Activity Monitor - Resource Waits - Logging > 1400 ms/sec, how?
I have an SQL Server 2008 R2 server. I open "Activity Monitor", and inside the "Resource Waits" category, I see that the "Logging" category is taking up more than 1400 ms/sec.
That doesn't seem to be ...
2
votes
1answer
346 views
Getting the last executed command time
I have tables stored in a Trucrypt partition and I would like to disconnect that if the users not using the mysql. There is the INFORMATION_SCHEMA.PROCESSLIST but I would like to know the users last ...
2
votes
1answer
201 views
Resource Waits: Mathematical link between Wait Time and Average Waiter Count
Just curious, per BOL
Wait Time (ms/sec) is the wait time in milliseconds for all tasks waiting for one or more resources in the category since last update.
Average Waiter Count is the number of ...
