Please or Register to create posts and topics.

1.4.4 discussions and beta test

Hello,

You can find the 2nd Beta version here

To be able to use it, you must first execute this script on your kankuru database :

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteHistory]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.DeleteHistory AS'
END
GO
ALTER PROCEDURE DeleteHistory
@TYPE CHAR(1)
, @DAYS INT
, @BATCHSIZE INT = 5000
AS
BEGIN
SET NOCOUNT ON;
DECLARE @ROWCOUNT INT = @BATCHSIZE
IF @DAYS > 0
BEGIN
SET @DAYS = @DAYS * -1
END
WHILE @ROWCOUNT > 0
BEGIN
DELETE TOP (@BATCHSIZE)
FROM dbo.k_dashboard_historique
WHERE horodatage < DATEADD(DAY, @DAYS, GETDATE())
AND typesauvegarde = @TYPE
SET @ROWCOUNT = @@ROWCOUNT
END
END
GO
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1101)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1101, 50)
END
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1102)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1102, 50)
END
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1103)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1103, 50)
END
IF NOT EXISTS (SELECT * FROM dbo.k_dashboard WHERE id = 1104)
BEGIN
INSERT INTO dbo.k_dashboard(id,valeur) VALUES (1104, 50)
END

 

Gregory Boge has reacted to this post.
Gregory Boge

What's new in this version ?

  • Dashboard history retention
  • History optimisation
  • I rewrote the query of Duplicated indexes
  • New audit : disabled indexes
  • New Kankuru Datagrid : you can now export the result in a text file. And you can reopen it later with "import file" tool
  • Kankuru Datagrid : when you filter data, this filter is still applied if you refresh data
  • Backup History & wait types uses the new Kankuru Datagrid
  • Database Mail Errorlog is now in KMO
  • Disk space is now in KMO
  • Live query profiler, database name bug fixed
  • You can click on File treemaps to get the database treemaps
  • New messagebox
  • New icons
  • Default theme updated