Monitorear las inserciones y transacciones en base de datos

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Monitorear las inserciones y transacciones en...

Monitorear las inserciones y transacciones en base de datos

Rate Topic

Display Mode

Topic Options

Author

Message

ricardomijares64

Posted Friday, November 23, 2012 1:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:11 PM
Points: 5, Visits: 45

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.

Post #1388250

sqlGDBA

Posted Friday, November 23, 2012 2:01 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 03, 2013 10:05 AM
Points: 78, Visits: 185

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

Any chance of posting this in english ?? Smile

Post #1388253

ricardomijares64

Posted Friday, November 23, 2012 2:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:11 PM
Points: 5, Visits: 45

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.

Post #1388254

sqlGDBA

Posted Friday, November 23, 2012 2:15 PM

SSC Journeyman

Group: General Forum Members
Last Login: Friday, May 03, 2013 10:05 AM
Points: 78, Visits: 185

ricardomijares64 (11/23/2012)

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.

Post #1388255

bleroy

Posted Saturday, November 24, 2012 11:42 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 4:46 AM
Points: 138, Visits: 549

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

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

B

Post #1388322

Posted Monday, November 26, 2012 12:39 AM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 3:36 AM
Points: 305, Visits: 493

See this posting.

http://sqlblog.com/blogs/louis_davidson/archive/2007/08/26/sys-dm-db-index-operational-stats.aspx

Post #1388451

ricardomijares64

Posted Monday, November 26, 2012 12:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 1:11 PM
Points: 5, Visits: 45

Thanks for your answers, I'll try your suggestions. Greetings. Very friendly.

Post #1388770

« Prev Topic | Next Topic »

Permissions