Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [monitoring]

An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.

0
votes
0answers
21 views

help to monitor and trigger script which then send mail [on hold]

I need some help to run query which monitor a db account (SSMS), and once account is on a certain value, it must send me an email. I have my SELECT script I have already set up the : EXEC msdb....
3
votes
0answers
42 views

how does CXPACKETS relates to CXCONSUMER wait types?

when running a delete query to a table that has many foreign keys I get the following waits. I noticed that I have both CXPACKETS and CXCONSUMER wait types at the same time during of the execution ...
0
votes
0answers
17 views

Grafana Dashboard for postgres_exporter queries

Who uses postgres_exporter, tell me if you use https://github.com/wrouesnel/postgres_exporter/blob/master/queries.yaml ? if so, what Grafana Dashboard do you use? Thank you
0
votes
0answers
28 views

Is there a “@SkipChecks…” parameter equivalent for sp_BlitzFirst and sp_BlitzCache?

Silly question, how do I skip over certain databases when running sp_BlitzFirst and sp_BlitzCache? I'm on SQL Server 2008 R2 - Enterprise (10.50.4042.0). (I'm not sure how to get the First Responder ...
0
votes
1answer
21 views

Find Source & Details of APL Heap Table Insert

I have been running system monitor(sysmon) on Sybase ASE 15.7(SP139) on HP-UX(Itanium) with below command: sp_sysmon "00:10:00" go Observed that number of inserts are very high in any time of a day, ...
0
votes
1answer
29 views

SQL Server: how to monitor activity in several databases

I have several dbs in production and I'd like to have a high level overview of the activity. Ideally I'd like to know: number of users accessing the db per day number of inserts per table per day ...
5
votes
3answers
130 views

Is there any way to determine how many rows a transaction has modified (before the transaction ends)?

I have a ~320 million row table on which I run the following query: UPDATE my_table SET state = TRIM(state) Needless to say this has been running for 90+ hours (since thursday afternoon) and has not ...
0
votes
1answer
71 views

How to trace security_error_ring_buffer_recorded errors in SQL Server 2014 Express

Just so everyone doesn't have a high expectation of my level of knowledge on this topic, I'm not a DBA; I'm a .NET developer who has to try and figure this out by virtue of being "the one most likely ...
3
votes
2answers
241 views

MySQL crashing at about 70k open files

Server running community 8.0.14, we hit the number of open files a few days ago, so I increased the limit but after a while the server crashed with this in the error log: InnoDB: We intentionally ...
0
votes
0answers
14 views

Integrating MongoDB metrices with Cloud watch

We are hosting mongodb in AWS environment and planning to create incident in Servicenow using AWS Cloud watch alarm facility Has anyone integrated MongoDB Monitoring metrices with Cloud watch to ...
0
votes
1answer
42 views

Using SQL Server Reporting Services for monitoring database performance

I'd like to know whether it is a good idea to use SSRS for db monitoring or not? I want to check different parameters of a db such as Deadlock, page splits, and page reads/sec to improve db ...
0
votes
2answers
39 views

How full is my innodb shared table space?

How can I find out how much data is in the innodb shared table space. I have a massive shared idb file but I suspect that it contains only about 350 Gigs of data. I need to know how full it is so I ...
1
vote
1answer
16 views

Capture Extended Events Histogram only during time window

We have a problematic time window during night on the weekends. I want to set up multiple Extended Events sessions to capture some data and get insight. Most of them will target a file, which I can ...
0
votes
0answers
16 views

How can I connect the mysql enterprise monitor to its repository database with a socket?

By default the Oracle-MySQL-Monitor MEM (used to monitor MySQL Enterprise Instances) connects to its own repository database through localhost. Since we want to reduce the bindings of that database ...
0
votes
1answer
50 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), ...
0
votes
1answer
40 views

Monitoring Log-Shipping for Multiple Databases

We are setting up log-shipping for multiple databases hosted at different server and while process began, I noticed that only one SQL job is being retained at Monitoring Server. Our plan was to have ...
0
votes
2answers
36 views

MariaDB instance in cloud hit 95% CPU utilisation for 30 mins

