Number Of Hits

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!
Try using the profiler - it can show all (well most) iteractions with
the database.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Perfect. Thx!
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:ukP5V0e8EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Try using the profiler - it can show all (well most) iteractions with
> the database.
> Nigel Rivett
> www.nigelrivett.net
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Perfect. Thx!
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:ukP5V0e8EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Try using the profiler - it can show all (well most) iteractions with
> the database.
> Nigel Rivett
> www.nigelrivett.net
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Number Of Hits

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!Try using the profiler - it can show all (well most) iteractions with
the database.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Perfect. Thx!
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:ukP5V0e8EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Try using the profiler - it can show all (well most) iteractions with
> the database.
> Nigel Rivett
> www.nigelrivett.net
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Perfect. Thx!
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:ukP5V0e8EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Try using the profiler - it can show all (well most) iteractions with
> the database.
> Nigel Rivett
> www.nigelrivett.net
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!sql

Number Of Hits

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!Try using the profiler - it can show all (well most) iteractions with
the database.
Nigel Rivett
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Perfect. Thx!
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:ukP5V0e8EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Try using the profiler - it can show all (well most) iteractions with
> the database.
> Nigel Rivett
> www.nigelrivett.net
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Perfect. Thx!
"Nigel Rivett" <sqlnr@.hotmail.com> wrote in message
news:ukP5V0e8EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Try using the profiler - it can show all (well most) iteractions with
> the database.
> Nigel Rivett
> www.nigelrivett.net
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!