An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.
0
votes
0answers
12 views
Mysql slow.log with noindex, but without tmp_tables
Is it possible to change anything in config to logging in slow log queries without index use, but not in the temporary tables. I have a lot enough subquerys, so it creating anytime temporary table, ...
-8
votes
2answers
165 views
How can I check for SQL Server performance problems using T-SQL? [closed]
I know how to use the Profiler, Performance Monitor, and Activity Monitor. I want to find a way to troubleshoot performance using T-SQL. How can I check for Microsoft SQL Server performance problems ...
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 ...
0
votes
0answers
104 views
Need help! Interpreting INNODB MONITOR OUTPUT for Prestashop performance problems
We use a INNODB MYSQL Engine driven Database for hosting a Prestashop Version 1.5.3.1 on debian with apache2 webserver. We are facing performance problems, maybe some missconfigurations. There is a ...
1
vote
1answer
205 views
What are some best monitoring tools available for mysql? [duplicate]
I have a setup a linux mysql server and would like to monitor it. I found percona plugins for nagios and cacti. Are there any other tools available?
0
votes
0answers
220 views
How to display Oracle Enterprise Manager 11g (OEM) alerts and reports in Nagios?
I am working on a project that requires an unobtrusive integration of OEM data into a Nagios front-end. I know there are ways to use SNMP traps to do this, but I am not completely familiar with how ...
1
vote
1answer
182 views
How to get CPU usage of PostgreSQL server?
I'm reading about PostgreSQL monitoring tool. I get a lot of information like database size etc. but can't find info about CPU and memory usage.
Are these informations provided by PostgreSQL server or ...
1
vote
3answers
47 views
Live monitoring SQL statements on SQL Server
How can i monitor running SQL Statements for my SQL-Server, is it possible using only SQL Server without 3rd part tools?
As an alternative can anybody recommend any free tool which can monitor ...
0
votes
0answers
70 views
how to install zabbix agent in agent host which we are adding from server to monitor
following this site i have intsalled zabbix server and agent in centos 6.0
zabbix version :1.8.5
http://www.youtube.com/watch?v=sKfYm-3thRM
but i am unable to add agent that is how to add other ...
1
vote
1answer
169 views
Bandwidth usage in Sql Server
Our compagny has a central Sql Server Database which is connected to many applications (Web, Backend/Frontend services, backoffice, ..) This database is hosted in a small country (for taxing ...
0
votes
2answers
313 views
How can you monitor if MySQL binlog files get corrupted?
I was wondering if there was any nice way to continuously monitor mysql master binlog files and detect if get corrupted.
2
votes
1answer
406 views
Collect performance information on high CPU condition in SQL Server
I have a SQL server cluster that is often reaching 100% CPU out of working hours. I want to gather some information to help troubleshooting when the actual condition is taking place.
I'm thinking of ...
2
votes
1answer
213 views
How to monitor INSERT failures?
An application INSERTS a parent record then child objects. Both these procedure call different stored procedures. Parent can have many child objects. Typically both parent and child would be inserted ...
1
vote
1answer
184 views
Using sys.dm_os_performance_counters and DIFF to display logins per second
PROBLEM
Running my script below i can see the number of logins as an accumulated number to my instance:
SELECT cntr_value AS [LoginsPerSec]
FROM sys.dm_os_performance_counters
WHERE
...
4
votes
4answers
193 views
Recommendation for free event monitoring software
I'm seeking recommendations for free / open event monitoring tools. HPOV costs continue to multiply like so many wet gremlins, and we've had enough.
There are some interesting suggestions in this ...
6
votes
1answer
197 views
Can SQL Express be used as a Log Shipping monitor server?
I'm keen to setup a "Monitor Server".
We have SQL 2008 R2 Enterprise edition on both primary and secondary servers.
Can we use SQL Express in monitoring server setup for licencing purposes?
3
votes
1answer
257 views
How to break out of error loop in transactional replication?
I was running some simple tests on a publisher and subscriber on the same instance:
I inserted 50,000 rows into a published article and the data was
correctly pushed to the subscriber.
I ...
1
vote
1answer
186 views
What is connection time?
We are currently trialling ManageEngine SQLDBManager Plus. On the dashboard for a server it shows connection time in milliseconds (currently 15ms).
Can anyone tell me what Connection Time represents ...
1
vote
1answer
532 views
Realtime SQL Server Monitoring Tools? [closed]
We been having a lot of sql server performance problems lately. I've recently been digging into performance analysis using the variety of DMVs. I've definitely found some interesting things. ...
1
vote
1answer
270 views
replication warning: transactional replication latency alert not working
I have set up a predefined replication alert (as outlined here) in SQL Server 2008 and the alert for Replication Warning: Transactional replication latency does not appear to work. This is triggered ...
4
votes
2answers
426 views
replication monitor: why is current average performance poor?
I am a replication rookie. We have a very simple transactional replication set up in SQL Server. I am looking at the Replication Monitor on the subscriber and one of my subscriptions show Poor ...
7
votes
1answer
371 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 ...
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 ...
6
votes
1answer
166 views
Is there a quickish, straighforward way to measure Transactions Per Second on SQL Server 2000?
The sys.dm_os_performance_counters DMV introduced in SQL Server 2005 makes this task somewhat trivial. However, my Google-Fu has been blocked in finding a way to do this in SQL Server 2000.
How can ...
2
votes
5answers
2k views
How to check the status of SQL Server?
I need to check the status of SQL Server. When I say status its not the status for each database, but rather for the whole SQL Server.
I need to know what are the queries running in the server and ...
6
votes
2answers
981 views
View Postgresql Memory Usage
I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
3
votes
1answer
854 views
DB2 9.5 How to get tablespace monitor information?
How can I get information about tablespace in DB2 9.5?
I need to review information about if the autoresize option is enabled or disabled.
1
vote
1answer
484 views
How do you monitor specific SQL statement of a specific user ?
We have a few standalone users here which cause high server loads for several 11.1.0.7 Oracle's.
I spoke with them a few times but it seems that their queries are causing high loads and probably ...
6
votes
5answers
1k views
How can I profile SQL Azure?
I am writing a web site that uses SQL Azure heavily. However, it is painfully slow.
Is there an easy way to profile the live SQL Azure instance?
2
votes
4answers
248 views
What “tool” to use for monitoring instances and where to store this data?
I have three SQL Server instances in my DW project, development, test and production. I also have two SSIS servers (dev/test, production). My intention is to query data from these three SQL Server ...
1
vote
1answer
149 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 ...
1
vote
5answers
548 views
MySQL Replication monitoring [closed]
Im looking for a tool that could help me and my team monitor our MySQL Replication.
I would love for a tool that could alert me if
Seconds_Behind_Master passes a threshold
Slave_SQL_running is ...
3
votes
1answer
748 views
How to find the detail cpu high process name which occupying most resource in the SQL Server database?
I'm running into a problem when using the following SQL to identify CPU usage in the production SQL Server 2005 env.
DECLARE @ts_now bigint;
SELECT @ts_now = cpu_ticks / CONVERT(float, ...
1
vote
1answer
754 views
Oracle Script For Getting Long Active Sessions
Is there any script that you could provide for v$session? I seem to be encountering an issue in which my oracle active sessions are filled up. This is when I do
SELECT * FROM V$SESSION WHERE STATUS = ...
2
votes
1answer
335 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 ...
2
votes
1answer
3k views
How to monitor backup jobs on Oracle 11g?
Background:
I'm trying to monitor that backups run as expected on several databases. Zenoss is used to monitor most other stuff.
A couple of KPIs are already monitored using Zenoss in combination ...
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 ...
3
votes
1answer
1k views
How do you read MySQL InnoDB Monitor output?
I am new to DB Administration. I am trying to figure out the cause of deadlock exceptions, but I am unable to make sense of the logs.
The log says that "transaction 1 is rolled back". Why is this the ...
2
votes
3answers
369 views
Tool to monitor database data
I would like to tool that when record data changed inside all tables. so later i would get a report like
table user
added record - 3,user3..
deleted record - 2,user2..
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 ...
1
vote
1answer
440 views
How can I get the maxium number of concurrent connections to MySQL over a specific time interval?
I have a monitoring app that checks MySQL's Threads_connected and Max_used_connections variables every X seconds.
Neither of these variables tells me what I want to know: The highest number of ...
7
votes
2answers
2k views
How can I have SQL Server email me the error details when a job fails?
SQL Server lets you configure a job to send email alerts when it fails. This is a simple and effective way to monitor your jobs. However, these alerts do not include any detail--just a success or ...
5
votes
5answers
1k views
Are there any good tools for monitoring postgresql databases
I am planing to have very soon few highly loaded postgresql databases. I have some expirience managing mysql databases with high load, but now we have to use postgresql.
I want to know what are the ...
1
vote
1answer
392 views
oracle monitoring db status
I am looking for a way to monitor Oracle Database status (health) via PHP script executing SQL query. There are system variables containing actual number of connection, sessions, work load, etc...
...
2
votes
3answers
2k views
Script to Monitor MySQL Replication
G'Day,
I am looking for a bash script (using Perl - As that is already installed on the machine and I don't want to have to install Ruby, Python etc. just for this requirement) that will perform some ...
6
votes
1answer
783 views
What are some important MySQL status variables to keep an eye on? [closed]
I'm a fairly new DBA with a programming background. As such, I like to build tools to manage tasks to help me familiarize myself with the intricacies of a technology.
In this case, I am managing ...
13
votes
3answers
10k views
How to find the latest SQL statements within the database?
I like to get the latest executed statements within my database, along with performance indicators.
As such, I like to know, which SQL statements were most CPU/DISK intensive.
