SQL Server : counter for insert,update,delete & select queries -


i newbie sql server. in mysql find count of insert, update, delete, select queries have below queries:

select

mysql> show global status '%com_select%'; +-------------+-----+ | variable_name | value | +-------------+-----+ | com_select    | 1     | +-------------+-----+ 1 row in set (0.00 sec) 

insert

mysql> show global status '%com_insert%'; +-----------------+-----+ | variable_name     | value | +-----------------+-----+ | com_insert        | 0     | | com_insert_select | 0     | +-----------------+-----+ 2 rows in set (0.00 sec) 

update

mysql> show global status '%com_update%'; +----------------+-----+ | variable_name    | value | +----------------+-----+ | com_update       | 0     | | com_update_multi | 0     | +----------------+-----+ 2 rows in set (0.00 sec) 

delete

mysql> show global status '%com_delete%'; +----------------+-----+ | variable_name    | value | +----------------+-----+ | com_delete       | 0     | | com_delete_multi | 0     | +----------------+-----+ 2 rows in set (0.00 sec) 

similarly there equivalent queries find count of insert, update, delete, select queries in sql server?

thanks !!!

edit : sql server performance counter sys.dm_os_performance_counters provides page reads/sec & writes/sec wise there anyother counters can provide insert,update,delete counts?


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -