Questions tagged [monitoring]
An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.
289 questions
1
vote
1
answer
24
views
How can I use Resource Governor purely as a monitoring tool?
It is clear that Resource Governor monitors how much work each group is doing. sys.dm_resource_governor_workload_groups makes this utterly obvious.
Suppose that:
I don't yet trust my ability to ...
- 6,624
1
vote
1
answer
22
views
What does the Dedicated Admin Connection offer that Resource Governor does not?
The Question
What resources does the Dedicated Admin Connection reserve that I cannot reserve myself with Resource Governor? If I were a genius with Resource Governor, could I turn the Remote DAC off ...
- 40.4k
0
votes
3
answers
253
views
Auditing/Monitoring the DBA
We have a customer that would like to make sure that certain tables are not tampered with by their DBAs for compliance reasons.
From my understanding their DBAs either do have or are able to run with ...
- 1,398
0
votes
1
answer
167
views
I am trying to monitor Azure managed cassandra nodes using Promethous and Grafana
I have setup promethous and Grafana on Azure VM to monitor Azure managed cassandra using below document.
https://learn.microsoft.com/en-us/azure/managed-instance-apache-cassandra/visualize-prometheus-...
CommunityBot
- 1
2
votes
1
answer
2k
views
MySQL innodb_row_lock_time is more than wall clock time
We recently started graphing the innodb_row_lock_time status variable in our monitoring system.
I noticed something I can't understand on a graph for a busy server:
Between 04:55PM and 04:57PM, the ...
CommunityBot
- 1
0
votes
1
answer
174
views
CPU and Hard Drive Spike for 20-30 Minutes
I'm collecting data on the performance of our Microsoft SQL 2008 server in preparation for moving it to Azure. It's a very low load server (currently max concurrent transactions max out at 3), ...
CommunityBot
- 1
-1
votes
2
answers
2k
views
How can you monitor for schema changes?
In short, I want to monitor for schema changes to a database, specifically SQL Server.
I know there are tools which can compare a database to source control, but this is not what I am looking for. I ...
1
vote
2
answers
201
views
Theoretical writes/sec limit
If I have solarwinds which has an alert set whenever we have more than 300 writes per second, and I know 300 writes per second is fine, and the writes per second often goes over 6500, how can I work ...
CommunityBot
- 1
0
votes
2
answers
204
views
Track database slow down in real time
To minimize down time and to detect database slow down early, we query the processlist table every second, and if we find the queries slowing down, we throttle the lower priority queries and execute ...
CommunityBot
- 1
2
votes
1
answer
419
views
Do canary tables make sense for Availability Groups?
For all HA or DR solutions in SQL Server, I have heard that it is smart to have a table with a timestamp column in each database and to have an Agent Job run every minute to update that timestamp with ...
- 40.4k
5
votes
1
answer
190
views
How to calculate required ressources from a baseline and what should be measured at all?
I have to deal with the following situatiuon:
Currently we have
1 cluster with 5 nodes running 10 instances (SQL Server 2008 Enterprise edition), and
1 cluster with 2 nodes running 5 instances (SQL ...
CommunityBot
- 1
0
votes
1
answer
12k
views
Which MySQL shows CPU usage?
I am monitoring MySQL server using phpMyAdmin [Status => Monitor] function. And it shows a number of useful graphs.
Which variables (or which mechanism) is phpMyAdmin using to pull this data?
ps. I ...
CommunityBot
- 1
0
votes
1
answer
228
views
"The slave is lagging behind"-mystery
I have a testing scenario with one dedicated server (6 vCore x 3.6 GHz AMD Ryzen 5 Pro 3600, RAM: 32 GB, HDD: 2 x 1000 GB Software RAID 1 if that matters) and a MySQL (MariaDB) replication setup with ...
CommunityBot
- 1
0
votes
1
answer
216
views
Client side SQL monitor for Oracle database aplications
We have custom application that connects to an Oracle database. We need a tool that is capable of running on the client machine (Windows 10/11) and is able to capture all SQL sent to the database, and ...
CommunityBot
- 1
0
votes
1
answer
191
views
What is the y-axis of this Oracle ASH Viewer?
I am investigating different monitoring software for my database, and I stumbled upon this open source ASH Viewer. I noticed in the main graph on the y-axis for resource usage, it's labeled as "Active ...
CommunityBot
- 1