Number Of Hits

From: John Smith (js_at_no.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 17:15:05 -0500

Hey folks,

I want to run through a large C# application we built to ensure it is
properly optimized.

Is there a way I can tell in SQL server how many times it's been hit/queried
in the last 20 seconds? In other words, I want to load a form on the
application and ensure that there is a minimal number of queries called
(Stored Procedures or simple Select statements).

How would I find out how many times it was queried within a certain
timespan?

Thanks!

Relevant Pages

  • Re: Access apps with user definable fields?
    ... New fields would need to added to tables, queries, ... Of course they have their own built in report writer ... > I have an app I built for nonprofits who provide FREE ... > add control switches to control whether certain fields are displayed or ...
    (microsoft.public.access.formscoding)
  • Re: Entering data in one form while updates 2 or more tables
    ... query, which was built from two queries and one table. ... you can certainly use VBA code in the form's AfterUpdate event to open a ...
    (microsoft.public.access.forms)
  • Re: How do I add a record?
    ... eslinc wrote: ... I just built the form using ... but not all queries allow updating the data. ... are using such a query that would explain why you couldn't make changes. ...
    (microsoft.public.access.forms)
  • Creating a listing from multiple tables in Access 2007
    ... I have built a realational database in Access 2007 with 9 tables, queries and forms for the 9 different types of tools we use. ... Could someone please direct me on the best way of doing this, bearing in mind that I am still learning Access 2007 and am using a book: Access 2007 Inside Out, where I am about a quarter way through it so far. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: It works! It works!
    ... >Remember I posted some queries a while back about doing manipulations ... >on directory trees and how tricky it was to keep everything ...
    (comp.lang.pascal.delphi.misc)