The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
159 views

why a session becomes a head blocker

I am troubleshooting a problem that seems to be random The problem is sometimes an application (dynamics SL) is freezing When the application is freezing , I notice there is a blocked by in SQL ...
1
vote
1answer
305 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 ...
1
vote
1answer
1k 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
369 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 ...
4
votes
1answer
804 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 ...
4
votes
1answer
8k 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
533 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
280 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 ...