Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitorear las inserciones y transacciones en base de datos Expand / Collapse
Author
Message
Posted Friday, November 23, 2012 1:54 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 12:00 PM
Points: 5, Visits: 60
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
Posted Friday, November 23, 2012 2:01 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
No comprende Espanol. Not sure if other spanish experts are around.

Any chance of posting this in english ??
Post #1388253
Posted Friday, November 23, 2012 2:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 12:00 PM
Points: 5, Visits: 60
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
Posted Friday, November 23, 2012 2:15 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 22, 2013 10:13 AM
Points: 79, Visits: 200
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.

Post #1388255
Posted Saturday, November 24, 2012 11:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 28, 2014 7:14 AM
Points: 167, Visits: 682
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 21, 2014 9:46 AM
Points: 387, Visits: 1,078
See this posting.

http://sqlblog.com/blogs/louis_davidson/archive/2007/08/26/sys-dm-db-index-operational-stats.aspx
Post #1388451
Posted Monday, November 26, 2012 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 27, 2014 12:00 PM
Points: 5, Visits: 60
Thanks for your answers, I'll try your suggestions. Greetings. Very friendly.
Post #1388770
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse