Monitor SSIS memory usage and errors in SQL Monitor?
PeterDanielsCRB
Posts: 126 Bronze 3
Hoping to find some way to more closely monitor SSIS memory usage and errors in SQL Monitor. I'm aware of the performance counters for the "SQL Server:SSIS Pipeline" object - Buffer Memory and Buffers Spooled, etc. I don't see an easy way to add these counters to SQL Monitor.
Another angle is to harvest data from the various tables in the catalog schema within the SSISDB. For example:
Gives me failed memory allocations. I'm considering turning this into a query that perhaps counts the # of error events in a time period so we can morph it into a custom metric, but it seems like a lot of work and not simple to get the time windowing functionality.
Any other ideas here?
Thanks!
-Peter
Another angle is to harvest data from the various tables in the catalog schema within the SSISDB. For example:
<div>SELECT top 100* From catalog.event_messages </div><div>where message like '%buffer manager failed%'</div><div>order by 1 desc<br></div>Gives me failed memory allocations. I'm considering turning this into a query that perhaps counts the # of error events in a time period so we can morph it into a custom metric, but it seems like a lot of work and not simple to get the time windowing functionality.
Any other ideas here?
Thanks!
-Peter
Tagged:
Answers
If those counters are in the sys.dm_os_performance_counters, you can add it as a custom metric and query the value.
Or use the query in your post as a custom metric.
If this does not answer your needs, I recommend submitting a suggestion via the SQL Monitor UserVoice Forum.
Many thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com