I've got MariaDB instance in the cloud which I put live about 2 months ago. I'm new to the DBA business and I got the impression the people at the company who I run it through are learning on the hoof ...
0
votes
1answer
19 views

Monitor volume of data returned to the client application

I've identified ASYNC_NETWORK_IO as our top wait by some distance averaging between 70-77% of wait time for our client application SQL Server. This has been put forward towards the development team ...
1
vote
0answers
51 views

How to check the errorlog for important messages

I would like to receive an email every day from each of "my" SQL Servers, with information from the ErrorLog. I would like an easy way to determine if there is any important new information, that I ...
1
vote
1answer
61 views

Performance Tuning ETL

I administer a datawarehouse running on SQL Server 2016. This datawarehouse has most of its ETL processing done during a nightly load, except for a few SSIS packages that run throughout the day, then ...
0
votes
1answer
34 views

SentryOne timestamp out of sync

We are using SentryOne to monitor the servers and noticed something very peculiar. When looking at the same server data but with SentryOne software running in different timezone, the data seems to be ...
0
votes
1answer
63 views

mytop to monitor multiple mysql servers

I have multiple MySQL servers running on CentOS. I would like to use mytop to monitor real time database query activities, but do not want to install mytop locally on each of my MySQL instances. How ...
2
votes
1answer
404 views

Difference between fetched and returned tuples in postgresql

I'm facing a hard time trying to figure it out some performance problems in my database. I'm using a bunch of resources online to learn what to monitor and how to interpret that information. From ...
2
votes
1answer
76 views

Monitor source SQL code of inserts into table

I have a table with rows which should not be there, means the data is wrong according to business logic. And there is a lot of possible sources the insert statement of the "bad" row is coming from. I'...
1
vote
1answer
39 views

Monitor RAM/Memory

I'm planning to create a job that automatically gets the status of my server's RAM/memory at the time of the job's activation. My job has the command: use master insert into Rec.dbo.MemoryRec ...
1
vote
0answers
70 views

Cost / Capacity Planning: Quantify Data Ingress / Egress

To evaluate the migration of an on-prem SQL Server to a cloud-hosted VM, I want two fundamental pieces of information: The list of clients that access the on-prem DB Server. I'd like to know: client ...
0
votes
1answer
43 views

Any system tables/views to determine query volume per table

I was digging through the SQL Server system views and Windows performance counters and can't find any metrics regarding query volume PER TABLE in a given database. I am looking for any type of ...
0
votes
2answers
353 views

Tracking database and table size growth

Is there way we can get the table size and DB size growth from last one month day-wise? We are able to give the current size of DB and table size.
0
votes
1answer
51 views

Check connection details to SQL Server 2000/2005

I want to migrate some databases hosted in SQL Server 2000/2005 to SQL Server 2014. I don't have direct access to the databases and I want to know all applications connecting to it and connection ...
0
votes
0answers
47 views

Snmp monitoring in mongodb

We are planning to setup SNMP monitoring alert in our prod environment. Is it enough to give subagent field value as "true" in configuration file to start the service ? Or are there any other ...
1
vote
0answers
107 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 ...
2
votes
2answers
254 views

Oracle Standard Edition Monitoring Tools

We have 10g and 11g Oracle databases and all of them is Standard Edition. We need monitoring tools like cloud control for standard editions. Do you have any suggestions ?
0
votes
1answer
306 views

SQL Server 2017 Management Data Warehouse: collection_set_1 not working due to database trigger

The problem I have got an issue setting up Management Data Warehouse on SQL Server 2017 CU 5. The job "collection_set_1_noncached_collect_and_upload" keeps failing. It is related to the "Disk Usage" ...
1
vote
1answer
33 views

Select returns users locked or a default value for null rows

