September 24, 2009 at 12:48 pm
Gentlemen,
My questions are about encrypted stored procedures.
1. Does it make sense to encrypt the SP at all?
I would looooove to get YOUR professional opinion.
2. We are using a sql performance monitoring tool.
And apparently it’s not able to capture the encrypted SP sql statement not even a name for that SP.
Problem with that is that our client’s application using ONLY encrypted SP.
So basically client’s sql activity is not being properly monitored.
Am I missing something here?
Thanks,
September 24, 2009 at 12:54 pm
I personally think encrypting sp's is a waste of time. If you are concerned about your IP or proprietary business logic it should go in the application or use the CLR so it is compiled.
I would think that your 3rd party monitoring product should be able to show the stored procedure execution and name and if it doesn't I'd start looking into a new product. Calls to the sp aren't included just the text of the procedure. Have you called the vendor?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 24, 2009 at 1:00 pm
yes, I did
they confirmed that encrypted SP are not visible
they said that at least the names of the Enc SP should show up....
it's not so, it just shows as 'other activity' 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply