Capture the SELECT Statement Duration on SQL7

Hello:
I need to give a report of the server performance about
the select statement duration. Does any setup that I can
capture these information into CSV format? How can I do
that?
Does any URL can reference?
Thanks a lot!
Alan
Look at set statistics io on and set statistics time in the BOL
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:101501c49978$fc1227b0$a501280a@.phx.gbl...
> Hello:
> I need to give a report of the server performance about
> the select statement duration. Does any setup that I can
> capture these information into CSV format? How can I do
> that?
> Does any URL can reference?
> Thanks a lot!
|||For big production stuf you can do several things.
Capture information using Profiler < the info would be inthe statement
ending row.
You can capture this to a sql table, or to a file and then import it into a
sql table.
You can then export to a flat file using DTS, or bcp , or a select in query
analyzer, then save the results area to a file.
Good luck
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:101501c49978$fc1227b0$a501280a@.phx.gbl...
> Hello:
> I need to give a report of the server performance about
> the select statement duration. Does any setup that I can
> capture these information into CSV format? How can I do
> that?
> Does any URL can reference?
> Thanks a lot!