I'm don't have much knowlegde on Oracle database and used some questions from here to obtain this query: select case when ((sysdate - timestamp)*24 < 1 and returncode <> 0) then (username ...
0
votes
2answers
161 views

LOG all SQL Server queries with their durations

Is there a way to log all Microsoft SQL Server queries executed on a certain server, with their respective durations? I'd like to be able to analyze all queries will a tool like what PGBADGER does ...
0
votes
1answer
573 views

Why doesn't nodetool work on my Cassandra Cluster?

I have never been able to get nodetool to operate correctly to give me information about my cluster. We have a simple 3-node cluster of Cassandra 3.11.1 nodes running under CentOS 7.3 -- using the ...
0
votes
2answers
285 views

SQL Performance Monitor vs DMV Dynamic Management Views [closed]

We are trying to measure SQL Server Performance metrics. Is it better to record Performance Monitor (PerfMon) or DMV Dynamic Management Views to measure CPU, Memory, Buffer pages, etc? There are ...
2
votes
2answers
158 views

Long running statement not monitored by Oracle

We are trying to find out why a (pretty complicated) statement has an extremely high variance in runtime. Sometimes it just takes "minutes" (around 40-50) and sometimes it does not finish even after ...
0
votes
1answer
471 views

Show recent select queries on Firebird database file

Is there a way to log or query the n recent SELECT queries to an FDB database file? I have already tried using the MON$ and RDB$ tables but I didn't find anything useful.
0
votes
1answer
1k views

Getting Batch Requests Per Second On a Particular Database

Does anyone know how to find Batch Requests/Sec on particular database (database specific, not server level)? This is how to find Transactions/Sec on a particular database. DECLARE @Counter bigint ...
0
votes
1answer
112 views

Why my indexes monitoring status change to 'no'?

On one of my production Oracle database 11g Standard Edition I have a lot (a very lot of) indexes. Some of them (majority) are created by the application installer, others are created by me when I ...
-3
votes
2answers
202 views

SQL Server: How to set time in a human readable format

I found this useful query here and I use it to monitor SQL Server jobs. SELECT sJobHis.[server], sJobStep.database_name, SJob.name, SJob.enabled, CASE WHEN SJob.enabled = 0 THEN '0' WHEN sJobStep....
1
vote
1answer
305 views

Page life expectancy error in sql server

I am new to sql server monitoring.Basically system administrator who worked in organisation set monitoring in window server 2012R2 to monitor memory issues in sql server and I am getting following ...
1
vote
0answers
74 views

Negative values for Wait Time per Core per Sec in sp_BlitzFirst

I'm a developer in a firm that doesn't want to spend money on a DBA so i'm on my own with keeping the SQL servers healty. I checked some of Brent's videos and decided to check how hard the SQL servers ...
0
votes
0answers
66 views

Trying to monitor CPU usage; difference between last_execution_time and total_time_elapsed?

I've been using this Query in order to find the top 20 CPU usages of a day the last 2 hours. SELECT TOP 20 qs.sql_handle, qs.execution_count, qs.total_worker_time AS Total_CPU, ...
0
votes
1answer
39 views

How to get info if any Monitoring tool (DB performance Analyzer) stops working?

What is the Reason behind if SQL monitor for Production stopped working? what is the reason for this? I checked on Licensing, SQL server permissions, No Updates/Patching and Remote admin connections ...
0
votes
1answer
55 views

How to increase the size of query audit log?

I need to find the queries run against an Oracle instance. On running the query: SELECT first_load_time, sql_id, sql_fulltext FROM v$sql ORDER BY first_load_time ASC; Only ...
0
votes
1answer
191 views

Monitor and alerting tool for specific queries [closed]

I need to monitor and alert a MySQL DB which is hosted on AWS. I'd like an alert to trigger if certain SQL query criteria aren't met (e.g. SELECT * FROM my_table returns less than 100 results). What ...
1
vote
2answers
93 views

Stale monitoring errors?

After setting a cluster with 3 shards, 3 config server with 2 mongos. I see these errors in the monitoring agents Failure during discovery. What do they mean I tried to see it on the internet but ...
2
votes
1answer
164 views

Is there a way to get the isolation level from sp_whoisactive out of the xml into the plain result?

While I caught myself re-engineering the functionality of sp_who / sp_whoisactive using the sys.sysprocesses and sys.dm_exec_session views, to get an overview about running sessions and transactions ...