locked
About sql performance monitoring RRS feed

  • Question

  • Hi

    I am using SCOM 2012 R2 for my sql servers2012

    recently i saw that idera have several tools for sql monitoring . i want to know : have scom MPs like idera for performance or not?

    thanks

    Saturday, December 15, 2018 7:08 AM

Answers

  • Hi,

    Unfortunately I'm not familiar with Idera, by the looks of it, it seems to be mainly focused on database monitoring.

    SCOM does excellent work in monitoring Microsoft Operating Systems and other Microsoft back-end solutions like Exchange and SQL Server.

    If you want to know what can be monitored with the SCOM SQL Server management packs, you will find this information in the SQL Server management pack guide documentation.

    Microsoft System Center Management Pack for SQL Server
    https://www.microsoft.com/en-us/download/details.aspx?id=10631

    Since Idera does seem to be very focused on databases, it's very possible that it will offer better dashboards / performance monitoring than SCOM.

    As SCOM is not focused on a specific area like "databases", it can perform a variety of monitoring / performance monitoring but on a much wider scale.

    Since you already have SCOM, I would suggest you to check with Idera to see if you can get a trial of their monitoring software, and after some testing you can come to a better conclusion to which software would suit you better.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposed as answer by CyrAz Saturday, December 15, 2018 1:08 PM
    • Marked as answer by Stoyan ChalakovMVP Thursday, April 18, 2019 9:45 AM
    Saturday, December 15, 2018 1:02 PM

All replies

  • Hi,

    Unfortunately I'm not familiar with Idera, by the looks of it, it seems to be mainly focused on database monitoring.

    SCOM does excellent work in monitoring Microsoft Operating Systems and other Microsoft back-end solutions like Exchange and SQL Server.

    If you want to know what can be monitored with the SCOM SQL Server management packs, you will find this information in the SQL Server management pack guide documentation.

    Microsoft System Center Management Pack for SQL Server
    https://www.microsoft.com/en-us/download/details.aspx?id=10631

    Since Idera does seem to be very focused on databases, it's very possible that it will offer better dashboards / performance monitoring than SCOM.

    As SCOM is not focused on a specific area like "databases", it can perform a variety of monitoring / performance monitoring but on a much wider scale.

    Since you already have SCOM, I would suggest you to check with Idera to see if you can get a trial of their monitoring software, and after some testing you can come to a better conclusion to which software would suit you better.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    • Proposed as answer by CyrAz Saturday, December 15, 2018 1:08 PM
    • Marked as answer by Stoyan ChalakovMVP Thursday, April 18, 2019 9:45 AM
    Saturday, December 15, 2018 1:02 PM
  • Hi,

    Unfortunately I'm not familiar with Idera, by the looks of it, it seems to be mainly focused on database monitoring.

    SCOM does excellent work in monitoring Microsoft Operating Systems and other Microsoft back-end solutions like Exchange and SQL Server.

    If you want to know what can be monitored with the SCOM SQL Server management packs, you will find this information in the SQL Server management pack guide documentation.

    Microsoft System Center Management Pack for SQL Server
    https://www.microsoft.com/en-us/download/details.aspx?id=10631

    Since Idera does seem to be very focused on databases, it's very possible that it will offer better dashboards / performance monitoring than SCOM.

    As SCOM is not focused on a specific area like "databases", it can perform a variety of monitoring / performance monitoring but on a much wider scale.

    Since you already have SCOM, I would suggest you to check with Idera to see if you can get a trial of their monitoring software, and after some testing you can come to a better conclusion to which software would suit you better.

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:

    Hi thanks for your response

    I have many year SCOM and work it but I want to know have any MPs more focus  on SQL server and querys in scom or not i couldnot find.

    Because sql server is microsoft tools and i want to know have proffesional MPs on sql server or not?

    Sunday, December 16, 2018 12:43 PM
  • The only official management pack for Microsoft SQL Server is the one I mentioned in my above post.

    As I said, to get more detailed information what the SQL management pack is capable of doing, you can find this in the management pack guide SQLServerMPGuide.pdf, you can also see all the available workflows in the SQLServerMPWorkflowList.pdf.

    Both of these PDFs can be downloaded from the Microsoft System Center Management Pack for SQL Server link.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Sunday, December 16, 2018 1:10 PM
  • There is no one size fit all products. In my experience of SQL monitoring using SCOM, MS SQL Mp is a basic which will fit for our general usage.
    For commerical product likes idera, it has its value for targeting some inadequate for common free SQL monitor solution. As a result, there is no MPs like idera but SCOM with SQL MP can at least support
    1) Monitor Performance of Physical, Virtual, and Cloud Environments
    3) Alert Predictively and Avoid False Alerts
    4) View Summary of Top Issues and Alerts
    5) Monitor Application Transactions
    Roger
    Monday, December 17, 2018 2:41 AM