Wednesday, March 21, 2012

Measuring daily Inserts/updates on a production databse

I want to measure updates/Insertion rate of my databse in order to measure that how percent the databses is booked for insert and update.

can some one can suggest me the mechanism or other resource for doing this work...

thanxs in advance

It is not very clear what kind of data you are hoping to capture.

Perhaps looking at some of the Performance Monitor counters could help.

Perhaps some of the dynamic system views, such as: sys.dm_db_file_space_usage

|||I want to measure/calculate that how many number of Inserts and Updates operated on my database let say AAA|||

probably you want to find out the number of transaction per database. Read : http://msdn2.microsoft.com/en-us/library/ms189883.aspx.

Madhu

|||In SQL 2005 you can also look at sys.dm_db_index_operational_stats.sql

No comments:

Post a Comment