cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
erez
Level 8
Report Inappropriate Content
Message 1 of 8

SQL Express - No more Space

Jump to solution

Hey Guys!

I need your help,

I got to a 0MB space in the DB and I couldn't add any more policies.

I started deleting events, and it hardly went down.

I got to a point that I have left only the last 30 days of events, and I still have only 9GB of space left,

not sure how to deal with this and get more space.

Thanks.

1 Solution

Accepted Solutions
Hawkmoon
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 8 of 8

Re: SQL Express - No more Space

Jump to solution

Hi erez,

Thank you for the email and images!!

Yes, 100 devices is 'light years away' ! 😊

I'd ask that you take this up with the DLP guys to look at, the space is being used by UDLP incidents which is not something  ePO can answer as it/we are not DLP orientated.
I do recall (if a little vaguly) they deal with their data is a unique way which is what I believe you need here.

DLP support Forum 

(If no one minds I’d like to leave this thread here (like a pointer) to help others who may come across a space concern with ePO and the source is DLP incidents.)

 

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

7 Replies
ludaneva
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 8

Re: SQL Express - No more Space

Jump to solution

Hello Erez,

Considering that the express database has reached the storage limit, shrinking would also be needed to gain back space. Please see this article, specifically the Shrinking ePO Database section:  https://kc.mcafee.com/corporate/index?page=content&id=KB68961

Thanks

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
erez
Level 8
Report Inappropriate Content
Message 3 of 8

Re: SQL Express - No more Space

Jump to solution

Hey,

I did look at this KB already and because of that, I opened this thread.

When going down from 90, to 60, and 30 days of purging events it only cleared 1GB, and there are hardly any events when querying for the top 10 events.

I had this issue 3 months ago, shrank the DB together with the support and it solved it.

Should I shrink it again or open again an SR?

Thanks.

ludaneva
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 8

Re: SQL Express - No more Space

Jump to solution

Hi Erez,

I understand that this matter has already happened before. You could go ahead and shrink again, but please do open an SR for support to look into this in depth and suggest best action to avoid it happening again going forwards.

Many thanks

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
Hawkmoon
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 8

Re: SQL Express - No more Space

Jump to solution

Hi guys,

We have an artilce about dB maintenence that calls out the use of shrik operaions.

REGISTERED - Recommended maintenance plan for ePolicy Orchestrator databases using SQL Server Management Studio
Technical Articles ID:   KB67184

See the section titled: 'Shrink Database and why it is NOT recommended'

However, we do need to do this sometimes, and when that action is performed, 're-indexing' is advised, as the article offers.

SQL express has a maximum size 10gb, and is generally used in estates with low node counts up to and around 5,000 devices for example.

How many devices do you have please?
(Might be time full SQL install)

The events table in the database is 99% of the time the source of any dB growth, if you are fast running out of 'events' to remove(/purge) I'm interested to understand what is taking up so much space at all.
Do you havea db summary report I can review?
Not here in the forum mesage me privatly please!

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

erez
Level 8
Report Inappropriate Content
Message 6 of 8

Re: SQL Express - No more Space

Jump to solution

Hey,

I also think that shrinking is not recommended.

We have hardly 100 devices, which is years of light from the 5,000 device count.

I'll DM you regarding the DB summary.

cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 7 of 8

Re: SQL Express - No more Space

Jump to solution

Can you send me the db summary also please?

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

Hawkmoon
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 8 of 8

Re: SQL Express - No more Space

Jump to solution

Hi erez,

Thank you for the email and images!!

Yes, 100 devices is 'light years away' ! 😊

I'd ask that you take this up with the DLP guys to look at, the space is being used by UDLP incidents which is not something  ePO can answer as it/we are not DLP orientated.
I do recall (if a little vaguly) they deal with their data is a unique way which is what I believe you need here.

DLP support Forum 

(If no one minds I’d like to leave this thread here (like a pointer) to help others who may come across a space concern with ePO and the source is DLP incidents.)

 

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community