November 23, 2012 at 1:54 pm
Hola que tal. Quisiera que me ayudaran por favor. Necesito monitorear las inserciones que se realizan en las tablas de una Base de Datos asi como sus transacciones. Quiero realizar un monitoreo constante de las inserciones que vaya teniendo en mi base de datos, asi como consultas, Update, delete... No quisiera usar trigger debido a que me consume mucho recursos.
Tengo Sql Server 2008 R2 Edición Standard.
Saludos y gracias.
November 23, 2012 at 2:01 pm
No comprende Espanol. Not sure if other spanish experts are around.
Any chance of posting this in english ?? 🙂
November 23, 2012 at 2:09 pm
Sorry, I try again, my vocabulary in English is not very good...
Hello all. I would like to help me please. I need to monitor the inserts and transactions that are made to the tables in a database . I want to make a constant monitoring of the inserts to be taking into my database and consultations, UPDATE, DELETE ... I would not use trigger because I consuming resources.
I have Sql Server 2008 R2 Standard Edition.
November 23, 2012 at 2:15 pm
ricardomijares64 (11/23/2012)
Sorry, I try again, my vocabulary in English is not very good...Hello all. I would like to help me please. I need to monitor the inserts and transactions that are made to the tables in a database . I want to make a constant monitoring of the inserts to be taking into my database and consultations, UPDATE, DELETE ... I would not use trigger because I consuming resources.
I have Sql Server 2008 R2 Standard Edition.
If you want to monitor, I would suggest a profiler trace. Be very careful though - you want to filter down the trace template down to only exactly what you want to see, as this can also be very resource intensive if not configured correctly. You can also pipe profiler output to a file and/or a SQL table. I assume that all of your insert / update / delete code is unencrypted, of course.
November 24, 2012 at 11:42 am
You may also want to look into Change Data Capture (CDC)
http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx
B
November 26, 2012 at 12:39 am
November 26, 2012 at 12:04 pm
Thanks for your answers, I'll try your suggestions. Greetings. Very friendly.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply