This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
We have certain servers in which SQL log monitors are not enabled in SCOM for instance integration service. We have checked for other DB engines SQL log monitor is enabled. Below is the screenshot:-
Where as for the integration service instance below is the screenshot:-
We have also compared the health service of two different serverand checked the difference under performance section. Below is the screenshot:-
We have Microsoft SQL Server 2014 Integration Service management pack. Is there any option through which we can enable the log monitor for Integration service.
Thanks in advance.
Regards,
Ravi Bhushan
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 66%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi,
If I understand correctly, the problem happens in "SQL Server Roles" dashboard view, and we've confirmed that server s006 is with SQL Server 2014 installed, right?
Is the server s006 in the same subnet with other normal ones? If different subnet, are the required ports opened?
In addition, is there any chance for us to try the agnostic MP as Kevin Holman mentioned below?
https://kevinholman.com/2019/06/12/how-to-transition-to-the-sql-version-agnostic-mp/
Hope the above information helps.
Alex Zhu
If the response is helpful, please click "Accept Answer" and upvote it.
Hi Alex,
Yes the server s006 is with SQL Server 2014 but issue is not with the dashboard view.
Issue is with its log monitoring for integration service instance. All the server with sql 2014 are missing the log monitoring where as for other sql server it is enabled.
Is there any way through which we can enable it or is it the design of Microsoft SQL Server 2014 Integration Service management pack in which log monitoring is not enabled. we have exported the management pack and checked its configuration where there was no sign of log monitoring.
Regards,
Ravi
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
I'm not too sure of what you are looking for, but as far as I know there is no such thing as "log files" (in the SQL Server Database sense of the term, or said otherwise "transaction logs") in SSIS, and so there obviously is no monitoring for them.