Лучший отвечающий
Размер базы в MOM 2005
Вопрос
-
База OnePoint, созданная MOM 2005 выросла до 50 ГБ
Возможно ли ограничить размер базы или количество хранимых событий?30 июня 2009 г. 6:32
Ответы
-
Судя по размерам таблиц - проблема не в груминге. Скорее это похоже на слишком большое количество собираемых данных. Давайте посмотрим, кто генерирует самое большое количество данных:
SELECT CONVERT(char(10), TimeGenerated, 101) AS "Events Date (by Day)", COUNT(*) AS "Number of Events"
FROM SDKEventView
GROUP BY CONVERT(char(10), TimeGenerated, 101)
ORDER BY "Events Date (by Day)" DESCSELECT NTEventID, COUNT(*) AS "Numver of Events"
FROM SDKEventView
GROUP BY NTEventID
ORDER BY "Numver of Events" DESC
иselect performanceobjectname, performancecountername, count(performanceobjectname) as 'count'
from sdkperformanceview
where computername = 'COMPUTERNAME'
group by performanceobjectname, performancecountername
order by 'count' desc
http://OpsMgr.ru/- Помечено в качестве ответа katbert 2 июля 2009 г. 17:04
2 июля 2009 г. 6:57Отвечающий -
Конечно. Нужно подставлять реальное имя.
Десять миллионов событий с ID 25261 и полмиллиона событий 9548 - явно много. У вас все признаки алерт шторма. Найдите правило, которое отвечает за это событие и отключите или исправьте причину...
http://OpsMgr.ru/- Помечено в качестве ответа katbert 2 июля 2009 г. 17:04
2 июля 2009 г. 9:09Отвечающий
Все ответы
-
30 июня 2009 г. 6:45Отвечающий
-
Да, погуглив я разобрался что должен быть настроен Database Grooming
Однако на SQL-сервер отсутствует задание для агента, который этот самый grooming должен делать
Есть ли способ восстановить родное задание?30 июня 2009 г. 6:50 -
http://systemcentercommunity.com/forums/p/1140/3318.aspx
http://OpsMgr.ru/30 июня 2009 г. 6:54Отвечающий -
Job воссоздал, при запуске вручную он отработал за 17 секунд и успешно завершился
Размер файла с БД не уменьшился30 июня 2009 г. 10:50 -
В SQL посмотрите, сколько реально свободного места в этом файле? Я не помню, давно уже МОМ2005 не видел, но вроде как shrink эти джобы не делали никогда...
http://OpsMgr.ru/30 июня 2009 г. 10:58Отвечающий -
Свободно 0 МБ30 июня 2009 г. 11:04
-
Проверьте это:
http://support.microsoft.com/kb/929655/en-us
http://OpsMgr.ru/1 июля 2009 г. 2:46Отвечающий -
В таблице Reportingsetting ничего не было1 июля 2009 г. 3:19
-
Покажите результаты запросов:
SELECT min(timestored) from sdkeventview
и
SELECT * FROM dbo.PartitionTables
http://OpsMgr.ru/1 июля 2009 г. 3:47Отвечающий -
SELECT min(timestored) from sdkeventview
время выполнения - 15 мин 12 сек
2005-12-19 19:00:06.560
SELECT * FROM dbo.PartitionTables
0992DFEE-9BA5-475D-9495-3542C608F16D 1 EventConsolidated_01 2005-12-15 00:00:00.383 2005-12-16 00:00:00.317 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 2 EventConsolidated_02 2005-12-16 00:00:00.317 2005-12-17 00:00:00.217 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 3 EventConsolidated_03 2005-12-17 00:00:00.217 2005-12-18 00:00:01.047 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 4 EventConsolidated_04 2005-12-18 00:00:01.047 2005-12-19 00:00:01.060 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 5 EventConsolidated_05 2005-12-19 00:00:01.060 2005-12-20 00:00:00.217 0 1
0992DFEE-9BA5-475D-9495-3542C608F16D 6 EventConsolidated_06 2005-12-20 00:00:00.217 2009-06-30 16:44:17.477 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 7 EventConsolidated_07 2009-06-30 16:44:17.477 2009-06-30 16:52:59.030 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 8 EventConsolidated_08 2009-06-30 16:52:59.030 2009-06-30 16:56:55.757 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 9 EventConsolidated_09 2009-06-30 16:56:55.757 2009-06-30 17:00:04.410 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 10 EventConsolidated_10 2009-06-30 17:00:04.410 2009-06-30 17:08:42.557 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 11 EventConsolidated_11 2009-06-30 17:08:42.557 2009-07-01 00:00:02.197 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 12 EventConsolidated_12 2009-07-01 00:00:02.197 2009-07-02 00:00:00.000 1 0
0992DFEE-9BA5-475D-9495-3542C608F16D 13 EventConsolidated_13 2004-12-21 00:00:01.220 2004-12-22 00:00:01.050 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 14 EventConsolidated_14 2004-12-22 00:00:01.050 2004-12-23 00:00:00.533 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 15 EventConsolidated_15 2004-12-23 00:00:00.533 2004-12-24 00:00:00.357 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 16 EventConsolidated_16 2004-12-24 00:00:00.357 2004-12-25 00:00:01.047 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 17 EventConsolidated_17 2004-12-25 00:00:01.047 2004-12-26 00:00:00.400 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 18 EventConsolidated_18 2004-12-26 00:00:00.400 2004-12-27 00:00:01.180 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 19 EventConsolidated_19 2004-12-27 00:00:01.180 2004-12-28 00:00:00.560 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 20 EventConsolidated_20 2004-12-28 00:00:00.560 2004-12-29 00:00:00.217 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 21 EventConsolidated_21 2004-12-29 00:00:00.217 2004-12-30 00:00:01.213 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 22 EventConsolidated_22 2004-12-30 00:00:01.213 2004-12-31 00:00:00.683 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 23 EventConsolidated_23 2004-12-31 00:00:00.683 2005-01-01 00:00:00.640 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 24 EventConsolidated_24 2005-01-01 00:00:00.640 2005-01-02 00:00:00.620 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 25 EventConsolidated_25 2005-01-02 00:00:00.620 2005-01-03 00:00:00.450 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 26 EventConsolidated_26 2005-01-03 00:00:00.450 2005-01-04 00:00:00.280 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 27 EventConsolidated_27 2005-01-04 00:00:00.280 2005-01-05 00:00:01.013 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 28 EventConsolidated_28 2005-01-05 00:00:01.013 2005-01-06 00:00:00.493 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 29 EventConsolidated_29 2005-01-06 00:00:00.493 2005-01-07 00:00:00.317 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 30 EventConsolidated_30 2005-01-07 00:00:00.317 2005-01-08 00:00:01.200 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 31 EventConsolidated_31 2005-01-08 00:00:01.200 2005-01-09 00:00:00.870 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 32 EventConsolidated_32 2005-01-09 00:00:00.870 2005-01-10 00:00:00.837 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 33 EventConsolidated_33 2005-01-10 00:00:00.837 2005-01-11 00:00:00.673 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 34 EventConsolidated_34 2005-01-11 00:00:00.673 2005-01-12 00:00:00.590 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 35 EventConsolidated_35 2005-01-12 00:00:00.590 2005-01-13 00:00:00.400 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 36 EventConsolidated_36 2005-01-13 00:00:00.400 2005-01-14 00:00:00.713 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 37 EventConsolidated_37 2005-01-14 00:00:00.713 2005-01-15 00:00:00.667 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 38 EventConsolidated_38 2005-01-15 00:00:00.667 2005-01-16 00:00:00.377 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 39 EventConsolidated_39 2005-01-16 00:00:00.377 2005-01-17 00:00:00.433 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 40 EventConsolidated_40 2005-01-17 00:00:00.433 2005-01-18 00:00:00.243 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 41 EventConsolidated_41 2005-01-18 00:00:00.243 2005-01-19 00:00:00.320 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 42 EventConsolidated_42 2005-01-19 00:00:00.320 2005-01-20 00:00:00.930 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 43 EventConsolidated_43 2005-01-20 00:00:00.930 2005-01-21 00:00:00.720 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 44 EventConsolidated_44 2005-01-21 00:00:00.720 2005-01-22 00:00:00.890 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 45 EventConsolidated_45 2005-01-22 00:00:00.890 2005-01-23 00:00:00.713 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 46 EventConsolidated_46 2005-01-23 00:00:00.713 2005-01-24 00:00:00.217 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 47 EventConsolidated_47 2005-01-24 00:00:00.217 2005-01-25 00:00:01.197 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 48 EventConsolidated_48 2005-01-25 00:00:01.197 2005-01-26 00:00:01.127 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 49 EventConsolidated_49 2005-01-26 00:00:01.127 2005-01-27 00:00:01.040 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 50 EventConsolidated_50 2005-01-27 00:00:01.040 2005-01-28 00:00:01.027 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 51 EventConsolidated_51 2005-01-28 00:00:01.027 2005-01-29 00:00:01.093 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 52 EventConsolidated_52 2005-01-29 00:00:01.093 2005-01-30 00:00:00.643 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 53 EventConsolidated_53 2005-01-30 00:00:00.643 2005-01-31 00:00:00.700 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 54 EventConsolidated_54 2005-01-31 00:00:00.700 2005-12-08 00:00:01.153 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 55 EventConsolidated_55 2005-12-08 00:00:01.153 2005-12-09 00:00:00.267 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 56 EventConsolidated_56 2005-12-09 00:00:00.267 2005-12-10 00:00:01.103 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 57 EventConsolidated_57 2005-12-10 00:00:01.103 2005-12-11 00:00:00.617 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 58 EventConsolidated_58 2005-12-11 00:00:00.617 2005-12-12 00:00:00.600 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 59 EventConsolidated_59 2005-12-12 00:00:00.600 2005-12-13 00:00:00.510 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 60 EventConsolidated_60 2005-12-13 00:00:00.510 2005-12-14 00:00:00.440 0 0
0992DFEE-9BA5-475D-9495-3542C608F16D 61 EventConsolidated_61 2005-12-14 00:00:00.440 2005-12-15 00:00:00.383 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 1 EventParam_01 2005-12-15 00:00:00.383 2005-12-16 00:00:00.317 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 2 EventParam_02 2005-12-16 00:00:00.317 2005-12-17 00:00:00.233 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 3 EventParam_03 2005-12-17 00:00:00.233 2005-12-18 00:00:01.063 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 4 EventParam_04 2005-12-18 00:00:01.063 2005-12-19 00:00:01.073 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 5 EventParam_05 2005-12-19 00:00:01.073 2005-12-20 00:00:00.217 0 1
B22BB5D0-0B42-4617-8489-9343A541D458 6 EventParam_06 2005-12-20 00:00:00.217 2009-06-30 16:44:17.507 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 7 EventParam_07 2009-06-30 16:44:17.507 2009-06-30 16:52:59.030 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 8 EventParam_08 2009-06-30 16:52:59.030 2009-06-30 16:56:55.773 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 9 EventParam_09 2009-06-30 16:56:55.773 2009-06-30 17:00:04.427 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 10 EventParam_10 2009-06-30 17:00:04.427 2009-06-30 17:08:42.557 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 11 EventParam_11 2009-06-30 17:08:42.557 2009-07-01 00:00:02.257 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 12 EventParam_12 2009-07-01 00:00:02.257 2009-07-02 00:00:00.000 1 0
B22BB5D0-0B42-4617-8489-9343A541D458 13 EventParam_13 2004-12-21 00:00:01.237 2004-12-22 00:00:01.063 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 14 EventParam_14 2004-12-22 00:00:01.063 2004-12-23 00:00:00.550 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 15 EventParam_15 2004-12-23 00:00:00.550 2004-12-24 00:00:00.357 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 16 EventParam_16 2004-12-24 00:00:00.357 2004-12-25 00:00:01.047 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 17 EventParam_17 2004-12-25 00:00:01.047 2004-12-26 00:00:00.417 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 18 EventParam_18 2004-12-26 00:00:00.417 2004-12-27 00:00:01.197 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 19 EventParam_19 2004-12-27 00:00:01.197 2004-12-28 00:00:00.573 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 20 EventParam_20 2004-12-28 00:00:00.573 2004-12-29 00:00:00.217 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 21 EventParam_21 2004-12-29 00:00:00.217 2004-12-30 00:00:01.213 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 22 EventParam_22 2004-12-30 00:00:01.213 2004-12-31 00:00:00.700 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 23 EventParam_23 2004-12-31 00:00:00.700 2005-01-01 00:00:00.657 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 24 EventParam_24 2005-01-01 00:00:00.657 2005-01-02 00:00:00.637 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 25 EventParam_25 2005-01-02 00:00:00.637 2005-01-03 00:00:00.467 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 26 EventParam_26 2005-01-03 00:00:00.467 2005-01-04 00:00:00.297 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 27 EventParam_27 2005-01-04 00:00:00.297 2005-01-05 00:00:01.013 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 28 EventParam_28 2005-01-05 00:00:01.013 2005-01-06 00:00:00.493 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 29 EventParam_29 2005-01-06 00:00:00.493 2005-01-07 00:00:00.330 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 30 EventParam_30 2005-01-07 00:00:00.330 2005-01-08 00:00:01.213 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 31 EventParam_31 2005-01-08 00:00:01.213 2005-01-09 00:00:00.870 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 32 EventParam_32 2005-01-09 00:00:00.870 2005-01-10 00:00:00.853 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 33 EventParam_33 2005-01-10 00:00:00.853 2005-01-11 00:00:00.690 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 34 EventParam_34 2005-01-11 00:00:00.690 2005-01-12 00:00:00.590 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 35 EventParam_35 2005-01-12 00:00:00.590 2005-01-13 00:00:00.417 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 36 EventParam_36 2005-01-13 00:00:00.417 2005-01-14 00:00:00.730 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 37 EventParam_37 2005-01-14 00:00:00.730 2005-01-15 00:00:00.667 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 38 EventParam_38 2005-01-15 00:00:00.667 2005-01-16 00:00:00.390 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 39 EventParam_39 2005-01-16 00:00:00.390 2005-01-17 00:00:00.450 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 40 EventParam_40 2005-01-17 00:00:00.450 2005-01-18 00:00:00.257 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 41 EventParam_41 2005-01-18 00:00:00.257 2005-01-19 00:00:00.320 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 42 EventParam_42 2005-01-19 00:00:00.320 2005-01-20 00:00:00.930 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 43 EventParam_43 2005-01-20 00:00:00.930 2005-01-21 00:00:00.720 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 44 EventParam_44 2005-01-21 00:00:00.720 2005-01-22 00:00:00.903 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 45 EventParam_45 2005-01-22 00:00:00.903 2005-01-23 00:00:00.730 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 46 EventParam_46 2005-01-23 00:00:00.730 2005-01-24 00:00:00.217 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 47 EventParam_47 2005-01-24 00:00:00.217 2005-01-25 00:00:01.213 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 48 EventParam_48 2005-01-25 00:00:01.213 2005-01-26 00:00:01.127 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 49 EventParam_49 2005-01-26 00:00:01.127 2005-01-27 00:00:01.057 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 50 EventParam_50 2005-01-27 00:00:01.057 2005-01-28 00:00:01.040 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 51 EventParam_51 2005-01-28 00:00:01.040 2005-01-29 00:00:01.093 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 52 EventParam_52 2005-01-29 00:00:01.093 2005-01-30 00:00:00.660 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 53 EventParam_53 2005-01-30 00:00:00.660 2005-01-31 00:00:00.717 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 54 EventParam_54 2005-01-31 00:00:00.717 2005-12-08 00:00:01.187 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 55 EventParam_55 2005-12-08 00:00:01.187 2005-12-09 00:00:00.267 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 56 EventParam_56 2005-12-09 00:00:00.267 2005-12-10 00:00:01.103 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 57 EventParam_57 2005-12-10 00:00:01.103 2005-12-11 00:00:00.633 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 58 EventParam_58 2005-12-11 00:00:00.633 2005-12-12 00:00:00.617 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 59 EventParam_59 2005-12-12 00:00:00.617 2005-12-13 00:00:00.510 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 60 EventParam_60 2005-12-13 00:00:00.510 2005-12-14 00:00:00.453 0 0
B22BB5D0-0B42-4617-8489-9343A541D458 61 EventParam_61 2005-12-14 00:00:00.453 2005-12-15 00:00:00.383 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 1 Event_01 2005-12-15 00:00:00.320 2005-12-16 00:00:00.253 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 2 Event_02 2005-12-16 00:00:00.253 2005-12-17 00:00:00.170 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 3 Event_03 2005-12-17 00:00:00.170 2005-12-18 00:00:01.000 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 4 Event_04 2005-12-18 00:00:01.000 2005-12-19 00:00:00.980 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 5 Event_05 2005-12-19 00:00:00.980 2005-12-20 00:00:00.153 0 1
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 6 Event_06 2005-12-20 00:00:00.153 2009-06-30 16:44:17.337 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 7 Event_07 2009-06-30 16:44:17.337 2009-06-30 16:52:59.013 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 8 Event_08 2009-06-30 16:52:59.013 2009-06-30 16:56:55.697 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 9 Event_09 2009-06-30 16:56:55.697 2009-06-30 17:00:04.410 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 10 Event_10 2009-06-30 17:00:04.410 2009-06-30 17:08:42.557 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 11 Event_11 2009-06-30 17:08:42.557 2009-07-01 00:00:02.053 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 12 Event_12 2009-07-01 00:00:02.053 2009-07-02 00:00:00.000 1 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 13 Event_13 2004-12-21 00:00:01.160 2004-12-22 00:00:00.987 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 14 Event_14 2004-12-22 00:00:00.987 2004-12-23 00:00:00.470 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 15 Event_15 2004-12-23 00:00:00.470 2004-12-24 00:00:00.293 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 16 Event_16 2004-12-24 00:00:00.293 2004-12-25 00:00:00.967 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 17 Event_17 2004-12-25 00:00:00.967 2004-12-26 00:00:00.340 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 18 Event_18 2004-12-26 00:00:00.340 2004-12-27 00:00:01.133 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 19 Event_19 2004-12-27 00:00:01.133 2004-12-28 00:00:00.497 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 20 Event_20 2004-12-28 00:00:00.497 2004-12-29 00:00:00.140 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 21 Event_21 2004-12-29 00:00:00.140 2004-12-30 00:00:01.150 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 22 Event_22 2004-12-30 00:00:01.150 2004-12-31 00:00:00.620 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 23 Event_23 2004-12-31 00:00:00.620 2005-01-01 00:00:00.580 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 24 Event_24 2005-01-01 00:00:00.580 2005-01-02 00:00:00.573 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 25 Event_25 2005-01-02 00:00:00.573 2005-01-03 00:00:00.390 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 26 Event_26 2005-01-03 00:00:00.390 2005-01-04 00:00:00.217 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 27 Event_27 2005-01-04 00:00:00.217 2005-01-05 00:00:00.950 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 28 Event_28 2005-01-05 00:00:00.950 2005-01-06 00:00:00.430 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 29 Event_29 2005-01-06 00:00:00.430 2005-01-07 00:00:00.270 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 30 Event_30 2005-01-07 00:00:00.270 2005-01-08 00:00:01.137 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 31 Event_31 2005-01-08 00:00:01.137 2005-01-09 00:00:00.810 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 32 Event_32 2005-01-09 00:00:00.810 2005-01-10 00:00:00.773 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 33 Event_33 2005-01-10 00:00:00.773 2005-01-11 00:00:00.610 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 34 Event_34 2005-01-11 00:00:00.610 2005-01-12 00:00:00.527 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 35 Event_35 2005-01-12 00:00:00.527 2005-01-13 00:00:00.337 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 36 Event_36 2005-01-13 00:00:00.337 2005-01-14 00:00:00.650 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 37 Event_37 2005-01-14 00:00:00.650 2005-01-15 00:00:00.603 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 38 Event_38 2005-01-15 00:00:00.603 2005-01-16 00:00:00.313 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 39 Event_39 2005-01-16 00:00:00.313 2005-01-17 00:00:00.370 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 40 Event_40 2005-01-17 00:00:00.370 2005-01-18 00:00:00.180 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 41 Event_41 2005-01-18 00:00:00.180 2005-01-19 00:00:00.260 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 42 Event_42 2005-01-19 00:00:00.260 2005-01-20 00:00:00.870 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 43 Event_43 2005-01-20 00:00:00.870 2005-01-21 00:00:00.640 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 44 Event_44 2005-01-21 00:00:00.640 2005-01-22 00:00:00.810 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 45 Event_45 2005-01-22 00:00:00.810 2005-01-23 00:00:00.633 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 46 Event_46 2005-01-23 00:00:00.633 2005-01-24 00:00:00.153 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 47 Event_47 2005-01-24 00:00:00.153 2005-01-25 00:00:01.133 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 48 Event_48 2005-01-25 00:00:01.133 2005-01-26 00:00:01.067 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 49 Event_49 2005-01-26 00:00:01.067 2005-01-27 00:00:00.977 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 50 Event_50 2005-01-27 00:00:00.977 2005-01-28 00:00:00.947 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 51 Event_51 2005-01-28 00:00:00.947 2005-01-29 00:00:01.030 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 52 Event_52 2005-01-29 00:00:01.030 2005-01-30 00:00:00.583 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 53 Event_53 2005-01-30 00:00:00.583 2005-01-31 00:00:00.640 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 54 Event_54 2005-01-31 00:00:00.640 2005-12-08 00:00:01.047 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 55 Event_55 2005-12-08 00:00:01.047 2005-12-09 00:00:00.203 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 56 Event_56 2005-12-09 00:00:00.203 2005-12-10 00:00:01.040 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 57 Event_57 2005-12-10 00:00:01.040 2005-12-11 00:00:00.523 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 58 Event_58 2005-12-11 00:00:00.523 2005-12-12 00:00:00.540 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 59 Event_59 2005-12-12 00:00:00.540 2005-12-13 00:00:00.450 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 60 Event_60 2005-12-13 00:00:00.450 2005-12-14 00:00:00.377 0 0
0636C6D1-2EDF-4F2B-86B3-A32DE4D6E1F4 61 Event_61 2005-12-14 00:00:00.377 2005-12-15 00:00:00.320 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 1 SampledNumericData_01 2005-12-15 00:00:00.383 2005-12-16 00:00:00.333 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 2 SampledNumericData_02 2005-12-16 00:00:00.333 2005-12-17 00:00:00.233 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 3 SampledNumericData_03 2005-12-17 00:00:00.233 2005-12-18 00:00:01.063 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 4 SampledNumericData_04 2005-12-18 00:00:01.063 2005-12-19 00:00:01.090 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 5 SampledNumericData_05 2005-12-19 00:00:01.090 2005-12-20 00:00:00.217 0 1
08EAC821-9D87-427B-AF13-E6F279CED304 6 SampledNumericData_06 2005-12-20 00:00:00.217 2009-06-30 16:44:17.523 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 7 SampledNumericData_07 2009-06-30 16:44:17.523 2009-06-30 16:52:59.043 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 8 SampledNumericData_08 2009-06-30 16:52:59.043 2009-06-30 16:56:55.773 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 9 SampledNumericData_09 2009-06-30 16:56:55.773 2009-06-30 17:00:04.427 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 10 SampledNumericData_10 2009-06-30 17:00:04.427 2009-06-30 17:08:42.573 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 11 SampledNumericData_11 2009-06-30 17:08:42.573 2009-07-01 00:00:02.273 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 12 SampledNumericData_12 2009-07-01 00:00:02.273 2009-07-02 00:00:00.000 1 0
08EAC821-9D87-427B-AF13-E6F279CED304 13 SampledNumericData_13 2004-12-21 00:00:01.237 2004-12-22 00:00:01.063 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 14 SampledNumericData_14 2004-12-22 00:00:01.063 2004-12-23 00:00:00.550 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 15 SampledNumericData_15 2004-12-23 00:00:00.550 2004-12-24 00:00:00.373 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 16 SampledNumericData_16 2004-12-24 00:00:00.373 2004-12-25 00:00:01.060 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 17 SampledNumericData_17 2004-12-25 00:00:01.060 2004-12-26 00:00:00.417 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 18 SampledNumericData_18 2004-12-26 00:00:00.417 2004-12-27 00:00:01.197 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 19 SampledNumericData_19 2004-12-27 00:00:01.197 2004-12-28 00:00:00.573 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 20 SampledNumericData_20 2004-12-28 00:00:00.573 2004-12-29 00:00:00.233 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 21 SampledNumericData_21 2004-12-29 00:00:00.233 2004-12-30 00:00:01.230 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 22 SampledNumericData_22 2004-12-30 00:00:01.230 2004-12-31 00:00:00.700 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 23 SampledNumericData_23 2004-12-31 00:00:00.700 2005-01-01 00:00:00.657 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 24 SampledNumericData_24 2005-01-01 00:00:00.657 2005-01-02 00:00:00.637 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 25 SampledNumericData_25 2005-01-02 00:00:00.637 2005-01-03 00:00:00.467 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 26 SampledNumericData_26 2005-01-03 00:00:00.467 2005-01-04 00:00:00.297 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 27 SampledNumericData_27 2005-01-04 00:00:00.297 2005-01-05 00:00:01.030 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 28 SampledNumericData_28 2005-01-05 00:00:01.030 2005-01-06 00:00:00.507 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 29 SampledNumericData_29 2005-01-06 00:00:00.507 2005-01-07 00:00:00.330 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 30 SampledNumericData_30 2005-01-07 00:00:00.330 2005-01-08 00:00:01.213 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 31 SampledNumericData_31 2005-01-08 00:00:01.213 2005-01-09 00:00:00.887 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 32 SampledNumericData_32 2005-01-09 00:00:00.887 2005-01-10 00:00:00.853 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 33 SampledNumericData_33 2005-01-10 00:00:00.853 2005-01-11 00:00:00.690 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 34 SampledNumericData_34 2005-01-11 00:00:00.690 2005-01-12 00:00:00.607 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 35 SampledNumericData_35 2005-01-12 00:00:00.607 2005-01-13 00:00:00.417 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 36 SampledNumericData_36 2005-01-13 00:00:00.417 2005-01-14 00:00:00.730 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 37 SampledNumericData_37 2005-01-14 00:00:00.730 2005-01-15 00:00:00.680 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 38 SampledNumericData_38 2005-01-15 00:00:00.680 2005-01-16 00:00:00.390 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 39 SampledNumericData_39 2005-01-16 00:00:00.390 2005-01-17 00:00:00.450 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 40 SampledNumericData_40 2005-01-17 00:00:00.450 2005-01-18 00:00:00.257 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 41 SampledNumericData_41 2005-01-18 00:00:00.257 2005-01-19 00:00:00.337 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 42 SampledNumericData_42 2005-01-19 00:00:00.337 2005-01-20 00:00:00.947 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 43 SampledNumericData_43 2005-01-20 00:00:00.947 2005-01-21 00:00:00.737 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 44 SampledNumericData_44 2005-01-21 00:00:00.737 2005-01-22 00:00:00.903 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 45 SampledNumericData_45 2005-01-22 00:00:00.903 2005-01-23 00:00:00.730 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 46 SampledNumericData_46 2005-01-23 00:00:00.730 2005-01-24 00:00:00.230 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 47 SampledNumericData_47 2005-01-24 00:00:00.230 2005-01-25 00:00:01.213 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 48 SampledNumericData_48 2005-01-25 00:00:01.213 2005-01-26 00:00:01.143 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 49 SampledNumericData_49 2005-01-26 00:00:01.143 2005-01-27 00:00:01.057 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 50 SampledNumericData_50 2005-01-27 00:00:01.057 2005-01-28 00:00:01.040 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 51 SampledNumericData_51 2005-01-28 00:00:01.040 2005-01-29 00:00:01.110 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 52 SampledNumericData_52 2005-01-29 00:00:01.110 2005-01-30 00:00:00.660 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 53 SampledNumericData_53 2005-01-30 00:00:00.660 2005-01-31 00:00:00.717 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 54 SampledNumericData_54 2005-01-31 00:00:00.717 2005-12-08 00:00:01.187 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 55 SampledNumericData_55 2005-12-08 00:00:01.187 2005-12-09 00:00:00.267 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 56 SampledNumericData_56 2005-12-09 00:00:00.267 2005-12-10 00:00:01.120 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 57 SampledNumericData_57 2005-12-10 00:00:01.120 2005-12-11 00:00:00.633 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 58 SampledNumericData_58 2005-12-11 00:00:00.633 2005-12-12 00:00:00.617 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 59 SampledNumericData_59 2005-12-12 00:00:00.617 2005-12-13 00:00:00.527 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 60 SampledNumericData_60 2005-12-13 00:00:00.527 2005-12-14 00:00:00.453 0 0
08EAC821-9D87-427B-AF13-E6F279CED304 61 SampledNumericData_61 2005-12-14 00:00:00.453 2005-12-15 00:00:00.383 0 01 июля 2009 г. 11:08 -
На ночь с консоли администратора MOM запустил удаление одного сервера - такой машины уже нет в живых
было сказано, что все сведения об этом компе будут удалены из БД
Всю ночь работало - не удалил, утром нажал Отмену
Сейчас размер БД 59 ГБ
Временно остановил службу MOM1 июля 2009 г. 11:14 -
Давайте посмотрим размеры:
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
http://OpsMgr.ru/2 июля 2009 г. 4:45Отвечающий -
Event_06 33310880 812744 0
SampledNumericData_06 19842456 8933584 0
EventParam_06 15621872 0 0
Event_12 80576 48 0
ProcessRuleComment 75464 1416 0
Event_11 49048 48 0
EventParam_12 39368 0 0
EventParam_11 25000 0 0
EventConsolidated_06 16768 5016 0
ProcessRule 5824 2112 7688
Alert 4560 664 0
AlertHistory 4512 768 0
SampledNumericData_12 3504 32 0
AlertToEvent 2344 832 0
ProcessRuleMembership 2048 1280 0
Attribute 1856 384 0
SampledNumericData_11 1528 32 0
Instance 832 384 0
Relationship 808 448 0
SampledNumericDataSource 768 384 0
AlertEventSuppression 744 72 0
MCF_Numbers 712 0 0
MonitorView 640 192 392
ProviderInstance 496 176 0
TaskExecution 344 0 0
ClassAttribute 296 104 0
EventSource 200 136 0
KBaseComment 192 64 456
ScopeTimestamps 176 96 0
ComputerRule 160 32 40
Computer 144 80 0
PerfmonCounterScale 128 64 0
Configuration 112 48 0
StatusAttribute 104 32 0
Script 96 32 6344
Task2 96 32 40
ProcessRuleToNotifyGroup 96 48 0
ComputerRuleToProcessRuleGroup 80 40 0
ProcessRuleToScript 64 32 0
KBase 64 0 0
RelationshipDefinition 64 32 0
User 56 32 0
RelationshipAttributeDefinition 56 32 0
AlertLevel 56 32 0
DiagramClassAttribute 56 32 0
DiagramRelationshipAttribute 56 32 0
ClassDefinition 48 16 0
Component 40 16 0
DiagramRelationshipDefinition 40 16 0
DiagramClassDefinition 40 16 0
DasServers 40 16 0
EventConsolidated_11 40 16 0
EventConsolidated_12 40 16 0
RelationshipAttribute 40 16 0
ResolutionState 40 16 0
RuleType 40 16 0
RuleTypeToProviderType 40 16 0
UserDefinedField 40 16 0
GroomJob 40 16 0
EventType 40 16 0
GroomAttribute 40 16 0
KBaseSection 40 16 0
LocalizedText 40 16 0
EventParamName 40 16 0
ComputerResponsibility 40 16 0
PartitionTables 40 0 0
ProviderType 40 16 0
NotifyGroup 40 16 0
NotifyGroupMember 40 16 0
Operator 40 16 0
MessageDll 40 16 0
GroomCoordination 32 16 0
GroomJobCriteria 32 16 0
KpcType 24 0 0
MCF_SchemaVersion 24 0 0
MCF_ChangeTypes 24 0 0
MCF_DataTypes 24 0 0
License2 24 0 0
PartitionObjects 24 0 0
Shape 24 0 1544
Diagram 24 0 0
DiagramClassAnnotation 24 0 0
DiagramClassAnnotationAttribute 24 0 0
DiagramClassAnnotationAttributeShape 24 0 0
DiagramComputerGroup 24 0 520
ComputerHeartbeat 24 0 0
ComputerMaintenance 24 0 0
TodayStatistics 16 0 0
GroomingSettings 16 0 0
GuiClass 0 0 0
License 0 0 0
KBaseHistory 0 0 0
MCF_AlertCache 0 0 0
MCF_AlertHistoryCache 0 0 0
MCF_AlertTargets 0 0 0
EventParam_07 0 0 0
EventParam_08 0 0 0
EventParam_09 0 0 0
EventParam_10 0 0 0
EventConsolidated_07 0 0 0
EventConsolidated_08 0 0 0
EventConsolidated_09 0 0 0
EventConsolidated_10 0 0 0
Event_07 0 0 0
Event_08 0 0 0
Event_09 0 0 0
Event_10 0 0 0
Overrides 0 0 0
NotifyHistory 0 0 0
MCF_DiscoveryCache 0 0 0
MCF_DiscoveryClassAttributeTargets 0 0 0
MCF_DiscoveryClassDefinitionTargets 0 0 0
MCF_DiscoveryRelationshipAttributeDefinitionTargets 0 0 0
MCF_DiscoveryRelationshipDefinitionTargets 0 0 0
MCF_Forwardees 0 0 0
MCF_NewAlertTargets 0 0 0
MCF_SuppressedAlerts 0 0 0
MCF_PendingAlertUpdates 0 0 0
MCF_RegisteredDataChanges 0 0 0
MMPC_AlertIds 0 0 0
MMPC_Config 0 0 0
MMPC_Forwardees 0 0 0
MMPC_Status 0 0 0
Vendor 0 0 0
WorkflowTimestamps 0 0 0
ReportingSettings 0 0 0
StringLocalization 0 0 0
Task 0 0 0
SampledNumericData_01 0 0 0
SampledNumericData_02 0 0 0
SampledNumericData_03 0 0 0
SampledNumericData_04 0 0 0
SampledNumericData_05 0 0 0
SampledNumericData_07 0 0 0
SampledNumericData_08 0 0 0
SampledNumericData_09 0 0 0
SampledNumericData_10 0 0 0
SampledNumericData_13 0 0 0
SampledNumericData_14 0 0 0
SampledNumericData_15 0 0 0
SampledNumericData_16 0 0 0
SampledNumericData_17 0 0 0
SampledNumericData_18 0 0 0
SampledNumericData_19 0 0 0
SampledNumericData_20 0 0 0
SampledNumericData_21 0 0 0
SampledNumericData_22 0 0 0
SampledNumericData_23 0 0 0
SampledNumericData_24 0 0 0
SampledNumericData_25 0 0 0
SampledNumericData_26 0 0 0
SampledNumericData_27 0 0 0
SampledNumericData_28 0 0 0
SampledNumericData_29 0 0 0
SampledNumericData_30 0 0 0
SampledNumericData_31 0 0 0
SampledNumericData_32 0 0 0
SampledNumericData_33 0 0 0
SampledNumericData_34 0 0 0
SampledNumericData_35 0 0 0
SampledNumericData_36 0 0 0
SampledNumericData_37 0 0 0
SampledNumericData_38 0 0 0
SampledNumericData_39 0 0 0
SampledNumericData_40 0 0 0
SampledNumericData_41 0 0 0
SampledNumericData_42 0 0 0
SampledNumericData_43 0 0 0
SampledNumericData_44 0 0 0
SampledNumericData_45 0 0 0
SampledNumericData_46 0 0 0
SampledNumericData_47 0 0 0
SampledNumericData_48 0 0 0
SampledNumericData_49 0 0 0
SampledNumericData_50 0 0 0
SampledNumericData_51 0 0 0
SampledNumericData_52 0 0 0
SampledNumericData_53 0 0 0
SampledNumericData_54 0 0 0
SampledNumericData_55 0 0 0
SampledNumericData_56 0 0 0
SampledNumericData_57 0 0 0
SampledNumericData_58 0 0 0
SampledNumericData_59 0 0 0
SampledNumericData_60 0 0 0
SampledNumericData_61 0 0 0
Akm 0 0 0
AkmToMonitorView 0 0 0
AuditLog 0 0 0
AuditLogValues 0 0 0
BackgroundImage 0 0 0
DiagramClassAttributeShape 0 0 0
dtproperties 0 0 0
Event_01 0 0 0
Event_02 0 0 0
Event_03 0 0 0
Event_04 0 0 0
Event_05 0 0 0
Event_13 0 0 0
Event_14 0 0 0
Event_15 0 0 0
Event_16 0 0 0
Event_17 0 0 0
Event_18 0 0 0
Event_19 0 0 0
Event_20 0 0 0
Event_21 0 0 0
Event_22 0 0 0
Event_23 0 0 0
Event_24 0 0 0
Event_25 0 0 0
Event_26 0 0 0
Event_27 0 0 0
Event_28 0 0 0
Event_29 0 0 0
Event_30 0 0 0
Event_31 0 0 0
Event_32 0 0 0
Event_33 0 0 0
Event_34 0 0 0
Event_35 0 0 0
Event_36 0 0 0
Event_37 0 0 0
Event_38 0 0 0
Event_39 0 0 0
Event_40 0 0 0
Event_41 0 0 0
Event_42 0 0 0
Event_43 0 0 0
Event_44 0 0 0
Event_45 0 0 0
Event_46 0 0 0
Event_47 0 0 0
Event_48 0 0 0
Event_49 0 0 0
Event_50 0 0 0
Event_51 0 0 0
Event_52 0 0 0
Event_53 0 0 0
Event_54 0 0 0
Event_55 0 0 0
Event_56 0 0 0
Event_57 0 0 0
Event_58 0 0 0
Event_59 0 0 0
Event_60 0 0 0
Event_61 0 0 0
EventConsolidated_01 0 0 0
EventConsolidated_02 0 0 0
EventConsolidated_03 0 0 0
EventConsolidated_04 0 0 0
EventConsolidated_05 0 0 0
EventConsolidated_13 0 0 0
EventConsolidated_14 0 0 0
EventConsolidated_15 0 0 0
EventConsolidated_16 0 0 0
EventConsolidated_17 0 0 0
EventConsolidated_18 0 0 0
EventConsolidated_19 0 0 0
EventConsolidated_20 0 0 0
EventConsolidated_21 0 0 0
EventConsolidated_22 0 0 0
EventConsolidated_23 0 0 0
EventConsolidated_24 0 0 0
EventConsolidated_25 0 0 0
EventConsolidated_26 0 0 0
EventConsolidated_27 0 0 0
EventConsolidated_28 0 0 0
EventConsolidated_29 0 0 0
EventConsolidated_30 0 0 0
EventConsolidated_31 0 0 0
EventConsolidated_32 0 0 0
EventConsolidated_33 0 0 0
EventConsolidated_34 0 0 0
EventConsolidated_35 0 0 0
EventConsolidated_36 0 0 0
EventConsolidated_37 0 0 0
EventConsolidated_38 0 0 0
EventConsolidated_39 0 0 0
EventConsolidated_40 0 0 0
EventConsolidated_41 0 0 0
EventConsolidated_42 0 0 0
EventConsolidated_43 0 0 0
EventConsolidated_44 0 0 0
EventConsolidated_45 0 0 0
EventConsolidated_46 0 0 0
EventConsolidated_47 0 0 0
EventConsolidated_48 0 0 0
EventConsolidated_49 0 0 0
EventConsolidated_50 0 0 0
EventConsolidated_51 0 0 0
EventConsolidated_52 0 0 0
EventConsolidated_53 0 0 0
EventConsolidated_54 0 0 0
EventConsolidated_55 0 0 0
EventConsolidated_56 0 0 0
EventConsolidated_57 0 0 0
EventConsolidated_58 0 0 0
EventConsolidated_59 0 0 0
EventConsolidated_60 0 0 0
EventConsolidated_61 0 0 0
EventParam_01 0 0 0
EventParam_02 0 0 0
EventParam_03 0 0 0
EventParam_04 0 0 0
EventParam_05 0 0 0
EventParam_13 0 0 0
EventParam_14 0 0 0
EventParam_15 0 0 0
EventParam_16 0 0 0
EventParam_17 0 0 0
EventParam_18 0 0 0
EventParam_19 0 0 0
EventParam_20 0 0 0
EventParam_21 0 0 0
EventParam_22 0 0 0
EventParam_23 0 0 0
EventParam_24 0 0 0
EventParam_25 0 0 0
EventParam_26 0 0 0
EventParam_27 0 0 0
EventParam_28 0 0 0
EventParam_29 0 0 0
EventParam_30 0 0 0
EventParam_31 0 0 0
EventParam_32 0 0 0
EventParam_33 0 0 0
EventParam_34 0 0 0
EventParam_35 0 0 0
EventParam_36 0 0 0
EventParam_37 0 0 0
EventParam_38 0 0 0
EventParam_39 0 0 0
EventParam_40 0 0 0
EventParam_41 0 0 0
EventParam_42 0 0 0
EventParam_43 0 0 0
EventParam_44 0 0 0
EventParam_45 0 0 0
EventParam_46 0 0 0
EventParam_47 0 0 0
EventParam_48 0 0 0
EventParam_49 0 0 0
EventParam_50 0 0 0
EventParam_51 0 0 0
EventParam_52 0 0 0
EventParam_53 0 0 0
EventParam_54 0 0 0
EventParam_55 0 0 0
EventParam_56 0 0 0
EventParam_57 0 0 0
EventParam_58 0 0 0
EventParam_59 0 0 0
EventParam_60 0 0 0
EventParam_61 0 0 02 июля 2009 г. 5:41 -
Судя по размерам таблиц - проблема не в груминге. Скорее это похоже на слишком большое количество собираемых данных. Давайте посмотрим, кто генерирует самое большое количество данных:
SELECT CONVERT(char(10), TimeGenerated, 101) AS "Events Date (by Day)", COUNT(*) AS "Number of Events"
FROM SDKEventView
GROUP BY CONVERT(char(10), TimeGenerated, 101)
ORDER BY "Events Date (by Day)" DESCSELECT NTEventID, COUNT(*) AS "Numver of Events"
FROM SDKEventView
GROUP BY NTEventID
ORDER BY "Numver of Events" DESC
иselect performanceobjectname, performancecountername, count(performanceobjectname) as 'count'
from sdkperformanceview
where computername = 'COMPUTERNAME'
group by performanceobjectname, performancecountername
order by 'count' desc
http://OpsMgr.ru/- Помечено в качестве ответа katbert 2 июля 2009 г. 17:04
2 июля 2009 г. 6:57Отвечающий -
SELECT CONVERT(char(10), TimeGenerated, 101) AS "Events Date (by Day)", COUNT(*) AS "Number of Events"
FROM SDKEventView
GROUP BY CONVERT(char(10), TimeGenerated, 101)
ORDER BY "Events Date (by Day)" DESC
Выполнялся 23 минуты
12/31/2008 24961
12/31/2007 2127
12/31/2006 1308
12/31/2005 785
12/30/2008 33130
12/30/2007 3182
12/30/2006 1622
12/30/2005 1491
12/29/2008 33014
12/29/2007 7569
12/29/2006 3261
12/29/2005 1662
12/28/2008 20313
12/28/2007 8183
12/28/2006 3769
12/28/2005 1653
12/27/2008 21826
12/27/2007 7235
12/27/2006 3806
12/27/2005 2247
12/26/2008 32379
12/26/2007 7996
12/26/2006 4028
12/26/2005 2717
12/25/2008 34214
12/25/2007 7633
12/25/2006 3957
12/25/2005 1036
12/24/2008 35042
12/24/2007 7544
12/24/2006 1666
12/24/2005 966
12/23/2008 33631
12/23/2007 2976
12/23/2006 1721
12/23/2005 1765
12/22/2008 33451
12/22/2007 2705
12/22/2006 3718
12/22/2005 1593
12/21/2008 19926
12/21/2007 6552
12/21/2006 3756
12/21/2005 9823
12/20/2008 19310
12/20/2007 4203
12/20/2006 3666
12/20/2005 1534
12/19/2008 30966
12/19/2007 8750
12/19/2006 3918
12/19/2005 294
12/18/2008 35312
12/18/2007 7336
12/18/2006 3829
12/18/2005 100
12/17/2008 33976
12/17/2007 6845
12/17/2006 1697
12/17/2005 63
12/16/2008 35040
12/16/2007 3433
12/16/2006 1869
12/16/2005 83
12/15/2008 34677
12/15/2007 3098
12/15/2006 3912
12/15/2005 75
12/14/2008 18169
12/14/2007 7862
12/14/2006 4118
12/14/2005 95
12/13/2008 19349
12/13/2007 7799
12/13/2006 4341
12/13/2005 100
12/12/2008 30415
12/12/2007 7776
12/12/2006 4096
12/12/2005 91
12/11/2008 37166
12/11/2007 8646
12/11/2006 4207
12/11/2005 103
12/10/2008 34831
12/10/2007 8311
12/10/2006 1606
12/10/2005 94
12/09/2008 36837
12/09/2007 2489
12/09/2006 1968
12/09/2005 104
12/08/2008 22566
12/08/2007 2708
12/08/2006 3556
12/08/2005 8
12/07/2008 21160
12/07/2007 7640
12/07/2006 4024
12/07/2005 19
12/06/2008 21206
12/06/2007 8225
12/06/2006 4117
12/06/2005 66
12/05/2008 34383
12/05/2007 7739
12/05/2006 4315
12/05/2005 66
12/04/2008 37638
12/04/2007 8908
12/04/2006 3961
12/04/2005 93
12/03/2008 38096
12/03/2007 7532
12/03/2006 1593
12/03/2005 67
12/02/2008 35719
12/02/2007 3597
12/02/2006 1701
12/02/2005 54
12/01/2008 33344
12/01/2007 4110
12/01/2006 3593
12/01/2005 28
11/30/2008 21247
11/30/2007 8241
11/30/2006 3644
11/30/2005 38
11/29/2008 21042
11/29/2007 8898
11/29/2006 4348
11/28/2008 32287
11/28/2007 9574
11/28/2006 3842
11/28/2005 2
11/27/2008 35248
11/27/2007 7731
11/27/2006 4199
11/26/2008 34077
11/26/2007 6954
11/26/2006 1525
11/25/2008 35137
11/25/2007 3576
11/25/2006 2329
11/25/2005 2
11/24/2008 33806
11/24/2007 4214
11/24/2006 4953
11/24/2005 1
11/23/2008 20860
11/23/2007 7334
11/23/2006 3271
11/23/2005 1
11/22/2008 21980
11/22/2007 7954
11/22/2006 3542
11/22/2005 2
11/21/2008 32739
11/21/2007 7553
11/21/2006 3493
11/21/2005 17
11/20/2008 36605
11/20/2007 7273
11/20/2006 3726
11/20/2005 1
11/19/2008 39246
11/19/2007 6889
11/19/2006 1398
11/19/2005 71
11/18/2008 39362
11/18/2007 3262
11/18/2006 1684
11/18/2005 1
11/17/2008 41154
11/17/2007 3414
11/17/2006 3577
11/17/2005 2
11/16/2008 25615
11/16/2007 7372
11/16/2006 3431
11/16/2005 2
11/15/2008 25446
11/15/2007 8266
11/15/2006 3377
11/14/2008 36904
11/14/2007 7078
11/14/2006 3676
11/13/2008 14055
11/13/2007 7627
11/13/2006 3892
11/12/2008 973
11/12/2007 7133
11/12/2006 1461
11/11/2008 1578
11/11/2007 3101
11/11/2006 1640
11/10/2008 1432
11/10/2007 3089
11/10/2006 3481
11/10/2005 349
11/09/2008 971
11/09/2007 6906
11/09/2006 3401
11/09/2005 633
11/08/2008 1648
11/08/2007 7828
11/08/2006 3585
11/07/2008 2114
11/07/2007 7621
11/07/2006 3584
11/07/2005 41
11/06/2008 2077
11/06/2007 8518
11/06/2006 1755
11/05/2008 1000
11/05/2007 2916
11/05/2006 1483
11/04/2008 723
11/04/2007 3125
11/04/2006 1604
11/03/2008 638
11/03/2007 4712
11/03/2006 3324
11/02/2008 1326
11/02/2007 6682
11/02/2006 3234
11/01/2008 2233
11/01/2007 8393
11/01/2006 3251
10/31/2008 2850
10/31/2007 7955
10/31/2006 3128
10/30/2008 2482
10/30/2007 8112
10/30/2006 3533
10/29/2008 2219
10/29/2007 7510
10/29/2006 1756
10/29/2005 1
10/28/2008 2011
10/28/2007 2177
10/28/2006 1932
10/27/2008 888
10/27/2007 3034
10/27/2006 3750
10/26/2008 1071
10/26/2007 8054
10/26/2006 3780
10/25/2008 1308
10/25/2007 8250
10/25/2006 3811
10/24/2008 2662
10/24/2007 6888
10/24/2006 3881
10/23/2008 2073
10/23/2007 7240
10/23/2006 1651
10/22/2008 2149
10/22/2007 6612
10/22/2006 1408
10/21/2008 1917
10/21/2007 2936
10/21/2006 1550
10/20/2008 881
10/20/2007 3340
10/20/2006 3707
10/19/2008 436
10/19/2007 7358
10/19/2006 3625
10/18/2008 694
10/18/2007 7144
10/18/2006 5919
10/17/2008 2138
10/17/2007 7294
10/17/2006 3530
10/16/2008 2361
10/16/2007 7657
10/16/2006 3508
10/16/2005 13
10/15/2008 1214
10/15/2007 8016
10/15/2006 1375
10/14/2008 1204
10/14/2007 2407
10/14/2006 1819
10/13/2008 449
10/13/2007 2236
10/13/2006 3071
10/12/2008 743
10/12/2007 2286
10/12/2006 3529
10/11/2008 2292
10/11/2007 3606
10/11/2006 1565
10/10/2008 2448
10/10/2007 7176
10/10/2006 3749
10/09/2008 1249
10/09/2007 6814
10/09/2006 292
10/08/2008 1590
10/08/2007 7259
10/08/2006 48
10/07/2008 2032
10/07/2007 2381
10/07/2006 33
10/06/2008 1329
10/06/2007 3340
10/06/2006 53
10/05/2008 620
10/05/2007 7872
10/05/2006 58
10/04/2008 1572
10/04/2007 10266
10/04/2006 58
10/03/2008 1938
10/03/2007 8836
10/03/2006 75
10/02/2008 1049
10/02/2007 7481
10/02/2006 47
10/01/2008 646
10/01/2007 7712
10/01/2006 56
09/30/2008 470
09/30/2007 3305
09/30/2006 64
09/29/2008 620
09/29/2007 6785
09/29/2006 60
09/28/2008 1345
09/28/2007 8878
09/28/2006 56
09/27/2008 2201
09/27/2007 7638
09/27/2006 80
09/26/2008 1622
09/26/2007 5150
09/26/2006 137
09/25/2008 1941
09/25/2007 1593
09/25/2006 59
09/24/2008 2669
09/24/2007 993
09/24/2006 62
09/23/2008 2671
09/23/2007 344
09/23/2006 62
09/22/2008 2184
09/22/2007 623
09/22/2006 41
09/21/2008 513
09/21/2007 1411
09/21/2006 50
09/20/2008 935
09/20/2007 1740
09/20/2006 38
09/19/2008 2400
09/19/2007 2191
09/19/2006 77
09/18/2008 2623
09/18/2007 1722
09/18/2006 69
09/17/2008 1913
09/17/2007 686
09/17/2006 89
09/16/2008 1711
09/16/2007 370
09/16/2006 79
09/15/2008 1498
09/15/2007 1322
09/15/2006 78
09/14/2008 532
09/14/2007 2212
09/14/2006 216
09/13/2008 1523
09/13/2007 2017
09/13/2006 278
09/12/2008 2742
09/12/2007 1487
09/12/2006 251
09/11/2008 2859
09/11/2007 1399
09/11/2006 1202
09/10/2008 2790
09/10/2007 591
09/10/2006 1754
09/09/2008 2256
09/09/2007 351
09/09/2006 2211
09/08/2008 772
09/08/2007 571
09/08/2006 3615
09/07/2008 486
09/07/2007 1430
09/07/2006 3237
09/06/2008 786
09/06/2007 4574
09/06/2006 3408
09/05/2008 1939
09/05/2007 7676
09/05/2006 3398
09/04/2008 2425
09/04/2007 8582
09/04/2006 3242
09/03/2008 1913
09/03/2007 10109
09/03/2006 1402
09/02/2008 1542
09/02/2007 2779
09/02/2006 1540
09/01/2008 1412
09/01/2007 3536
09/01/2006 3188
08/31/2008 475
08/31/2007 8447
08/31/2006 3482
08/30/2008 1219
08/30/2007 9291
08/30/2006 50616
08/29/2008 1847
08/29/2007 9467
08/29/2006 3916
08/28/2008 2442
08/28/2007 7533
08/28/2006 3398
08/27/2008 1552
08/27/2007 7866
08/27/2006 1406
08/26/2008 1697
08/26/2007 3848
08/26/2006 1564
08/25/2008 708
08/25/2007 4133
08/25/2006 2903
08/24/2008 574
08/24/2007 8236
08/24/2006 3275
08/23/2008 1117
08/23/2007 7851
08/23/2006 3490
08/22/2008 2055
08/22/2007 8343
08/22/2006 3990
08/21/2008 1709
08/21/2007 7930
08/21/2006 4478
08/20/2008 1362
08/20/2007 7076
08/20/2006 1346
08/19/2008 1120
08/19/2007 3838
08/19/2006 1524
08/18/2008 1148
08/18/2007 5472
08/18/2006 3081
08/17/2008 362
08/17/2007 8752
08/17/2006 2972
08/16/2008 992
08/16/2007 8437
08/16/2006 3151
08/15/2008 1368
08/15/2007 8105
08/15/2006 2991
08/14/2008 2076
08/14/2007 8140
08/14/2006 3321
08/13/2008 1833
08/13/2007 8125
08/13/2006 1184
08/12/2008 2036
08/12/2007 3783
08/12/2006 1783
08/11/2008 1302
08/11/2007 4638
08/11/2006 3682
08/10/2008 1045
08/10/2007 8583
08/10/2006 3879
08/09/2008 2192
08/09/2007 8445
08/09/2006 3093
08/08/2008 3378
08/08/2007 21058
08/08/2006 2967
08/07/2008 3485
08/07/2007 7808
08/07/2006 3064
08/06/2008 5312
08/06/2007 10250
08/06/2006 1253
08/05/2008 7526
08/05/2007 3876
08/05/2006 1444
08/04/2008 2006
08/04/2007 5282
08/04/2006 3058
08/03/2008 647
08/03/2007 8060
08/03/2006 2773
08/02/2008 2087
08/02/2007 8549
08/02/2006 2804
08/01/2008 3532
08/01/2007 10982
08/01/2006 2849
07/31/2008 3374
07/31/2007 8369
07/31/2006 2975
07/30/2008 2191
07/30/2007 8714
07/30/2006 1249
07/29/2008 1111
07/29/2007 3946
07/29/2006 1373
07/28/2008 497
07/28/2007 5244
07/28/2006 2533
07/27/2008 751
07/27/2007 7904
07/27/2006 2725
07/26/2008 1206
07/26/2007 8249
07/26/2006 2948
07/25/2008 1742
07/25/2007 6226
07/25/2006 2822
07/24/2008 2163
07/24/2007 30414
07/24/2006 2800
07/23/2008 2594
07/23/2007 1180
07/23/2006 1269
07/22/2008 2678
07/22/2007 735
07/22/2006 1322
07/21/2008 1773
07/21/2007 918
07/21/2006 2668
07/20/2008 615
07/20/2007 1760
07/20/2006 2694
07/19/2008 1386
07/19/2007 2762
07/19/2006 2514
07/18/2008 1829
07/18/2007 8680
07/18/2006 2729
07/17/2008 1438
07/17/2007 5536
07/17/2006 2614
07/16/2008 958
07/16/2007 3369
07/16/2006 1091
07/15/2008 1002
07/15/2007 10428
07/15/2006 1217
07/14/2008 299
07/14/2007 13093
07/14/2006 2556
07/13/2008 299
07/13/2007 1908
07/13/2006 2607
07/12/2008 823
07/12/2007 2289
07/12/2006 2656
07/11/2008 1720
07/11/2007 2531
07/11/2006 2602
07/10/2008 2195
07/10/2007 1850
07/10/2006 2783
07/09/2008 1905
07/09/2007 5109
07/09/2006 1098
07/08/2008 1613
07/08/2007 84
07/08/2006 1228
07/07/2008 1719
07/07/2007 283
07/07/2006 2600
07/06/2008 184
07/06/2007 1038
07/06/2006 2698
07/05/2008 618
07/05/2007 847
07/05/2006 3070
07/04/2008 1525
07/04/2007 826
07/04/2006 2899
07/03/2008 1459
07/03/2007 698
07/03/2006 2988
07/02/2008 1501
07/02/2007 111
07/02/2006 1167
07/01/2009 18042
07/01/2008 3292
07/01/2007 118
07/01/2006 1187
06/30/2009 32358
06/30/2008 643
06/30/2007 393
06/30/2006 2883
06/29/2009 29943
06/29/2008 237
06/29/2007 1111
06/29/2006 3147
06/28/2009 16130
06/28/2008 1034
06/28/2007 1096
06/28/2006 2702
06/27/2009 16406
06/27/2008 1508
06/27/2007 788
06/27/2006 2924
06/26/2009 28625
06/26/2008 1130
06/26/2007 780
06/26/2006 2981
06/25/2009 31119
06/25/2008 824
06/25/2007 115
06/25/2006 1321
06/24/2009 31371
06/24/2008 780
06/24/2007 280
06/24/2006 1390
06/23/2009 31238
06/23/2008 148
06/23/2007 840
06/23/2006 2621
06/22/2009 30485
06/22/2008 665
06/22/2007 1109
06/22/2006 2767
06/21/2009 20145
06/21/2008 2466
06/21/2007 803
06/21/2006 3068
06/20/2009 23173
06/20/2008 2644
06/20/2007 781
06/20/2006 3206
06/19/2009 31720
06/19/2008 1014
06/19/2007 757
06/19/2006 2823
06/18/2009 33463
06/18/2008 1650
06/18/2007 116
06/18/2006 1216
06/17/2009 34395
06/17/2008 1320
06/17/2007 115
06/17/2006 1240
06/16/2009 33502
06/16/2008 145
06/16/2007 256
06/16/2006 2665
06/15/2009 31413
06/15/2008 138
06/15/2007 776
06/15/2006 2703
06/14/2009 19316
06/14/2008 138
06/14/2007 726
06/14/2006 3023
06/13/2009 19768
06/13/2008 140
06/13/2007 110
06/13/2006 2713
06/12/2009 21163
06/12/2008 213
06/12/2007 112
06/12/2006 1187
06/11/2009 31988
06/11/2008 812
06/11/2007 109
06/11/2006 1295
06/10/2009 35292
06/10/2008 844
06/10/2007 239
06/10/2006 1531
06/09/2009 35534
06/09/2008 338
06/09/2007 843
06/09/2006 3040
06/08/2009 35099
06/08/2008 957
06/08/2007 1121
06/08/2006 2706
06/07/2009 21966
06/07/2008 1609
06/07/2007 2955
06/07/2006 3244
06/06/2009 22288
06/06/2008 2180
06/06/2007 1023
06/06/2006 3346
06/05/2009 33233
06/05/2008 2897
06/05/2007 1335
06/05/2006 3141
06/04/2009 35505
06/04/2008 1810
06/04/2007 3629
06/04/2006 536
06/03/2009 34072
06/03/2008 2378
06/03/2007 1300
06/03/2006 554
06/02/2009 32608
06/02/2008 1304
06/02/2007 1868
06/02/2006 915
06/01/2009 32405
06/01/2008 424
06/01/2007 13307
06/01/2006 1744
05/31/2009 20442
05/31/2008 774
05/31/2007 4545
05/31/2006 1219
05/30/2009 20354
05/30/2008 1534
05/30/2007 4780
05/30/2006 1003
05/29/2009 32209
05/29/2008 1823
05/29/2007 4378
05/29/2006 829
05/28/2009 35613
05/28/2008 1646
05/28/2007 3894
05/28/2006 567
05/27/2009 35714
05/27/2008 1225
05/27/2007 1904
05/27/2006 595
05/26/2009 36232
05/26/2008 793
05/26/2007 1972
05/26/2006 803
05/25/2009 34486
05/25/2008 610
05/25/2007 4582
05/25/2006 956
05/24/2009 22834
05/24/2008 873
05/24/2007 5099
05/24/2006 2868
05/23/2009 23690
05/23/2008 1373
05/23/2007 4496
05/23/2006 2895
05/22/2009 33983
05/22/2008 1964
05/22/2007 5585
05/22/2006 3273
05/21/2009 35279
05/21/2008 1802
05/21/2007 4279
05/21/2006 1247
05/20/2009 35696
05/20/2008 1465
05/20/2007 1841
05/20/2006 1475
05/19/2009 36019
05/19/2008 573
05/19/2007 2453
05/19/2006 2748
05/18/2009 35826
05/18/2008 648
05/18/2007 4245
05/18/2006 2989
05/17/2009 22242
05/17/2008 1260
05/17/2007 4506
05/17/2006 3158
05/16/2009 22427
05/16/2008 1845
05/16/2007 5136
05/16/2006 3161
05/15/2009 34713
05/15/2008 1951
05/15/2007 4711
05/15/2006 3499
05/14/2009 36202
05/14/2008 1939
05/14/2007 4239
05/14/2006 591
05/13/2009 36487
05/13/2008 1716
05/13/2007 1952
05/13/2006 785
05/12/2009 36062
05/12/2008 1160
05/12/2007 3256
05/12/2006 1678
05/11/2009 21296
05/11/2008 465
05/11/2007 5141
05/11/2006 1960
05/10/2009 20917
05/10/2008 792
05/10/2007 5893
05/10/2006 695
05/09/2009 21300
05/09/2008 2018
05/09/2007 2648
05/09/2006 529
05/08/2009 31453
05/08/2008 3275
05/08/2007 4748
05/08/2006 525
05/07/2009 34130
05/07/2008 3199
05/07/2007 4023
05/07/2006 541
05/06/2009 35244
05/06/2008 2602
05/06/2007 1811
05/06/2006 1487
05/05/2009 33035
05/05/2008 1734
05/05/2007 2390
05/05/2006 804
05/04/2009 19764
05/04/2008 462
05/04/2007 4857
05/04/2006 1293
05/03/2009 20204
05/03/2008 474
05/03/2007 4818
05/03/2006 930
05/02/2009 18536
05/02/2008 557
05/02/2007 1765
05/02/2006 880
05/01/2009 19735
05/01/2008 1363
05/01/2007 1824
05/01/2006 911
04/30/2009 30633
04/30/2008 2233
04/30/2007 1974
04/30/2006 737
04/29/2009 36428
04/29/2008 2281
04/29/2007 2891
04/29/2006 539
04/28/2009 34436
04/28/2008 9767
04/28/2007 4595
04/28/2006 897
04/27/2009 35069
04/27/2008 3886
04/27/2007 4994
04/27/2006 647
04/26/2009 21877
04/26/2008 4593
04/26/2007 5233
04/26/2006 883
04/25/2009 22545
04/25/2008 8155
04/25/2007 5211
04/25/2006 777
04/24/2009 32587
04/24/2008 7681
04/24/2007 7881
04/24/2006 1121
04/23/2009 35568
04/23/2008 8455
04/23/2007 4916
04/23/2006 532
04/22/2009 36324
04/22/2008 8209
04/22/2007 2277
04/22/2006 556
04/21/2009 35085
04/21/2008 6376
04/21/2007 3148
04/21/2006 1214
04/20/2009 35634
04/20/2008 3260
04/20/2007 5425
04/20/2006 1012
04/19/2009 23381
04/19/2008 4882
04/19/2007 15803
04/19/2006 6185
04/18/2009 23614
04/18/2008 8061
04/18/2007 6771
04/18/2006 1495
04/17/2009 34637
04/17/2008 8671
04/17/2007 5429
04/17/2006 977
04/16/2009 36734
04/16/2008 8251
04/16/2007 4171
04/16/2006 873
04/15/2009 34566
04/15/2008 7394
04/15/2007 2118
04/15/2006 872
04/14/2009 35396
04/14/2008 7860
04/14/2007 2403
04/14/2006 1143
04/13/2009 35081
04/13/2008 3302
04/13/2007 5264
04/13/2006 1056
04/12/2009 22030
04/12/2008 4460
04/12/2007 4950
04/12/2006 917
04/11/2009 23460
04/11/2008 7419
04/11/2007 6451
04/11/2006 1397
04/10/2009 36234
04/10/2008 6997
04/10/2007 153360
04/10/2006 900
04/09/2009 37520
04/09/2008 8753
04/09/2007 1219737
04/09/2006 790
04/08/2009 35753
04/08/2008 7545
04/08/2007 4467
04/08/2006 467
04/07/2009 37311
04/07/2008 7713
04/07/2007 2050
04/07/2006 915
04/06/2009 36113
04/06/2008 3340
04/06/2007 4413
04/06/2006 823
04/05/2009 21188
04/05/2008 4852
04/05/2007 4811
04/05/2006 1295
04/04/2009 21911
04/04/2008 8397
04/04/2007 5823
04/04/2006 1014
04/03/2009 33475
04/03/2008 8827
04/03/2007 4604
04/03/2006 1735
04/02/2009 36195
04/02/2008 7666
04/02/2007 4916
04/02/2006 434
04/01/2009 38023
04/01/2008 8713
04/01/2007 2151
04/01/2006 461
03/31/2009 35567
03/31/2008 8454
03/31/2007 2601
03/31/2006 883
03/30/2009 37185
03/30/2008 3758
03/30/2007 4707
03/30/2006 808
03/29/2009 23595
03/29/2008 4820
03/29/2007 5395
03/29/2006 2140
03/28/2009 24773
03/28/2008 8668
03/28/2007 4524
03/28/2006 947
03/27/2009 201
03/27/2008 8929
03/27/2007 4545
03/27/2006 654
03/26/2009 299
03/26/2008 7974
03/26/2007 4030
03/26/2006 604
03/25/2009 576
03/25/2008 8817
03/25/2007 1743
03/25/2006 996
03/24/2009 2275
03/24/2008 7760
03/24/2007 2247
03/24/2006 510
03/23/2009 267
03/23/2008 3142
03/23/2007 4369
03/23/2006 2828
03/22/2009 93
03/22/2008 2970
03/22/2007 4751
03/22/2006 2958
03/21/2009 95
03/21/2008 6650
03/21/2007 4621
03/21/2006 2825
03/20/2009 221
03/20/2008 8691
03/20/2007 4623
03/20/2006 2946
03/19/2009 397
03/19/2008 8737
03/19/2007 3967
03/19/2006 1367
03/18/2009 178
03/18/2008 7552
03/18/2007 1813
03/18/2006 1425
03/17/2009 720
03/17/2008 7874
03/17/2007 2295
03/17/2006 3140
03/16/2009 280
03/16/2008 3602
03/16/2007 4559
03/16/2006 3600
03/15/2009 95
03/15/2008 4028
03/15/2007 4391
03/15/2006 3080
03/14/2009 98
03/14/2008 8039
03/14/2007 4923
03/14/2006 3386
03/13/2009 287
03/13/2008 9391
03/13/2007 4417
03/13/2006 3599
03/12/2009 337
03/12/2008 9666
03/12/2007 3792
03/12/2006 1646
03/11/2009 272
03/11/2008 8751
03/11/2007 1961
03/11/2006 1813
03/10/2009 263
03/10/2008 3831
03/10/2007 2186
03/10/2006 3224
03/09/2009 127
03/09/2008 3887
03/09/2007 3823
03/09/2006 3141
03/08/2009 130
03/08/2008 4232
03/08/2007 2380
03/08/2006 1565
03/07/2009 156
03/07/2008 8944
03/07/2007 4565
03/07/2006 3104
03/06/2009 430
03/06/2008 9090
03/06/2007 4674
03/06/2006 3487
03/05/2009 207
03/05/2008 8650
03/05/2007 4159
03/05/2006 1586
03/04/2009 536
03/04/2008 8623
03/04/2007 1651
03/04/2006 1661
03/03/2009 279
03/03/2008 8367
03/03/2007 2558
03/03/2006 3486
03/02/2009 4781
03/02/2008 4302
03/02/2007 5408
03/02/2006 2902
03/01/2009 582
03/01/2008 3705
03/01/2007 4835
03/01/2006 4387
02/29/2008 7287
02/28/2009 971
02/28/2008 8295
02/28/2007 4305
02/28/2006 3371
02/27/2009 128703
02/27/2008 8920
02/27/2007 4966
02/27/2006 3394
02/26/2009 37536
02/26/2008 9961
02/26/2007 3660
02/26/2006 3489
02/25/2009 35957
02/25/2008 2681
02/25/2007 1788
02/25/2006 1357
02/24/2009 35973
02/24/2008 3470
02/24/2007 1739
02/24/2006 1298
02/23/2009 21416
02/23/2008 4326
02/23/2007 1675
02/23/2006 1232
02/22/2009 21270
02/22/2008 8541
02/22/2007 3784
02/22/2006 2807
02/21/2009 21529
02/21/2008 7378
02/21/2007 4350
02/21/2006 3002
02/20/2009 35032
02/20/2008 8569
02/20/2007 4223
02/20/2006 2989
02/19/2009 36710
02/19/2008 7900
02/19/2007 4077
02/19/2006 1392
02/18/2009 35940
02/18/2008 7266
02/18/2007 1655
02/18/2006 1577
02/17/2009 37229
02/17/2008 3862
02/17/2007 1947
02/17/2006 2849
02/16/2009 34796
02/16/2008 4789
02/16/2007 4436
02/16/2006 2852
02/15/2009 23373
02/15/2008 8781
02/15/2007 4730
02/15/2006 2974
02/14/2009 25119
02/14/2008 7248
02/14/2007 5039
02/14/2006 2988
02/13/2009 35282
02/13/2008 7731
02/13/2007 4043
02/13/2006 2848
02/12/2009 37204
02/12/2008 7247
02/12/2007 3919
02/12/2006 1218
02/11/2009 36498
02/11/2008 7609
02/11/2007 1831
02/11/2006 1458
02/10/2009 36599
02/10/2008 2997
02/10/2007 2836
02/10/2006 2909
02/09/2009 36209
02/09/2008 3355
02/09/2007 6048
02/09/2006 2870
02/08/2009 23895
02/08/2008 7458
02/08/2007 4297
02/08/2006 2605
02/07/2009 22324
02/07/2008 8030
02/07/2007 4383
02/07/2006 2819
02/06/2009 33763
02/06/2008 8512
02/06/2007 4603
02/06/2006 2949
02/05/2009 36562
02/05/2008 7018
02/05/2007 4608
02/05/2006 1241
02/04/2009 36567
02/04/2008 8019
02/04/2007 1776
02/04/2006 1481
02/03/2009 36772
02/03/2008 2499
02/03/2007 2024
02/03/2006 2840
02/02/2009 36459
02/02/2008 3703
02/02/2007 4562
02/02/2006 3031
02/01/2009 21317
02/01/2008 10296
02/01/2007 4506
02/01/2006 2701
01/31/2009 22744
01/31/2008 7829
01/31/2007 4040
01/31/2006 3508
01/30/2009 34378
01/30/2008 7073
01/30/2007 4429
01/30/2006 2886
01/29/2009 36280
01/29/2008 7405
01/29/2007 8469
01/29/2006 1204
01/28/2009 35240
01/28/2008 6950
01/28/2007 1891
01/28/2006 1470
01/27/2009 34880
01/27/2008 1995
01/27/2007 2529
01/27/2006 3034
01/26/2009 34883
01/26/2008 2586
01/26/2007 4338
01/26/2006 2888
01/25/2009 20330
01/25/2008 7146
01/25/2007 3786
01/25/2006 3115
01/24/2009 21306
01/24/2008 7856
01/24/2007 4186
01/24/2006 3002
01/23/2009 33285
01/23/2008 8025
01/23/2007 4117
01/23/2006 3262
01/22/2009 37616
01/22/2008 8625
01/22/2007 3948
01/22/2006 1263
01/21/2009 36108
01/21/2008 8243
01/21/2007 1427
01/21/2006 1477
01/20/2009 34725
01/20/2008 2952
01/20/2007 2493
01/20/2006 3026
01/19/2009 38001
01/19/2008 3019
01/19/2007 4668
01/19/2006 2790
01/18/2009 20250
01/18/2008 7588
01/18/2007 4712
01/18/2006 2586
01/17/2009 22359
01/17/2008 8081
01/17/2007 3929
01/17/2006 3056
01/16/2009 33834
01/16/2008 7527
01/16/2007 5074
01/16/2006 2188
01/15/2009 35087
01/15/2008 7256
01/15/2007 4231
01/15/2006 1185
01/14/2009 35907
01/14/2008 7655
01/14/2007 1680
01/14/2006 1087
01/13/2009 36251
01/13/2008 2777
01/13/2007 2199
01/13/2006 1536
01/12/2009 34626
01/12/2008 2759
01/12/2007 4050
01/12/2006 1545
01/11/2009 34722
01/11/2008 7518
01/11/2007 4627
01/11/2006 1750
01/10/2009 20102
01/10/2008 7389
01/10/2007 4084
01/10/2006 881
01/09/2009 20535
01/09/2008 7889
01/09/2007 1876
01/09/2006 842
01/08/2009 20145
01/08/2008 2869
01/08/2007 1758
01/08/2006 788
01/07/2009 19956
01/07/2008 2395
01/07/2007 1469
01/07/2006 780
01/06/2009 28097
01/06/2008 2664
01/06/2007 1752
01/06/2006 1320
01/05/2009 29458
01/05/2008 6927
01/05/2007 5349
01/05/2006 1619
01/04/2009 21695
01/04/2008 16690
01/04/2007 3834
01/04/2006 1514
01/03/2009 18750
01/03/2008 6465
01/03/2007 3290
01/03/2006 853
01/02/2009 19414
01/02/2008 2458
01/02/2007 1570
01/02/2006 859
01/01/2009 18380
01/01/2008 2159
01/01/2007 1476
01/01/2006 7752 июля 2009 г. 8:17 -
SELECT NTEventID, COUNT(*) AS "Numver of Events"
FROM SDKEventView
GROUP BY NTEventID
ORDER BY "Numver of Events" DESC
25261 10078531
9548 549674
40000 117179
11 47296
1701 44632
21287 40656
20604 26279
24100 23098
24101 23096
9023 23075
9024 23052
9188 22511
12294 14700
7031 12782
17052 11171
9100 10084
1704 9768
9897 9326
9898 9323
7032 8520
1000 6509
9153 6146
25266 6099
701 5865
700 5865
1221 5850
21245 5303
21421 4773
20333 3459
22085 2037
22086 2028
1074 1933
9896 1822
20481 1693
21241 1542
9010 1291
1053 1167
21069 1162
22099 1145
3047 1080
24000 1011
9320 1006
8990 967
8970 966
9986 966
8165 966
9963 966
9011 966
9110 966
9002 965
8980 965
8975 963
9000 963
8985 962
9003 962
9001 960
1069 951
8991 946
1025 929
4199 892
25110 871
17055 755
223 692
213 684
25402 612
8183 604
1006 595
2003 585
1055 579
211 571
21251 522
220 487
221 485
25101 456
8026 373
16 346
6005 346
22093 310
22061 255
7034 243
8260 242
8231 239
20016 237
2102 236
6006 231
4193 225
20012 225
20008 221
22062 208
2114 207
20061 200
2103 199
20064 194
21207 164
5805 163
30962 157
1038 157
21268 152
1066 149
2001 144
1035 137
9951 135
9997 135
1052 123
210 123
20020 121
20004 120
21269 118
6008 116
401 112
14148 110
1068 107
7 103
5723 101
25116 101
1145 96
308 93
1077 93
14422 91
1005 89
1202 84
4147 83
1123 78
7000 77
30961 76
101 75
6000 74
1031 72
21000 70
1032 70
21210 67
21125 64
9008 64
1085 62
1001 56
7001 56
4202 55
4332 50
14420 50
20493 50
17 47
19 46
21 45
9152 45
1097 44
1045 43
7022 42
7023 42
21295 41
9074 40
21174 40
1009 40
1054 38
112 38
21240 37
21284 36
1021 35
102 34
100 34
26005 33
1135 33
9154 32
1700 31
4097 30
14104 29
21199 29
1036 29
9176 28
21290 27
29 26
2104 26
7026 26
4004 25
38 25
14147 24
21209 24
24 24
155 24
9950 23
301 23
1019 23
14176 23
5774 21
20065 21
10302 20
302 19
1525 19
25109 19
300 19
8995 18
1058 18
1040 18
1308 17
1049 17
38906 17
2068 16
9098 16
21426 16
3000 16
25601 15
9013 15
1067 14
9158 13
9143 12
20007 12
20015 12
1072 12
1030 12
25103 12
408 12
1 12
9026 11
4098 11
1148 11
407 11
36 11
20011 10
14534 10
215 10
14523 10
38903 10
1096 10
14079 9
30813 9
2219 9
1084 9
222 9
7024 9
22 9
9219 8
30011 8
35 8
1071 8
20003 8
20019 8
7013 7
12 7
9646 7
1521 7
1147 6
25213 6
9029 5
1014 5
21027 5
2116 5
9175 4
1004 4
21218 4
1059 4
14057 4
21288 4
1057 4
4011 4
2035 4
704 4
1070 3
2112 3
1511 3
9144 3
37 3
6 3
2002 3
26 3
1011 3
30964 3
1102 3
9899 3
20062 3
1044 3
2013 3
20083 3
24102 3
14035 2
25257 2
1015 2
14526 2
12299 2
9964 2
21708 2
14090 2
8213 2
1016 2
3001 2
8960 2
2511 2
21087 2
23 2
1008 2
1002 2
1080 2
38907 2
30972 2
21214 2
21422 2
1524 2
3043 2
111 1
504 1
21266 1
1117 1
14007 1
1094 1
1017 1
20 1
404 1
12304 1
21211 1
1188 1
5782 1
1516 1
25005 1
1010 1
22089 1
25222 1
21078 1
30905 1
12297 1
1517 1
30904 1
21096 1
24105 1
30903 1
904 1
21185 1
21091 1
47 1
2006 1
1645 12 июля 2009 г. 8:54 -
select performanceobjectname, performancecountername, count(performanceobjectname) as 'count'
from sdkperformanceview
where computername = 'COMPUTERNAME'
group by performanceobjectname, performancecountername
order by 'count' desc
не вернул ничего
Или вместо COMPUTERNAME нужно подставить конкретное имя?2 июля 2009 г. 8:56 -
Конечно. Нужно подставлять реальное имя.
Десять миллионов событий с ID 25261 и полмиллиона событий 9548 - явно много. У вас все признаки алерт шторма. Найдите правило, которое отвечает за это событие и отключите или исправьте причину...
http://OpsMgr.ru/- Помечено в качестве ответа katbert 2 июля 2009 г. 17:04
2 июля 2009 г. 9:09Отвечающий -
Машину нашел,событие 25261 создается IIS
Проблема в том, что эта машина - и есть сервер управления
В то же время на клиентах служба агента называется MOM, и на сервере управления есть такая же служба
А как зовут службу, реализующую серверную часть?
2 июля 2009 г. 10:33 -
Спасибо за помощь, поборол. теперь база весит 500 МБ
В Global settings в настройках Grooming Указал 1 день, и в трех случаях autoresolve c 90 дней до 10 дней
После этого запустил созданный ранее job и он сделел grooming
После этого осталось сделать shrink
Сейчас на сервере управления остановлена служба MOM
Как я понимаю, это агент
Пока он не запущен - новые события валиться не будут
Осталось только прояснить - какие процессы реализуют серверную часть?2 июля 2009 г. 10:56 -
Служба МОМ является службой агента, когда она на агенте и службой сервера, когда на менеджмент сервере. :) Службы называются одинаково и на агенте и на сервере. Кроме этого на сервере должна быть DAS (если я правильно помню).
http://OpsMgr.ru/2 июля 2009 г. 15:39Отвечающий -
О как :)
Тогда возможно ли на сервере управления остановить агент - чтобы новые события не сыпались как из рога изобилия, а серверная часть работала - то есть события от других агентов исправно ложились в базу
Или можно остановить только все и сразу?
2 июля 2009 г. 17:06 -
Только все сразу.
И, кстати, когда будете делать shrink - не забудьте оставлять в базе 40% свободного пространства.
А чтобы события не сыпались самый лучший вариант - найти и исправить источник события в IIS. Ну или правило отключить.
http://OpsMgr.ru/3 июля 2009 г. 2:42Отвечающий
