PowerShell 3rd Party tool Memory Alert

Question

Post reply

PowerShell 3rd Party tool Memory Alert

SQLShark

SSCrazy

Points: 2214
More actions
April 15, 2017 at 1:03 pm

#324480

Comments posted to this topic are about the item PowerShell 3rd Party tool Memory Alert

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 1

Are you saying that "Idera" produced the memory leak? How did you determine this either way?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLShark SSCrazy Points: 2214 More actions · Answer 2

Seems the "particular" 3rd party exe not to mention any names is on 2 different servers and 1 of them it eats the memory in X days to the point it is not functional and even a service re start hangs. So for a temporary band aid until the "3rd party vendor hands us a fix this works for now. The solution is a fix from the vendor not the band aid. Thanks for checking it out and posting, Ed

SQLShark SSCrazy Points: 2214 More actions · Answer 3

Gee, I posted another script after deleting this one I did not want to mention any vendor names. Seems the original one is up, oh well..or should I say "Yikes"..

SQLShark SSCrazy Points: 2214 More actions · Answer 4

This numeric alert value needs "20" quotes around it.
Ed