Hello Kankuru users,
I just released a new version of Kankuru. Here’s the changelog.
I wanted to do it for months and it’s done. The main dashboard check errorlogs, job log, active sessions and sometimes you don’t want to see some messages. For example, when a backup is successfull there is a line in the sql error log. This line is not marked as an informational message so by default Kankuru will raise an alert. You were able to ignore this message if you inserted a line in the good kankuru table. Now, you can manage these messages directly in Kankuru.
Messages are removed with a NOT LIKE instruction so you can use % as a joker but be carrefull. If you discard too much message, you won’t receive alert anymore 🙂
You can apply these filters on each Sql instance or only 1 specific server.
It should be unvisible for you but you can trust me I worked many hours to rewrite the thread factory. Kankuru is now more stable, performant and less intrusive.
Someone asked me to add active trace flags in ID Card (thanks Fred). I took the opportunity to add the memory usage.
Trace flag are selected by KMO with this commit.
Memory usage is a property exposed by SMO (PhysicalMemoryUsageInKB).
Last versions were hardcoded in Kankuru and updatable via internet. Now, last versions are in KMO.
In my current job, I worked on migration from 2008R2 to 2014, I needed a tool to check that all databases are in the good compatibility level. So I added a new column which check that there are no database with a lower compatibility level than instance. This new column is using KMO with this commit.
This dashboard is now compatible with SQL Server 2017
I also added a stop button
Table last access
In the previous post, Tonix told he had an issue with the Dashboard AlwaysOn to monitore availability groups.
I’m not sure about the bug but it seems fixed 🙂
I fixed an issue. The rss reader was reloaded each time you activated the sheet.
It’s not directly linked to Kankuru, but I’ll speak about SMO, KMO and Scriptdom in Powershell with the French Powershell User Group in june. Meetup link