Database perfomence

[Former Member]

My McAfee EndPoint Encryption database contains more that 40K user + machine object and recently I have noticed that the performance becoming slow means when I open any object it will take some time.And I also change the registry settings that give by McAfee support to increase.

So is there any way to increase the performance. In addition to that Local backup to another drive is once in time (@ midnight). Change bit & Attribute bit backup at every 2 hrs interwal to remote server.

Need your views

on 3/5/10 3:02:05 AM CST

[Former Member]

Are best practices document ideas implemented fully?

[Former Member]

Yes... but except below two

1.  NtfsMftZoneReservation values

2. One user group contains more than 15K users objects (Group size).

[Former Member]

You need to fix that group size. Aim for 5K or less. Use AD OU's to map groups. You can still use single AD connector.

[Former Member]

Yes.. i will take care of Group size.. but that NtfsMftZoneReservation gives any better result ??? I haven't did it in past and apart from this anything I can do on server to increase performence.

[Former Member]

With 40K of objects (assuming logicaly deleted are included in that count), you probably not need to worry about MFT. But run a quick check and see if there are many MFT fragments.

Make sure that object audit logs do not grow beyond 200kB. Clean them as neccessary.

[Former Member]

Can you provide me the detailed information for MFT fragments. ??

Please .....

[Former Member]

defrag X: /a /v

Will show you MFT defragmentation on disk X:, similar to:

Master File Table (MFT) fragmentation
    Total MFT size                      = 58 MB
    MFT record count                    = 54,421
    Percent MFT in use                  = 91
    Total MFT fragments                 = 3