Fragen zur Datenbankgrösse ???

1. offizieller Beitrag

    Hallo,


    wir haben das Problem das unsere Datenbank auf nahezu 16GB angewachsen ist. Laut ESM belegen die Postfächer alle zusammen eine Grösse von ca. 2GB.
    Was wird noch alles in der Datenbank festgehalten und wo sind die anderen 14GB hin ???
    Kann mir jemand eine Erklärung oder einen Hinweis geben ???

    Hallo keorvman,


    ich weiss das ich die Priv1.edb und Priv1.stm zusammen rechnen muss.
    ich liste es mal einzelnd auf priv1.stm = 1,9GB ; priv1.edb = 14,2GB und das zusammenzählen der Postfächer im ESM ergibt ca. 2GB. Wo kommt also der Rest der in der priv1.edb liegt her ? Was kann das sein ? Was macht die Datenbank so gross ausser die normalen Postfächer inkl. Mailverkehr + Anhänge ?

    die Datenbank existiert seid August 2003


    letzte Offline Defrag war Februar 2005 -> danach war die Datenbank ca 12GB gross


    archivieren tun wir mit Exchange eigenen Mitteln


    es wird täglich ein Backup und ein Online Defrag gefahren

    Hallo koervman,


    im Eventlog steht das die Datenbank nach dem Online Defrag 471 MB freien Speicherplatz zur Verfügung hat


    Wie bzw. auf was kann man denn die Datenbank überprüfen ?


    Gruss Coffey

    Hallo koervman,


    wir haben den isinteg -test Alltests auf unserem Produktivsystem durchlaufen lassen und haben folgendes Ergebniss erhalten:


    C:\Programme\Exchsrvr\bin>isinteg -s server -test alltests
    Databases for server server:
    Only databases marked as Offline can be checked


    Index Status Database-Name
    Storage Group Name: Erste Speichergruppe
    1 Online Informationsspeicher f³r Íffentliche Ordner (Server)
    2 Offline Postfachspeicher (Server)
    Enter a number to select a database or press Return to exit.
    2
    You have selected Erste Speichergruppe / Postfachspeicher (Server).
    Continue?(Y/N)y
    Test Search Folder Links result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s);
    time: 0h:0m:7s
    Test Global result: 0 error(s); 0 warning(s); 0 fix(es); 1 row(s); time: 0h:0m:0s
    Test Delivered To result: 0 error(s); 0 warning(s); 0 fix(es); 20 row(s); time:0h:0m:0s
    Test Repl Schedule result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time0h:0m:0s
    Test Timed Events result: 0 error(s); 0 warning(s); 0 fix(es); 24 row(s); time:0h:0m:0s
    Test reference table construction result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0h:5m:6s
    Test Folder result: 0 error(s); 5 warning(s); 0 fix(es); 3410 row(s); time: 0h:18m:44s
    Test Deleted Messages result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0h:0m:0s
    Test Message result: 0 error(s); 0 warning(s); 0 fix(es); 305448 row(s); time: 0h:17m:34s
    Test Attachment result: 0 error(s); 0 warning(s); 0 fix(es); 112251 row(s); time: 0h:0m:32s
    Test Mailbox result: 0 error(s); 0 warning(s); 0 fix(es); 35 row(s); time: 0h:0m:1s
    Test Sites result: 0 error(s); 0 warning(s); 0 fix(es); 135 row(s); time: 0h:0m:0s
    Test Categories result: 0 error(s); 0 warning(s); 0 fix(es); 31 row(s); time: 0h:0m:0s
    Test Per-User Read result: 0 error(s); 0 warning(s); 0 fix(es); 15 row(s); time: 0h:0m:0s
    Test special folders result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0h:0m:0s
    Test Message Tombstone result: 0 error(s); 0 warning(s); 0 fix(es); 227 row(s);time: 0h:0m:0s
    Test Folder Tombstone result: 0 error(s); 0 warning(s); 0 fix(es); 0 row(s); time: 0h:0m:0s
    Now in test 18(reference count verification) of total 19 tests; 100% complete.
    Now in test 18(reference count verification) of total 19 tests; 100% complete.
    Test reference count verification result: 0 error(s); 3 warning(s); 0 fix(es); 0 row(s); time: 0h:7m:19s
    Now in test 19(Row Count/Dumpster Count) of total 19 tests; 100% complete.
    C:\Programme\Exchsrvr\bin>


    Und in der isinteg.pri Datei die angelegt wurde steht folgendes:


    Started: 09/07/05 19:21:37
    Server name: server
    Database name: Erste Speichergruppe\Postfachspeicher (server)
    Output log: isinteg.pri
    Check mode: check only
    Options: -log -RefDbLoc -Test testFldRcv testFldSub testMsgRef testMsgSoftRef testAttachRef testACLListRef testACLItemRef testNewsfeedRef testFolder testDelFolder testMessage testAttach testMailbox testReceiveFld testACLList testACLItem testOofHist testPerUser testGlobal testDlvrTo testSearchQ testTimedEvents testMoreFld testTombstone testNewsfeed testSearch testDumpsterProps testFreeDocUrl testEnd


    The Information Store has not been shut down clean.
    Hence enabling the Row Count/Dumpster Count test.
    You may also specify -test rowcounts (or) -test dumpsterref to run these tests
    Starting test 1 of 19, 'Search Folder Links'. Time: 0h:0m:7s
    Starting test 2 of 19, 'Global', number of rows = 1. Time: 0h:0m:0s
    Starting test 3 of 19, 'Delivered To', number of rows = 20. Time: 0h:0m:0s
    Starting test 4 of 19, 'Repl Schedule'. Time: 0h:0m:0s
    Starting test 5 of 19, 'Timed Events'
    Timed event are : Expiration = 24, , number of rows = 24. Time: 0h:0m:0s
    Starting test 6 of 19, 'reference table construction'. Time: 0h:5m:6s
    Starting test 7 of 19, 'Folder'
    Warning: MsgFolder 1 (Fid=0001-000000649B17, Mid=0001-00000003CD99, Inid=0001-000000754185): Error JET_errRecordNotFound seeking to INID for this MsgFolder Row
    Warning: MsgFolder 38 (Fid=0001-000000649B17, Mid=0001-00000003CE26, Inid=0001-0000007469C3): Error JET_errRecordNotFound seeking to INID for this MsgFolder Row
    Warning: MsgFolder 523 (Fid=0003-000000EB0005, Mid=0001-0000002C3517, Inid=0001-00000031C5F9): Message has mismatched URLCompNameHashValue in Database: HashValue calculated = 2069159198, value from Database = -1219984451
    Warning: MsgFolder 17331 (Fid=0003-000000EB0007, Mid=0001-000000682E85, Inid=0001-0000006FAB9E): Message has mismatched URLCompNameHashValue in Database: HashValue calculated = -1946497656, value from Database = -1914417429
    Warning: MsgFolder 1167 (Fid=0003-000000EB0041, Mid=0001-000000549B80, Inid=0001-000000607028): Message has mismatched URLCompNameHashValue in Database: HashValue calculated = -1112800483, value from Database = -49354411
    , number of rows = 2265. Time: 0h:18m:44s, number of warnings = 5
    Starting test 8 of 19, 'Deleted Messages'. Time: 0h:0m:0s
    Starting test 9 of 19, 'Message', number of rows = 305448. Time: 0h:17m:34s
    Starting test 10 of 19, 'Attachment', number of rows = 112251. Time: 0h:0m:32s
    Starting test 11 of 19, 'Mailbox', number of rows = 35. Time: 0h:0m:1s
    Starting test 12 of 19, 'Sites', number of rows = 135. Time: 0h:0m:0s
    Starting test 13 of 19, 'Categories', number of rows = 31. Time: 0h:0m:0s
    Starting test 14 of 19, 'Per-User Read', number of rows = 15. Time: 0h:0m:0s
    Starting test 15 of 19, 'special folders'. Time: 0h:0m:0s
    Starting test 16 of 19, 'Message Tombstone', number of rows = 227. Time: 0h:0m:0s
    Starting test 17 of 19, 'Folder Tombstone'. Time: 0h:0m:0s
    Starting test 18 of 19, 'reference count verification'
    Warning: Attachment[0001-0000005F4840].AttachRefCt: Bad count - Prop(-1) <> Calc(0)
    Warning: Attachment[0001-0000005F4878].AttachRefCt: Bad count - Prop(1) <> Calc(0)
    Warning: Mailbox[0001-0000000062CE].MailboxContentCount: Bad count - Prop(578) <> Calc(590). Time: 0h:7m:19s, number of warnings = 3
    Starting test 19 of 19, 'Row Count/Dumpster Count'
    Warning: table MsgFolder row count: Calc(302064) <> Prop(353266)
    Warning: table Categ row count: Calc(213) <> Prop(21)
    Warning: table Mailbox row count: Calc(35) <> Prop(38)
    Warning: table ReplidMap row count: Calc(6) <> Prop(5)
    Warning: DumpsterSize Calc(15889361501) <> Prop(15831373009). Time: 0h:0m:0s, number of warnings = 5
    . . . . . SUMMARY . . . . .
    Total number of tests : 19
    Total number of warnings : 13
    Total number of errors : 0
    Total number of fixes : 0
    Total time : 0h:49m:26s


    Was sagt mir jetzt das Ergebniss der Tests und wie muss ich weiter vorgehen ?


    Vielen Dank für die Mühe !
    Gruss Coffey