hello all,
i have run into this problems a few times and don't really have a quick solution.
management wants to know how many times a procedure will execute in a second. i only have one procedure in mind and all it does is do a few different select and then returns a record set. so i am looking for a tool which will report how many times my "return customer profile" procedure can run. I have a tool which will execute a single procedure on multiple threads, but it has no reporting. If I have something to execute the procedure how can I report back on it's performance?
In perfmon there is a "transaction per second" however this does not count selects. so it is always 0.
Is there any native sql 2000 2005 tool to do this?
Is there any inexpensive 3 party tool which people use?
thanks in advance.
In SQL 2005 if you run the SP then one of the standard reports in management studio should tell you how many times it has run. You know how long the test was and thus how many times the SP can run /s.
You can also look at the SQL Batches/sec in perfmon, this should give you the figure you are after as long as that is the only thing you will be doing on the server.
No comments:
Post a Comment