Using the dm_exec_query_stats in 2005, I know I can get the number of
executions for a particular sql_handle, but is it possible to get the
number of execs for a SQL in version 7 or 2000? Also is it possible to
get reads/writes/etc in these early versions?
Thanks.Hi
You should be able to collate this information using SQL profiler.
John
"Rick" wrote:
> Using the dm_exec_query_stats in 2005, I know I can get the number of
> executions for a particular sql_handle, but is it possible to get the
> number of execs for a SQL in version 7 or 2000? Also is it possible to
> get reads/writes/etc in these early versions?
> Thanks.
>
Monday, March 19, 2012
How to tell how many times an SQL executed in v7 or v2000?
Labels:
database,
dm_exec_query_stats,
executed,
microsoft,
mysql,
number,
ofexecutions,
oracle,
particular,
server,
sql,
sql_handle,
thenumber,
v2000
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment