Database performance monitoring:Key to seamless application performance

Learn how to optimize database performance, forecast database utilization trends and plan capacity effectively.

1. Database performance monitoring: The key to seamless application performance

2. Agenda DB monitoring how to: Diving into the key metrics of database servers Essential insights for the database admin Optimizing database performance in the Big Data era Forecasting database utilization trends and planning capacity

3. Availability Memory CPU Network Processes Hardware Disk Why Monitoring? Monitor business critical metrics to ensure uninterrupted service delivery Analyzing Database performance and resolve performance issues before service disruption Analyzing root cause of common performance issues and eliminating recurring issues Trend analysis to know how resources are being used and plan future upgrades

4. Supported databases

5. Supported databases

6. 1. DB monitoring how to: Diving into the key metrics of database servers

7. Availability Health Represents whether a particular database server is currently available to undertake requests. Represents the overall state of the Database server. Depends on the severity of all the other attributes. Up Down Clear Warning Critical

8. Buffer Manager stats Buffer & Cache hit ratio Page Life Expectancy Cache used per minute

9. Connection stats Connection time Number of users connected to the system Logins, Logouts per min Number of SQL batch requests received by server

10. 2. Essential insights for the database admin A. Common database problems and how to tackle them Database throws "cannot connect" error Database response is slow towards requests Not able to retrieve data when accessing a particular record in a web application B. Disaster Recovery Backup monitoring Replication monitoring

11. Discovery & mapping Database throws "cannot connect" error Network issue SQL Server configuration issue Firewall issue Client driver issue Application configuration issue Authentication and logon issue

12. Discovery & mapping Possible reasons: Not enough resources Queries taking more time to execute Database response is slow towards requests

13. MsSQL Log File & Data Files See log file and data file details for individual SQL DBs Generate reports for log and data files

14. Oracle Tablespace stats Identify used & free bytes of individual table space. Monitor Reads and Writes per min Track data files & monitor datafile auto extend

15.  MsSQL Top Queries by CPU

16.   MsSQL Top Queries by CPU

17.   MsSQL Slow running queries

18. Oracle Buffer Gets - Top 10 Queries Buffer Gets Execution Buffer Gets per Execution

19. Oracle Disk Reads - Top 10 Queries

20. Discovery & mapping Not able to retrieve data when accessing a particular record in a web application

21. MsSQL -Session details Displays the SQL server session ID running in SQL Server along with its status. Shows information on blocked request and allows user to kill user session.

22. Oracle- Session details Identify ONLINE, OFFLINE, or INVALID sessions as well as sessions initiated by specific users. Monitor number of memory sorts, table scans performed. Track physical & logical reads of the session as well as buffer cache hit ratio

23. Oracle -Session summary Know sessions wait time and its corresponding event. Track account status and user account expiry date.

24. MsSQL Top waits by waiting tasks

25. MsSQL Most Blocked Queries

26. Oracle - Lock Know which type of session lock type is being used. Track blocked session time.

27. Discovery & mapping B. Disaster recovery Backup monitoring Replication monitoring (DR) is an area of security planning that aims to protect an organization from the effects of significant negative events. Let's break down the Disaster recovery plan into:

28. Backup/Restore stats Displays the performance metric about various SQL backup set present in the SQL Server. Select Action to enable/disable monitoring, and reset status.

29. Replication stats Log shipping status Publications Subscriptions Replication agents History of agents running in the SQL server.

30. Oracle Backup jobs Know the number of running backup jobs count. Get session key along with backup status.

31. Log apply gap Get Log apply gap details for both Primary & Secondary DB. Archive log Destination stats

32. Discovery & mapping 3. Optimizing database performance in the Big Data era

33. Resource Utilization

34. Cassandra Memory Utilization Free Memory Used Memory

35. MongoDB - Connection stats Connections used Connections available

36. Redis - DB stats Number of keys Number of expired keys

37. Slow transaction

38. Cassandra - Keyspace Latency Read Latency (/min) Write Latency (/min)

39. MongoDB-Lock & Asserted errors Read Lock, Write Lock Message, User asserts

40. Redis-Connected/Blocked clients Connected clients Blocked clients

41. Disaster recovery

42. Cassandra-Cluster Node state Unreachable nodes

43. MongoDB-Replication

44. Redis-Replication

45. Discovery & mapping 4. Forecasting database utilization trends and planning capacity

46. Trend analysis report Pull at a glance report of the DB server to have a quick glance at all monitored attributes

47. Trend analysis report Pull trend analysis report for a particular attribute the DB server to have a quick glance at all monitored attributes History Report Hour of Day Report Day of Week Report Statistical Report Heat Chart

48. Compare performance attribute reports of different monitors. View & compare reports

49. Balance hardware costs with computing needs. Plan future utilization requirements. Forecast report

50. Customize with widgets Create and publish multiple dashboards Unified business view of your entire IT infrastructure Dashboards

51. Contact : eval- apm @manageengine.com Online Demo : demo. appmanager .com Quick Recap: DB monitoring how to: Diving into the key metrics of database servers Essential insights for the database admin Optimizing database performance in the Big Data era Forecasting database utilization trends and planning capacity

52. Contact : eval- apm @manageengine.com Online Demo : demo. appmanager .com