I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solutio
n.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible fr
om
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>
Showing posts with label trace. Show all posts
Showing posts with label trace. Show all posts
Thursday, February 16, 2012
Commercial Audit Software
I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
Thanks
Lumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>
|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
Thanks
Lumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>
|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...[vbcol=seagreen]
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
Commercial Audit Software
I'm looking for a good commercial, 3rd party solution, not a Trace solution.
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>> I'm looking for a good commercial, 3rd party solution, not a Trace
>> solution.
>> Can anyone provide comments on something they have in production? So
>> far, my limited research has turned up Lumigent Entegra, and RippleTech
>> LogCaster.
>> My goal is to track DML changes by login with minimal impact on system
>> performance. Further, I need the audit data to be as secure as possible
>> from
>> malicious updates and deletes. This is to implement audit tracking for
>> SOX
>> compliance.
>> Thanks
>>
Can anyone provide comments on something they have in production? So
far, my limited research has turned up Lumigent Entegra, and RippleTech
LogCaster.
My goal is to track DML changes by login with minimal impact on system
performance. Further, I need the audit data to be as secure as possible from
malicious updates and deletes. This is to implement audit tracking for SOX
compliance.
ThanksLumigent Entegra is probably the most mature product on the market for
server-level auditing. It isn't perfect, but it can go a long way towards
filling the audit requirements.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Garth Wells" <nobody@.ishome.com> wrote in message
news:uoCCTMXKFHA.2852@.TK2MSFTNGP14.phx.gbl...
> I'm looking for a good commercial, 3rd party solution, not a Trace
> solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible
> from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>|||Manakoa Services Corporation is releasing a System Controls MP for MOM2005
which provides basic collection and reporting for windows security events.
You can review the features at http://www.manakoa.com/products/scmp/
The RTM is scheduled for May 31st. If your interested in particpating in the
beta you can contact me at jbeckett@.manakoa.com for more info.
"Garth Wells" wrote:
> I'm looking for a good commercial, 3rd party solution, not a Trace solution.
> Can anyone provide comments on something they have in production? So
> far, my limited research has turned up Lumigent Entegra, and RippleTech
> LogCaster.
> My goal is to track DML changes by login with minimal impact on system
> performance. Further, I need the audit data to be as secure as possible from
> malicious updates and deletes. This is to implement audit tracking for SOX
> compliance.
> Thanks
>
>|||You can try LiveAudit from www.datamirror.com. It captures inserts updates
and deletes from the ms_replcmds table in the distribution database. You
need to publish the tables that you need to track. In addition to the actual
change in a row, you can also add journal information such as who made the
change, when the change was made, and what type of change accured among
other journal control information the changes are then reported as table
entries in most databases available. From there, you can use something like
Crystal reports to look at the history or trail of the changes made to the
database.
Hope this helps,
RdR
"Jeremiah Beckett" <Jeremiah Beckett@.discussions.microsoft.com> wrote in
message news:B08EC974-72DB-461F-AAEB-98CE1687852A@.microsoft.com...
> Manakoa Services Corporation is releasing a System Controls MP for MOM2005
> which provides basic collection and reporting for windows security events.
> You can review the features at http://www.manakoa.com/products/scmp/
> The RTM is scheduled for May 31st. If your interested in particpating in
> the
> beta you can contact me at jbeckett@.manakoa.com for more info.
>
> "Garth Wells" wrote:
>> I'm looking for a good commercial, 3rd party solution, not a Trace
>> solution.
>> Can anyone provide comments on something they have in production? So
>> far, my limited research has turned up Lumigent Entegra, and RippleTech
>> LogCaster.
>> My goal is to track DML changes by login with minimal impact on system
>> performance. Further, I need the audit data to be as secure as possible
>> from
>> malicious updates and deletes. This is to implement audit tracking for
>> SOX
>> compliance.
>> Thanks
>>
Sunday, February 12, 2012
Command Line - Replay of SQL Trace? SQL 2005
Hello,
I have to replay a SQL trace over and over again. I can do this with the profiler GUI however I see no way of doing this with a command line utility.
1) Is there a utility that will allow me to replay a trace via command line?
2) Is there a way to tell profiler to automatically run the replay I am requesting and then shut down?
3) Are there any .net classes I might code against to programatically start this replay?
Thanks for your help,
David Sandor
Hi,
what about saving the commands to a file and executing them with SQLCMD and the -o switch ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Well, the trace(s) I need to replay are quite long (500+ statements). I did however come up with a solution. I wrote a little C# app that reads the XML trace file and executes the statements using the Enterprise Library for the data layer. Very similar to your suggestion.
Thanks,
David Sandor
Subscribe to:
Posts (Atom)