I hunted around a while but couldn't find this in the KB or elsewhere.
I hunted around a while but couldn't find this in the KB or elsewhere.
Mark,
I looked some also and I think this is 120 seconds I am basing this on the file. ./iwc/tomcat/webapps/iwc/WEB-INF/classes/properties/iwc-config.properties
I am asking questions on this however as this file is outside the normal ignite_config folder that doesn't get over written on upgrades so I think a change here wouldn't keep on upgrade.
# ALERTS
com.confio.iwc.alerts.notificationTaskExecutor.keepAliveSeconds=120
I was looking for a number of characters, not a number of seconds. I'm interested in maximizing the amount of information I can stuff in there. In the project I'm currently working on, that would be msdb.dbo.sysjobhistory.message, which is defined as NVARCHAR(4000). I have to truncate it to 425 in the alert, but that loses a lot of valuable information that I'd like to include in the email generated by the alert.
I found an old email thread that provides an answer but I'm not sure it's complete:
From: Jonathan Shaulis:
When the results are placed into the CON_ALERT_DB_RESULTS table, the NAME column is only 425 characters, so the field is restricted as such.
In hunting around, I think CON_ALERT_HISTORY_RESULTS.PARAMETERNAME also needs to be taken into account, which is also 425 characters.
NAME is part of a PK which also contains two SMALLINT columns which take up 2 bytes each. SQL Server limits a PK to 900 bytes, so NAME could be expanded to a VARCHAR(896).
PARAMETERNAME is also part of a PK, which contains a BIGINT which takes up 8 bytes. So PARAMETERNAME could be expanded to VARCHAR(892).
What horrible things might happen in DPA if I were to expand both columns to 892?
m60freeman Sorry I meant to update this before. Things got busy. I did some looking and want to confirm the location of the config and how this all works before adding details.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.