|
Home > Archive > Microsoft SQL Server forum > February 2006 > How to tell how many times an SQL executed in v7 or v2000?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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.
| |
| Erland Sommarskog 2006-02-25, 9:44 am |
| Rick (rick_snow_ora@hotpo
p.com) writes:
> 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?
These new Dynamic Management Views in SQL 2005 are just stunning. There
is some much information, that it just leaves you breahless. And a lot of
that is not available in SQL 2000. master.dbo.syscacheobjects is proabbly
what comes closest in this case, but it does not have all that information.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
|
|
|
|
|