Monitorear las inserciones y transacciones en base de datos

  • 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.

  • No comprende Espanol. Not sure if other spanish experts are around.

    Any chance of posting this in english ?? 🙂

  • 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.

  • 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.

  • You may also want to look into Change Data Capture (CDC)

    http://msdn.microsoft.com/en-us/library/bb522489(v=sql.105).aspx

    B

  • 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