I am having problems with frequent deadlocks on a subscription database.
I am considering enabling the snapshot isolation level for that database.
I am aware that there is an overhead on the tempDb ...

I have a lot of database, a ton of partitioned tables and many processes running on them.
In a couple of occasions I hade problems for unusable indexes or partitions of them. A bugged procedure, or a ...

I am trying to understand how Delta is monitored in log-shipping. We have log-shipping monitoring in place and I am seeing delta increases sometimes for random instances and it drops once database is ...

I would like to know how to calculate the distribution of data consumed per file in a filegroup, back to the index (HEAP, CLUSTERED, NONCLUSTERED) storing it. My intention is to define which I/O goes ...

I need to create some alerts, logging jobs and monitors on a machine that is going to run SQL Server 2012 Standard for an ERP system.
The OS will be Windows Server 2008 R2 Standard/Datacenter (if it ...

I have installed Munin for monitoring my MySQL database server. It enabled a large amount of MySQL plugins out of the box. Since running these plugins can be CPU expensive I want to limit them to the ...

I tried to use a Nagios script for monitoring the number of database connections on a Postgres database and I reached this problem: these are counted as currently open-connections and measured every 5 ...

For a monitoring script I need to count the number of open connections to a postgres database. This is done easily enough by opening up a client connection and running a count on the pg_stat_activity ...

I am in charge of monitoring, troubleshooting, tuning and optimizing a few dozens production SQL Servers 2008 R2/2012 in my company that are being run inside VMWare virtual machines.
I've requested ...

Follow up to my question "What's the owner of SqlServerAgent job for?"
Basically, I am trying to understand how to create a user-login with least privileges for CRUD-maintaining SQLServerAgent jobs ...

I'm running mongodb 1.4.7 - I've a node server set up which logs incoming requests in a logs collection:
{'u':'user123', 'l':'log data'}
In addition, once the request happens, the server will check ...

so i'm trying to installl mytop to monitor the database
i'm following this instruction :
http://www.sohailriaz.com/how-to-install-mytop-a-top-clone-for-mysql/
when i try to install it with yum i get ...

We want to programmatically detect errors in cron scheduled pg_dumps.
Apart from cheking whether or not the log file ends in "pg_dump: saving database definition":
What other tell-tale string can I ...

I have a single server running a .NET web application and a SQL Server database (2008 Standard). I'm planning to move the database onto a separate server but in order to provision the network hardware ...

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 ...

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 ...

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 ...

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 ...

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 ...