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

Rick

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.

Feb 21 '06 #1

Subscribe Post Reply

1183

Erland Sommarskog

Rick (ri***********@hotpop.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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Feb 21 '06 #2

Similar topics

303

BIG successes of Lisp (was ...)

by: mike420 | last post by:

In the context of LATEX, some Pythonista asked what the big successes of Lisp were. I think there were at least three *big* successes. a. orbitz.com web site uses Lisp for algorithms, etc. b....

Python

Function used in where clause - executed too many times

by: Christian | last post by:

HI, I have a function that is used to constrain a query: Select COl1, Col2 From MyTable WHERE col1 = ... AND col2 = ... And MyFunction(col1) = ... My problem is that MyFunction is executed...

Oracle Database

How do I know how many times a particular statement was executed UDB V8 on Aix 5

by: dba2adm | last post by:

The SNAPSHOT_STATEMENT table function gives the CPU used rows read etc information. How do I know the total number of time the particular statement was executed (as in snapshot_dyn_sql's...

DB2 Database

?At a loss? ExecuteNonQuery executing my Insert Statement 3 times in debug mode

by: Mike | last post by:

I know this sounds strange but I am at a loss. I am calling a simple funtion that opens a connection to a SQL Server 2000 database and executes an Insert Statement. private void...

C# / C Sharp

Why is my Time algorithm so slow - Can anyone tell me why?

by: Roy Gourgi | last post by:

Hi, I am new to C#. I have the same time scheduling program written in C++ and it is 5 times faster than my version in C#. Why is it so slow as I thought that C# was only a little slower than...

C# / C Sharp

SearchForm triggers postback 2 times?

by: Torben Philippsen | last post by:

Hi, I have a very simple searchform (an asp:textbox and a asp:button) I have enabled autopostback for the textbox to be able to execute the search method when the user hits the enter key. ...

ASP.NET

Too Many Function Pointers?

by: Bryan Parkoff | last post by:

C/C++ Compiler encourages to limit 1,000 functions under function pointer, but I am allowed to overlimit 4,096 functions. I am just for fun to test how it works. The problem is that source code...

C / C++

how many times the printf will be executed ?

by: sumedh..... | last post by:

main() { int i; fork(); fork(); fork(); printf("----"); } how many times the printf will be executed .

C / C++

binding source poisiton event executed too many times

by: GS | last post by:

the windows form application works but the eventhandler for binding source postionChanged got executed too many times: 12 times from saveitemclicked for the data navigator many time from additem ...

C# / C Sharp

AJAX onreadystatechange function called too many times

by: bgold12 | last post by:

I have a page that calls a javascript function every second using setInterval(): ... <body onload="setInterval('UpdateMessages(1);', 1000 );"> ... In UpdateMessages(), I create an AJAX...

Javascript

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA