February 15, 2010 at 5:34 am
Guys I would like to know how do you determine what actions a database performs? For exampe, I would like to be able to determine if a database does lots of deletes or inserts etc. So basically how do you determine what actions your database carries out on a day to day basis
February 15, 2010 at 6:23 am
mstephens1754 (2/15/2010)
Guys I would like to know how do you determine what actions a database performs? For exampe, I would like to be able to determine if a database does lots of deletes or inserts etc. So basically how do you determine what actions your database carries out on a day to day basis
1.You have to run server side trace.
2.What SQL Statements Are Currently Executing?[/url]
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2010 at 7:26 am
Hi,
Query following sys.dm_db_index_operational_stats(DB_ID(),null,null,null) function to list how many inserts, deletes and updates are done for an index. This function will give u index/table level view Formulate SQL statement to get desired result.
Deepak Khattar
February 15, 2010 at 7:37 am
If you want to spot check things, you can also use Profiler to see interactively what the trace is capturing.
For gross measurements of changes v queries, you can also use performance counters to determine reads v. writes.
Can I ask what you are trying to determine here?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply