Hi all,
Does anyone knows if exists any tool (from microsoft or other vendor) that allows us to monitor all the activity that is generated in SQL server?
I mean Network appliances or servers that monitor database activity and log activity that is external to the database server, and can generate alerts based on unusual behavior or policy violations. Often rely on a local agent to monitor activity.
I am looking for a tool that not searchs on .log files, or creates triggers.
Any suggestion? any known tool? Pls, send me your answers to lc@.quantumsystem.com
Thanks
You can run Profiler externally, put the output into SQL Tables, set Triggers and Alerts to fire from the data.
And the traces can be conformed and customized in just about any way you desire.
|||Ok, this is not a possible solution.
We are in a bank, so we need to secure our sql. We need no one to cheat the server or the log files (that is why i asked for a non standard sql procedure).
I want some tool from an external provider.
does anyone knows some tool? Remember i dont want tools that reads the log file, or that just add triggers to databases and tables.
We do not want a hardware based solution too...
I hope you can help me.
Regards,
|||If you don't want to export to a log file... and you don't want to introduce triggers... what options are left?
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Paul:
there are some tools (one at least) that runs some monitors (as software services) that allows you to monitor each SQL server, without the option for administrators or DBAs to stop them.
This monitors are connected to central repositories that store all the audited data.
You can audit everything: from select sentences until COPY databases commands, or whatever happens inside the database.
The thing is that i am trying to search , to see if there is another tool, instead the one that we have.
ThankS!
No comments:
Post a Comment