Monday, March 19, 2012

How to tell how many times an SQL executed in v7 or v2000?

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.
>

No comments:

Post a Comment