Forums

 
ForumForumMainstream Foru...Mainstream Foru...Best PracticesBest PracticesDatabase Management and AuditTablesDatabase Management and AuditTables
Previous Previous
 
Next Next
New Post
 3/29/2013 3:40 PM
 
 Modified By Drew S.  on 3/29/2013 4:32:25 PM
Our company is finding that after a period of time, the performance of the system starts to lag. We can resolve this by clearing out all of the audit information from the database. Clearing out this audit information seems to completely restore the performance back to its fresh install performance. The problem is, we really want this audit data. We love the "View Change Log" function and don't want to delete all of the audit data.

What do you think is actually causing the slowdown. Is it really database size, or is it somehow related to the workflow engine? What is your recommendation for keeping performance high without losing a permanent history for all of our records?

Thanks,
Drew S.

Here is some sample data... we purged these tables with anything older than 3/23/13... so this is 7 days worth of Audit Data.

TableName RowCounts TotalSpaceKB UsedSpaceKB UnusedSpaceKB
ACCOUNTS_AUDIT 33 88 88 0
ACCOUNTS_CONTACTS_AUDIT 19628 7960 7800 160
ACCOUNTS_CSTM_AUDIT 5750 4320 3888 432
AUDIT_EVENTS 19304 5136 5080 56
BUGS_AUDIT 113 368 240 128
BUGS_CSTM_AUDIT 108 72 72 0
CASES_AUDIT 73084 81640 81384 256
CASES_CSTM_AUDIT 36551 13216 12880 336
CONTACTS_AUDIT 41195 47264 46888 376
CONTACTS_CASES_AUDIT 18364 7904 7488 416
CONTACTS_CSTM_AUDIT 21583 9888 9520 368
CREDIT_CARDS_AUDIT 4 32 32 0
EMAIL_TEMPLATES_AUDIT 4 32 32 0
EMAILS_AUDIT 377 5592 5000 592
EMAILS_BUGS_AUDIT 2 32 32 0
EMAILS_CONTACTS_AUDIT 292 256 168 88
EMAILS_QUOTES_AUDIT 18 40 40 0
EMAILS_USERS_AUDIT 308 256 152 104
EXCHANGE_FOLDERS_AUDIT 22 40 40 0
NOTES_AUDIT 40351 66088 65824 264
ORDERS_ACCOUNTS_AUDIT 2244 1312 1016 296
ORDERS_AUDIT 1289 1888 1664 224
ORDERS_CONTACTS_AUDIT 2244 1248 1008 240
ORDERS_CSTM_AUDIT 642 808 680 128
ORDERS_LINE_ITEMS_AUDIT 537 800 648 152
ORDERS_LINE_ITEMS_CSTM_AUDIT 340 200 152 48
ORDERS_SPAS_AUDIT 10 64 64 0
PRODUCT_TEMPLATES_AUDIT 10934 13792 13720 72
PRODUCT_TEMPLATES_CSTM_AUDIT 5467 1824 1736 88
QUOTE_TERMS_AUDIT 10 48 48 0
QUOTES_ACCOUNTS_AUDIT 1025 672 504 168
QUOTES_AUDIT 113202 124448 124048 400
QUOTES_CONTACTS_AUDIT 1025 672 480 192
QUOTES_CSTM_AUDIT 56547 93552 93008 544
QUOTES_LINE_ITEMS_AUDIT 1089 1376 1168 208
QUOTES_LINE_ITEMS_CSTM_AUDIT 596 352 232 120
QUOTES_SPAS_AUDIT 53 72 72 0
REPORTS_AUDIT 20 26296 26248 48
SPAS_AUDIT 1056 800 736 64
SPAS_MULTIPLIER_GROUPS_AUDIT 2353 1504 1456 48
USERS_AUDIT 583 1696 1424 272
USERS_PASSWORD_HISTORY_AUDIT 7 32 32 0

Here is some sample audit data form vwQUOTES_AUDIT.
AUDIT_ID AUDIT_ACTION AUDIT_DATE AUDIT_VERSION AUDIT_TOKEN ID DELETED DATE_ENTERED MODIFIED_USER_ID MODIFIED_BY DATE_MODIFIED DATE_MODIFIED_UTC ASSIGNED_USER_ID QUOTE_NUM
448B99B3-25C0-4B84-9003-F06105FCACB3 1 20:01.6 0x00000000028E2104 :TO][BS;]A7-i?R.BRh>KM5---.PEM-- 99F8FC82-44B5-4701-8E93-82F5B6FCD489 0 19:36.2 NULL NULL 19:42.9 20:01.6 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190169
7C4FE4A2-494A-4FAE-A21F-5E216DB3045E 0 20:01.6 0x00000000028E20F8 YX?HWd`h:A7LKREDXj-8L]5----1H=-- 99F8FC82-44B5-4701-8E93-82F5B6FCD489 0 20:01.6 NULL NULL 20:01.6 20:01.6 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190169
69AF3912-107D-4A26-AC00-43C3F8E8B6BD 1 45:01.9 0x00000000028E1B5F 5ibAG5/H-J8/?PX-5-----B=-- EDA09CD2-A31E-4330-947B-763FA081DA52 0 17:38.0 NULL NULL 43:06.3 45:01.7 67038C8A-0FC7-441A-8BEF-19E15F481384 190165
A9CAAEC5-B9A6-4C20-A37C-FF853D8A6A3B 1 45:01.7 0x00000000028E1B4C ;WdHJKVJXAcBiCN1g?TX3]5----lI--- EDA09CD2-A31E-4330-947B-763FA081DA52 0 17:38.0 NULL NULL 45:01.7 45:01.7 67038C8A-0FC7-441A-8BEF-19E15F481384 190165
17E513C9-EAA0-41D1-8E6F-21EE248A6E66 1 45:01.7 0x00000000028E1B4A cM>i?VNaOAccI;e`^0=hZ]5---/ND]-- 35E671B2-F02A-4A05-9073-4936FE7E3DA9 0 22:37.7 NULL NULL 43:06.3 45:01.6 67038C8A-0FC7-441A-8BEF-19E15F481384 186245
F794A5D8-6298-4105-949D-E1D2EBE9A52F 1 45:01.6 0x00000000028E1B37 `]FM;`D5I17:1/7]fGlBKM5---0aB=-- 35E671B2-F02A-4A05-9073-4936FE7E3DA9 0 22:37.7 NULL NULL 45:01.6 45:01.6 67038C8A-0FC7-441A-8BEF-19E15F481384 186245
868A92E0-91EA-4E86-81DA-8FCFCBAB75A6 1 45:01.0 0x00000000028E1B28 01BF1133-93C0-4773-9808-E23A993E1FF1 0 45:00.9 0x00000000028E1B1D gB/Q0A7j=AK8YIX?-5---06A--- 13A28828-FC7D-4AE9-B305-3F67F26F49CE 0 45:00.9 NULL NULL 45:00.9 45:00.9 67038C8A-0FC7-441A-8BEF-19E15F481384 190168
EBFB5174-859A-4261-9D95-6BA359D627C4 1 25:02.9 0x00000000028E19CC b2Nd125`gaO4^^3V=5FHW]5---09C=-- 5AE9AF56-2B7D-4391-BF76-22E1EC5B54BA 0 55:24.8 00000000-0000-0000-0000-000000000001 admin 25:02.9 25:02.9 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 189397
88C8B7A4-71D0-4A20-A5E9-CF3B2377EE74 1 20:03.5 0x00000000028E1977 iP2I;FT1KQg_l01.jWb-2=5---0bE]-- EDA09CD2-A31E-4330-947B-763FA081DA52 0 17:38.0 NULL NULL 17:41.0 20:03.1 67038C8A-0FC7-441A-8BEF-19E15F481384 190165
992827F9-B3C3-4088-B5E0-6021B2052D6A 0 20:03.2 0x00000000028E196C kLPITGE2gQ;J;461HNIV`M5---.=J--- EDA09CD2-A31E-4330-947B-763FA081DA52 0 20:03.1 NULL NULL 20:03.1 20:03.1 67038C8A-0FC7-441A-8BEF-19E15F481384 190165
ACAD19B2-B46B-4C03-A4CC-7F3C44558401 1 20:03.1 0x00000000028E196A 1kk=:b=5QQ3W-dFO^^_c\=5----NA=-- 35E671B2-F02A-4A05-9073-4936FE7E3DA9 0 22:37.7 NULL NULL 17:41.0 20:02.7 67038C8A-0FC7-441A-8BEF-19E15F481384 186245
2B5E6FA8-8F11-479A-B0DC-60A70C3EBC39 1 20:02.7 0x00000000028E1957 /k-gM6<1iQC\]fDDD5FF1B-8561-4A5B-A2FC-8F64492C0707 1 20:02.6 0x00000000028E1952 <29=4ZdX2CA52AAF-4FBE-434C-B936-903567357763 0 20:02.3 0x00000000028E1947 _F6C45F46E-FF5C-4C6E-840F-ECA69324ABE1 1 10:03.3 0x00000000028E18AD a1QKN2.?N1kjW.20?[L/b]5----BCM-- DB89654E-EDB4-4A10-9A00-76C976559531 0 09:48.2 00000000-0000-0000-0000-000000000001 admin 10:03.3 10:03.3 C91785F7-18F0-47D1-B607-44CFF03B3CC4 190094
D168D10A-66AD-4184-9953-FE2946F7309F 1 10:02.6 0x00000000028E1886 SJ:MegC<5QcNHQ]l\[YRF]5---/NGM-- DB89654E-EDB4-4A10-9A00-76C976559531 0 09:48.2 00000000-0000-0000-0000-000000000001 admin 10:02.6 10:02.6 C91785F7-18F0-47D1-B607-44CFF03B3CC4 190094
1679A5E8-BB00-4272-861F-48BF6255EECD 1 10:02.3 0x00000000028E1882 3YV9`.TSMa7h7\i>jVIK7-5---0[D]-- DB89654E-EDB4-4A10-9A00-76C976559531 0 09:48.2 NULL NULL 06:48.7 10:02.1 C91785F7-18F0-47D1-B607-44CFF03B3CC4 190094
1D8A7560-EF3B-45FB-862E-F90310CD1D26 1 10:02.1 0x00000000028E186F -_5QQJ]`FA?]--- DB89654E-EDB4-4A10-9A00-76C976559531 0 09:48.2 NULL NULL 10:02.1 10:02.1 C91785F7-18F0-47D1-B607-44CFF03B3CC4 190094
169DEC1A-8047-4391-9AAE-F210784298AE 1 05:02.7 0x00000000028E1836 k2Y3i>HaZ1Ka35ECF4058-4190-402C-93BC-EB4D9C290E2F 1 05:02.3 0x00000000028E1823 3KEScLBCNQKjX@eD:gTWN=5---.KF=-- DB89654E-EDB4-4A10-9A00-76C976559531 0 09:48.2 NULL NULL 05:02.3 05:02.2 C91785F7-18F0-47D1-B607-44CFF03B3CC4 190094
82213E69-8C74-4E13-8063-3C8ED75A8E77 1 40:03.1 0x00000000028E1718 ?cRdeDRa>A_E^MaY1R=@k-5---0?B--- BDF9EF4E-1BCA-4C39-A799-FC96C3A46F7F 0 35:05.0 00000000-0000-0000-0000-000000000001 admin 40:03.1 40:03.1 9001A6E1-D76B-4034-9106-BA382941E74B 190156
6BFE9B76-B048-40AE-B991-E12B2F1DEFB3 1 40:02.4 0x00000000028E16E8 OXlTTdIS-aW.Xb3DNa1k:=5---0SD]-- BDF9EF4E-1BCA-4C39-A799-FC96C3A46F7F 0 35:05.0 NULL NULL 35:12.1 40:02.0 9001A6E1-D76B-4034-9106-BA382941E74B 190156
86DF6B90-F984-458B-9DB9-1C9DB04FFBB9 0 40:02.0 0x00000000028E16DD XlA0eba3e1GkHS\aNO\.M]5---0gG]-- BDF9EF4E-1BCA-4C39-A799-FC96C3A46F7F 0 40:02.0 NULL NULL 40:02.0 40:02.0 9001A6E1-D76B-4034-9106-BA382941E74B 190156
AA7CB304-E625-415B-A9F5-CDB32408F1D8 1 25:02.3 0x00000000028E166A ;ZVB5:Z^8AgLl66A>EkklM5---0kE=-- 11E1E923-5C83-4CB0-8F05-A25788956634 0 06:19.9 00000000-0000-0000-0000-000000000001 admin 25:02.3 25:02.3 F7D5BCF1-01D1-4720-8369-34CA90C9D67F 190148
A95C0F5F-B097-4455-BF45-589C40C524FF 1 25:01.9 0x00000000028E1666 :f]eLkL//AK007DAB1E-35EE-4DA9-9E9D-5B8A86C46E49 1 25:01.6 0x00000000028E1653 VbaQaZ@[b1O31XgCJf;i8=5---/ZH]-- 11E1E923-5C83-4CB0-8F05-A25788956634 0 06:19.9 NULL NULL 25:01.6 25:01.6 F7D5BCF1-01D1-4720-8369-34CA90C9D67F 190148
86309069-F4AC-4A32-B76F-A4CD70B7BA36 1 10:01.8 0x00000000028E15A8 dMlRGF3YNAO3E\MDTCaeL]5---.:G--- 11E1E923-5C83-4CB0-8F05-A25788956634 0 06:19.9 NULL NULL 06:32.9 10:01.3 F7D5BCF1-01D1-4720-8369-34CA90C9D67F 190148
71B62F2D-D4FA-4B38-AAFB-BBB5BAEAF37B 0 10:01.4 0x00000000028E159D V>[FXBi3gAG_0QEW;]36@M5---/2@]-- 11E1E923-5C83-4CB0-8F05-A25788956634 0 10:01.3 NULL NULL 10:01.3 10:01.3 F7D5BCF1-01D1-4720-8369-34CA90C9D67F 190148
139107DB-EA73-40C9-A519-A3B62A2124CA 1 55:02.6 0x00000000028E154E c:\0>J-i8FB5BB68-F8F2-41D1-8C15-1E753E6D1D24 0 55:02.3 0x00000000028E1543 .cIWiL94517fgDOe56geE-5----gC=-- 94903508-B509-4ABC-97D7-4D8EFF47F77A 0 55:02.2 NULL NULL 55:02.2 55:02.2 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190149
05B7E55A-F2A4-4990-93E4-068178CFF197 1 45:02.5 0x00000000028E1504 XOLk^YaXi1cXGg=UU9X9MM5----WJM-- 0BCACCB4-C78D-424D-AF38-EE68E681737F 0 41:42.5 NULL NULL 41:47.5 45:02.1 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190145
B203EA33-1282-4BB1-AE78-BA4054BA7789 0 45:02.1 0x00000000028E14F8 c>]WN^9TZa[lR\JAF9a?fM5---0WC=-- 0BCACCB4-C78D-424D-AF38-EE68E681737F 0 45:02.1 NULL NULL 45:02.1 45:02.1 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190145
7A709C22-46DB-45C6-95D9-BF3B4AEF8ADE 1 35:02.6 0x00000000028E14CE =CfMEMf?QAcV\OVP3gJMK-5---.0?]-- 3FE3A861-1107-450F-AF45-515ADBDA46AB 0 09:51.7 00000000-0000-0000-0000-000000000001 admin 35:02.6 35:02.6 67038C8A-0FC7-441A-8BEF-19E15F481384 190052
834A3F0A-050C-42BD-B54B-1BC789EA72AE 1 35:02.3 0x00000000028E14CA QQYL7140ia/RIQ_=bjNBW=5---.`D--- 3FE3A861-1107-450F-AF45-515ADBDA46AB 0 09:51.7 NULL NULL 31:47.8 35:01.8 67038C8A-0FC7-441A-8BEF-19E15F481384 190052
72BFEC21-79EB-4F9E-9F18-D4D2CAE6F43A 1 35:01.8 0x00000000028E14B7 18U`Q3ESWQ?T`GF9N\ZC8-5---.;C=-- 3FE3A861-1107-450F-AF45-515ADBDA46AB 0 09:51.7 NULL NULL 35:01.8 35:01.8 67038C8A-0FC7-441A-8BEF-19E15F481384 190052
FB392302-CB85-4371-AEFD-EF367F432453 1 00:03.5 0x00000000028E13ED jO^]D3A]5QS6E8IDhXVAf=5---/VC--- FED05AD7-9876-4305-AF19-19B094EA8790 0 03:08.9 00000000-0000-0000-0000-000000000001 admin 00:03.5 00:03.5 906A2979-E623-470D-AF60-FB438DAF3196 185899
CC789C2D-1118-4881-839A-116CD5EB262D 1 00:02.5 0x00000000028E13CE 2BE265BA-E2E6-4042-ABFD-DE018536BCED 0 00:02.0 0x00000000028E13C3 H1g7k4=Z8a;HbTjF?-3TR-5---0YC=-- 8564AEE6-709B-42CE-A5BA-9FDACDA46566 0 00:01.9 NULL NULL 00:01.9 00:01.9 B96E3A4F-B099-4198-A69D-3F327BD52B7C 190142
DA24D6A5-3DCF-407E-A1B1-CDB1AAC58B9F 1 50:01.7 0x00000000028DCC41 T2VC<3W6\1W[F\VXKC?PQM5---0ME--- FED05AD7-9876-4305-AF19-19B094EA8790 0 03:08.9 NULL NULL 48:43.2 50:01.2 906A2979-E623-470D-AF60-FB438DAF3196 185899
E12AD063-C2EC-4083-B3DE-46809256A7B7 1 50:01.2 0x00000000028DCC2E IX@:^=gaWQ_dl]l3.k;2Y=5---.aIM-- FED05AD7-9876-4305-AF19-19B094EA8790 0 03:08.9 NULL NULL 50:01.2 50:01.2 906A2979-E623-470D-AF60-FB438DAF3196 185899
4D69882D-74E4-4ED0-88EF-C4507C7C8530 1 45:02.9 0x00000000028DCC05 bWgD-I[hAA;=U1BeP/\MG]5---..G=-- CBDE66FC-3A67-43C8-A416-35BC41331FAB 0 44:04.6 NULL NULL 44:15.9 45:02.3 906A2979-E623-470D-AF60-FB438DAF3196 190138
574EEEC9-FD7F-4784-AC13-C7BD8A2CCA3A 0 45:02.3 0x00000000028DCBF9 j[22@ZF>HQ_IF:QYd1jONM5---/3A7FBDB7-B642-42D3-AA7E-D4CD756A7DE5 1 35:03.9 0x00000000028DCBCB ?FY9I\/YVAG5Q1N]0SOiI]5---/;D--- E9052077-49A9-43B0-8BAA-DA5DA0C51E8D 0 29:39.3 NULL NULL 31:05.0 35:03.2 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190129
EADC0B7D-D23B-4766-881D-A6CC24382D50 1 35:03.2 0x00000000028DCBB8 R`190D215D-9E5D-4EE5-9FA1-B0B49949E8B2 1 35:03.0 0x00000000028DCBB6 /gP2gd`kDaOD4UgPH`e`h]5---0fG--- 5AE9AF56-2B7D-4391-BF76-22E1EC5B54BA 0 55:24.8 NULL NULL 33:23.7 35:02.2 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 189397
23816948-A48C-4B64-BD15-4E9ED14C9CB4 1 35:02.2 0x00000000028DCBA3 ?Q__bVW9FaO8..[WW./`.]5----6C=-- 5AE9AF56-2B7D-4391-BF76-22E1EC5B54BA 0 55:24.8 NULL NULL 35:02.2 35:02.2 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 189397
B78E7766-8651-43D6-889C-7F4D34522D51 1 30:02.8 0x00000000028DCB8F JGJ^DkZP^AC=AcWgZ?c>J=5----TG--- E9052077-49A9-43B0-8BAA-DA5DA0C51E8D 0 29:39.3 NULL NULL 29:39.3 30:02.0 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190129
148E275A-7D91-4B15-BBB6-9342CB9D62B7 0 30:02.1 0x00000000028DCB84 T^6MAhafTACk/d@91aHcGM5---/eB--- E9052077-49A9-43B0-8BAA-DA5DA0C51E8D 0 30:02.0 NULL NULL 30:02.0 30:02.0 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190129
90ADC232-9557-46DF-BE8C-5D30866D048A 1 50:02.1 0x00000000028DBE76 \]:Rc7T_N1[@7-W4YN^.--5---0jD=-- 6F5F9D4E-87A7-4C5F-8541-DCCC6F8FBE09 0 49:50.6 NULL NULL 49:50.8 50:01.9 BE40748A-2083-4357-8CEF-62CD5807F944 190132
4E72C338-B6BE-4F3D-9B36-C37AE3EC8682 0 50:01.9 0x00000000028DBE6B @`.CNf0^9akj@I9]5----@EM-- 6F5F9D4E-87A7-4C5F-8541-DCCC6F8FBE09 0 50:01.9 NULL NULL 50:01.9 50:01.9 BE40748A-2083-4357-8CEF-62CD5807F944 190132
1D9FFBD4-173D-441C-B18D-EFE1104E9DBD 1 50:01.5 0x00000000028DBE5B =c6GDKi?\1Wa:W:SKdWVe=5---.?C]-- 1531B513-F70D-499E-ADEC-C29D80B3CB76 0 08:51.2 NULL NULL 46:23.0 50:01.4 BE40748A-2083-4357-8CEF-62CD5807F944 181863
601035B9-7A40-4EC7-8660-9C63A392B694 1 50:01.4 0x00000000028DBE48 .7P@<.Ag?1W`XjR\=7\=W-5----VB]-- 1531B513-F70D-499E-ADEC-C29D80B3CB76 0 08:51.2 NULL NULL 50:01.4 50:01.4 BE40748A-2083-4357-8CEF-62CD5807F944 181863
58EAAC26-9EE7-4AF7-9201-5FAFEA30CD54 1 00:02.7 0x00000000028D2F77 0@LWV6^N0QG7DKaFTFC07M5---/`B=-- 83AC4F8B-8462-49E5-B7FD-7677CE41EB3F 0 47:03.7 NULL NULL 00:00.2 00:02.6 B0725532-E801-4EFB-8C4B-02C80A18C518 187985
45EBF940-4912-4035-A243-5C3393FCABF5 1 00:02.6 0x00000000028D2F64 E:4.ZYZE?QCP9XJ_kkgNW]5---/.J--- 83AC4F8B-8462-49E5-B7FD-7677CE41EB3F 0 47:03.7 NULL NULL 00:02.6 00:02.6 B0725532-E801-4EFB-8C4B-02C80A18C518 187985
C4507B87-1240-4F7A-B417-09F6F6CB1E04 1 00:02.5 0x00000000028D2F62 I/-PfH;QUQ3OPa8;lM[>X=5---.HF--- 2E8BF6AC-D894-4745-9C77-6F64779830FC 0 12:01.0 NULL NULL 00:00.2 00:02.5 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 187944
58BD4F93-FD9C-4579-86C1-D9B1B60B101E 1 00:02.5 0x00000000028D2F4F Cl/\TWbeGQONK5SL@Ve7YM5----VH=-- 2E8BF6AC-D894-4745-9C77-6F64779830FC 0 12:01.0 NULL NULL 00:02.5 00:02.5 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 187944
E7C95502-2B21-4D31-A9B1-B6B28FC892B1 1 00:02.4 0x00000000028D2F4D ;JSDI>91JQ3CdVBSXS^Zf]5---.?C]-- D77B73EA-37F1-4A89-8934-645964053FDA 0 34:38.3 NULL NULL 00:00.2 00:02.3 C91785F7-18F0-47D1-B607-44CFF03B3CC4 187979
B2BA3895-1738-4B6C-8A11-FADF37AB18A4 1 00:02.3 0x00000000028D2F3A :Hk]cTEh[QkPZll4[B277]5----lI=-- D77B73EA-37F1-4A89-8934-645964053FDA 0 34:38.3 NULL NULL 00:02.3 00:02.3 C91785F7-18F0-47D1-B607-44CFF03B3CC4 187979
26B35FDB-0216-4634-B9F8-1B59C4961FDF 1 00:02.3 0x00000000028D2F38 BLCkQJeeDa7f3lO7Sf5.R=5---/]H=-- C4F91575-0D38-4235-9E9A-5CD6338E3393 0 07:53.6 NULL NULL 00:00.2 00:02.2 ABC4DB27-FD74-4429-8575-FF664A1C723F 187943
3D0A48F1-40BF-4884-B08E-11CE5B8C00F5 1 00:02.2 0x00000000028D2F25 WJ]:^b5XcQS4;[-HWVbVgM5----LFM-- C4F91575-0D38-4235-9E9A-5CD6338E3393 0 07:53.6 NULL NULL 00:02.2 00:02.2 ABC4DB27-FD74-4429-8575-FF664A1C723F 187943
B40F1289-9B5D-4243-8638-9FABA313FE67 1 00:02.1 0x00000000028D2F23 08kM>[cS9AKHJ.G\K.-HC=5---/]B]-- BEE3CCDA-90E5-482D-89A3-07835F2FAB3E 0 08:37.4 NULL NULL 00:00.2 00:02.0 D7FFB0CD-835C-416F-85EA-6CC0F037ABE9 187946
D1CBE108-638C-42A5-B9E3-A7D48D342AAF 1 00:02.0 0x00000000028D2F10 T4g7W\`akQOeGaiF;I9Da=5---0IJM-- BEE3CCDA-90E5-482D-89A3-07835F2FAB3E 0 08:37.4 NULL NULL 00:02.0 00:02.0 D7FFB0CD-835C-416F-85EA-6CC0F037ABE9 187946
3E9F1B04-3BB3-449F-BF70-7C57EDF8735C 1 00:02.2 0x00000000028D247E fA.c:He65QG^lU=D`V0j@M5---.44CF8A93-B7AE-4945-951C-13A4B31D2413 0 00:01.9 0x00000000028D2473 1F-J_HMk:QCLVlDQeTG;b=5----1E]-- 0DBD5C81-417E-4EC5-9D14-C72EF74998C2 0 00:01.8 NULL NULL 00:01.8 00:01.8 59F028AC-57A4-4DC9-B515-F30F38422721 190125
F9EF710B-0630-4DE5-B51E-E753A04CBE98 1 35:01.8 0x00000000028D2415 15F1F069-A0DC-4344-B4BA-3E8C5CE1A3A3 1 21:19.3 0x00000000028D23A7 6b:13B14968-3349-4431-AA87-D553DDB91318 1 21:19.3 0x00000000028D23A5 kf088CD606-82FF-4F2E-A82A-9A80E37690C9 1 17:18.2 0x00000000028D2334 -W^SeC;9eQk?83Z=\CebNM5---.ADM-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 17:18.2 17:18.2 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
37FC3844-E044-4258-862B-D433886CDC35 1 17:18.1 0x00000000028D2332 c.T\AW[:91[H3IOPa7AA>]5----RF=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 15:02.7 15:02.7 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
00C1513B-FE04-4EF1-BC08-FA9F07EFFDBD 1 15:02.7 0x00000000028D230F ?_k7;ALQ:AWHL50^gh:R_]5---0bC]-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 15:02.7 15:02.7 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
DBB60FB6-7D38-48C1-9A7E-A9547543AA70 1 15:02.7 0x00000000028D230D CDa.Ve]]eQk6hh-1Zalk3-5---.JD=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
EAB20129-3B7D-44BC-8C9A-42AE59A5FEE2 1 14:59.9 0x00000000028D22EF MWKlcN:T^aSI4177]LU_G]5---.MG--- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
F50AE155-8A77-45AB-A363-483251FFA0F6 1 14:56.7 0x00000000028D22EA D-@QY;bXfQS-HI_bY.5`]=5---/@H--- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
E100E748-A015-44CE-A019-42DBB2271FDB 1 13:00.7 0x00000000028D22A3 8AI\DB@bMQkY\alF\jI?]=5----9D--- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
A110EDE8-280A-4834-89AB-BD75E6378B70 1 12:54.7 0x00000000028D2294 9_[QZ]Z9jQ3R_T/b//DRf=5----7C]-- A2237338-2AF3-449D-8E03-E915D61C458C 0 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 Drew 12:41.1 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 190121
BF3B92CB-2F0F-4927-B1E3-EDA0D4FEB0FC 1 12:53.6 0x00000000028D228F lHZaSXAei1OI4iWKJXIg8=5---.aJ--- A2237338-2AF3-449D-8E03-E915D61C458C 0 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 Drew 12:41.1 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 190121
B73E4EC4-72F1-4052-A045-5E340877B1C1 1 12:52.8 0x00000000028D228A :T6811O6V1/ZBj4W`6.6H]5----fBM-- A2237338-2AF3-449D-8E03-E915D61C458C 0 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 Drew 12:41.1 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 190121
66E81A7C-0B89-45B8-BBD9-E8043B00A72E 1 12:52.1 0x00000000028D2285 -ICjQ9Q=BQOa\/_JHSO[?M5-----D]-- A2237338-2AF3-449D-8E03-E915D61C458C 0 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 Drew 12:41.1 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 190121
F8BC77D1-C51D-49F2-A210-EDECA5D43210 1 12:51.0 0x00000000028D2280 5Pcd]kSFZQO1V9eU_9^h=-5---0>H--- A2237338-2AF3-449D-8E03-E915D61C458C 0 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 Drew 12:41.1 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 190121
A714DC64-ED90-410C-9229-40F85815759E 0 12:41.1 0x00000000028D2276 3UVRkRH31a;DXFS:;a7bUM5---0ZD=-- A2237338-2AF3-449D-8E03-E915D61C458C 0 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 Drew 12:41.1 12:41.1 BDC817ED-6BA7-4D0D-ADF1-D4F6943EF350 190121
335F82CB-1C00-4DFA-A806-200F0B0DE4DC 1 10:19.1 0x00000000028D2274 .=dLl^-k_AcH.;cTi0`\\M5---/;DM-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
A15ABE3D-7133-4603-8300-CAC2DA15F679 1 10:01.6 0x00000000028D225A HQ2_lcES817^NPJJ_:k;KM5---.7CM-- F60E1BD2-C536-498C-9805-D4C361B7E02D 0 35:31.5 NULL NULL 09:33.8 10:01.3 906A2979-E623-470D-AF60-FB438DAF3196 189914
884F2F8B-3CB1-430E-BC22-124A8A1BDAEB 1 10:01.3 0x00000000028D2247 e:FW2f.;71108DC5-F2B0-41E1-8C78-0B435D2424DC 1 09:54.1 0x00000000028D223F G_;b^e3a`A7MHf/Z@4Y-M]5---.MFM-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
D0B0BE61-4AB9-4BF2-96EF-74D89EE382D7 1 09:31.3 0x00000000028D223D Q@XK:T3g1Q_EN[VV_-//_M5---/LE--- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
3870F8D8-CA7C-420B-A0F7-4C2EF6A4CB3E 1 09:15.9 0x00000000028D223B aKHVcU@a2QSG`Pef\HG`=]5---/NM--- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
4FEC87A9-0BA4-413D-B762-EEDCBD40FC2B 1 09:03.3 0x00000000028D2236 \_]d9gM62a;`i9Ne-_=l.-5---/4?M-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
31DD41E7-D6BF-4FE2-8915-39DC3FF7C43B 1 08:37.4 0x00000000028D2231 k61EKSe^jAW^ZOdiM3Dgi=5---0YHM-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
FE0DA0A4-748D-42D8-9E64-B985156B606A 1 08:09.5 0x00000000028D222C Z;Y@Me_NBQc_X>>R;j3FE]5---/;F=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
630FB65B-C47F-4C12-AFAD-EE7AA85FD182 1 08:02.4 0x00000000028D2227 0<.REcXRh1Ci`MkX-ib39M5---.jF=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
7C354DB0-7DB3-4777-8789-6E73B3DFD9DB 1 07:57.8 0x00000000028D2222 X4:YgM]IF675C7E2-B376-4D18-929B-21E0FECBCE0D 1 07:40.3 0x00000000028D221D Lj4FX1Q=U1;2k@3-GFX<3M5---0lG=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
599C08FF-FE16-49BF-8CBA-472812A2F9B9 1 07:26.2 0x00000000028D2218 28SfkEc2^Q_d[8\laRfh5=5---/@K=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
10BACCD8-53ED-41A0-8BD4-6F18296D5339 1 07:01.5 0x00000000028D2216 dCP/h4Y:NQk30]PLGK?ZPM5---/7G=-- 334C7BF7-2D8A-4AF5-9895-9D5F9FC05668 0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F Dave 00:00.0 00:00.0 ABC4DB27-FD74-4429-8575-FF664A1C723F 190119
61695ABC-11BB-4FF2-9D29-54F454D271B0 1 06:55.5 0x00000000028D21DC ;[\7E53841F-A687-489A-8C6C-688BD0F31671 1 06:55.2 0x00000000028D21D2 ;[\A0D0E33A-EEF1-487F-BFC7-8E1D48F94788 0 06:55.2 0x00000000028D21D0 ;[\2DACDF6D-AC4F-4A0E-9215-7D68CE39A879 1 50:01.8 0x00000000028D215C B1^[.Y?/3aCV:QjbZ.2@W]5----5?M-- 4F2578DC-DCF5-4D8F-BD01-50C9B0769A89 0 46:27.1 NULL NULL 46:29.3 50:01.5 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190113
890748F2-BEF9-4496-A071-81B6E6F76850 0 50:01.5 0x00000000028D2151 _>SYB=3cR1;M00OX-iBC/M5---.bA=-- 4F2578DC-DCF5-4D8F-BD01-50C9B0769A89 0 50:01.5 NULL NULL 50:01.5 50:01.5 A0A0CB16-768E-4F79-B9D6-72A5BF1DF9FF 190113
New Post
 3/29/2013 5:39 PM
 
 Modified By Support  on 3/29/2013 11:12:04 PM
What version of SQL Server are you running? We provide SQL Server Express because it is free, but there are well documented limits to the CPUs, RAM and disk space. My first suggestion would be to make sure that the SQL Server app has sufficient horsepower.

In production, we are running SQL Server 2008 R2 with 16G RAM, 8 CPU cores and the appropriate RAID hard disks. Our corporate database is 30G. Both the EMAILS table and the EMAILS_AUDIT table have over 250,000 records and we are not having a performance problem.
New Post
 3/29/2013 6:18 PM
 
SQL Server 2008 R2
4 Cores
16GB RAM
Appropriate Raid HDDs

You don't ever clear out your AUDIT tables?

Drew
New Post
 3/29/2013 11:15 PM
 
No, we have not, though we are no longer going to recommend that the EMAILS table be audited.

Most of the email records are created once and never edited. Unlike most other records in the system, an email that you receive is read-only and an email that you send is read-only after it has been sent. So the only time an email is edited is when it is being created as a draft and sent later. This is such a rare operation in the CRM that it does not justify auditing the EMAILS table for this one situation.
New Post
 6/13/2013 9:14 AM
 
I too wanted to know what version of SQL Server are you running? Does it have sufficient horse power?
Previous Previous
 
Next Next
ForumForumMainstream Foru...Mainstream Foru...Best PracticesBest PracticesDatabase Management and AuditTablesDatabase Management and AuditTables