Comment observer finement le grossissement des tables de la base OperationsManager ?

Le script suivant donne l’utilisation par table

 

SELECT so.name,

8 * Sum(CASE WHEN si.indid IN (0, 1) THEN si.reserved END) AS data_kb,

Coalesce(8 * Sum(CASE WHEN si.indid NOT IN (0, 1, 255) THEN si.reserved END), 0) AS index_kb,

Coalesce(8 * Sum(CASE WHEN si.indid IN (255) THEN si.reserved END), 0) AS blob_kb

FROM dbo.sysobjects AS so JOIN dbo.sysindexes AS si ON (si.id = so.id)

WHERE 'U' = so.type GROUP BY so.name  ORDER BY data_kb DESC

 

 

Le script suivant donne la liste des alertes les plus fréquentes avec le MP "responsable" des alertes

 

select messageid, ltvalue, count(*) as Count from publishermessages with(nolock)

inner join localizedtext with(nolock)

on messagestringId = localizedtext.ltstringid

group by messageid, ltvalue

order by Count DESC

 

 

Pour faire une statistique du nombre de ligne ajoutée chaque jour dans la base

 

SELECT

DATEPART(mm,timeadded) AS 'MONTH',

DATEPART(dd,timeadded) AS 'DAY',

count(*)

from localizedtext with(nolock)

group by

DATEPART(mm,timeadded),

DATEPART(dd,timeadded)

order by

DATEPART(mm,timeadded),

DATEPART(dd,timeadded)