Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.
-
Jay Schmitendorf #1
Re: Timing a sql statement - with profiler
SQL Profiler has a duration column in the output.
add an event TSQL:BatchStarting to the trace
If things are getting goofy, inconsistent, I will create a simple message
table
and write insert 'starting a' , getdate() into myMsgTable
do the statement
and insert 'a ended' , getdate() into myMsgTable
then use
DATEDIFF ( datepart , startdate , enddate )
to get an indication of what the variance is
"Chris Calhoun" <ccalhoun@medbill.com> wrote in message
news:%235H7Az6RDHA.2188@TK2MSFTNGP10.phx.gbl...> Does anyone know how to time a sql statement.
>
> Thanks in Advance.
>
>
Jay Schmitendorf Guest
-
php+mysql statement timing out
Ok I'm trying to run a php script written by someone else, not me, and it's getting stuck in a particular step. Actually it isn't getting stuck per... -
using profiler RGB in photoshop 7
i have some colour adjustment software for printers called profiler RGB which is a photoshop plug in, but i am not sure if it works with photoshop 7.... -
Webpage Profiler
Well, you could take the "high road" .... http://www.zeus.com/library/technical/zlb_perf/A_sim_connections.html Or you could take the "low (and... -
Timing a sql statement
If you are talking about recording the time taken to execute a sql statement, you could achieve that by having a couple of datetime variables store... -
Profiler Question (Profiler Message)
If you click the box that says 'server processes trace' (or something like that...) I don't think you'll get the message. I'm not sure about that......
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
