Question : I have a query: SELECT * FROM OPENQUERY ( oracle, ‘SELECT * FROM [some_table]’ ) It runs for […]
Oracle monitoring db status
Question : I am looking for a way to monitor Oracle database status (health) via PHP script executing SQL query. […]
MySQL innodb_row_lock_time is more than wall clock time
Question : We recently started graphing the innodb_row_lock_time status variable in our monitoring system. I noticed something I can’t understand […]
Page life expectancy error in sql server
Question : I am new to sql server monitoring.Basically system administrator who worked in organisation set monitoring in window server […]
How can I extract the perfmon counter “Memory: Pages/Sec” using t-sql?
Question : I’ve googled this and so far, no luck so turning to all you awesome gurus for help. I’m […]
Stale monitoring errors?
Question : After setting a cluster with 3 shards, 3 config server with 2 mongos. I see these errors in […]
What is connection time?
Question : We are currently trialling ManageEngine SQLDBManager Plus. On the dashboard for a server it shows connection time in […]
SQL Performance Monitor vs DMV Dynamic Management Views [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Replication Monitor Missing Subscriptions in Watch List
Question : In Replication Monitor, for one of our publications (transactional replication), none of the subscriptions are showing up in […]
sp_HumanEvents @event_type = N’blocking’ and logging job help needed
Question : Those who use excellent sp_HumanEvents, maybe the author himself, please help me understand something I am missing (cause […]