MS SQL data change rate
27 November 2014, 03:03 PM
#1
Scooby Regular
Thread Starter
Join Date: Mar 2001
Location: Berkshire
Posts: 5,528
Likes: 0
Received 0 Likes
on
0 Posts
MS SQL data change rate
Hi all
Is there any MS SQL experts out there ? If so do you know how you can check the data change rate in a database ? Is there any built in tools or do you need to run some scripts or external products ? Version SQL2008 and 2010.
Thanks in advance
Dave
Is there any MS SQL experts out there ? If so do you know how you can check the data change rate in a database ? Is there any built in tools or do you need to run some scripts or external products ? Version SQL2008 and 2010.
Thanks in advance
Dave
06 December 2014, 07:36 PM
#2
There are SQL sp's that can provide details of DML (data manipulation language) changes which occur on a table - this doesn't happen out of coincidence, this needs to be enabled on specific tables.
Too much to try and explain in a post, and it is not totally clear if this is what you need from your original post - have a read on TechNet, starting point here http://technet.microsoft.com/en-us/l...ql.105%29.aspx
Too much to try and explain in a post, and it is not totally clear if this is what you need from your original post - have a read on TechNet, starting point here http://technet.microsoft.com/en-us/l...ql.105%29.aspx
Thread
Thread Starter
Forum
Replies
Last Post
Sam Witwicky
Engine Management and ECU Remapping
17
13 November 2015 10:49 AM