script/proc? The info returned from Statistics time is hard to process.
The goal is to run a statement(s) and capture and track the execution
time to check on the availability of SQL Server. The data can be
analyzed to determine when perf is high and low. But the main reason is
to check db availability.
Thanks,
Mike
--
Posted via http://dbforums.comwukie (member30544@.dbforums.com) writes:
> What are some sound solutions to capture the query runtime via a
> script/proc? The info returned from Statistics time is hard to process.
> The goal is to run a statement(s) and capture and track the execution
> time to check on the availability of SQL Server. The data can be
> analyzed to determine when perf is high and low. But the main reason is
> to check db availability.
I'm not sure that I understand what you are looking for. But have
you investigated whether the Profiler can be useful for the task?
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||What I am trying to do is write a web page that executes a simple update
statement which will go through the complete application stack. If
successfull then the system is up and available for use. Additionally I
would like to record the timing for each exectution (which is actually
icing on the cake).
Profile would only get me the DB portion and I want to feel our
customers experience ...
Mike
--
Posted via http://dbforums.com|||What I am trying to do is write a web page that executes a simple update
statement which will go through the complete application stack. If
successfull then the system is up and available for use. Additionally I
would like to record the timing for each exectution (which is actually
icing on the cake).
Profile would only get me the DB portion and I want to feel our
customers experience ...
Mike
--
Posted via http://dbforums.com
No comments:
Post a Comment