Measuring Execution Time of process

Question

Process p = new Process ();
p.StartInfo.FileName = @"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz" ; p.StartInfo.Arguments = "script -S server -U sa -P sys123 -d  Newone " c:\Newone.sql ";
In above code how can i messuring the process time or time for executing that query p.Start();

Vulpes · Answer

Good point, Sam.
I've also noticed that the Process class contains a StartTime property so we don't need to record it separately.
Taking these points into account, gives us the following revised code:
Process p = new Process(); p.StartInfo.FileName = @"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz"; p.StartInfo.Arguments = "script -S server -U sa -P sys123 -d  Newone " c:\Newone.sql "; p.EnableRaisingEvents = true; p.Exited += Process_Exited; p.Start();
private void Process_Exited(object sender, System.EventArgs e) {    Process p = (Process)sender;    TimeSpan elapsed  = p.ExitTime - p.StartTime;    string msg = String.Format("The process ran for {0} milliseconds
of which the total processor time was {1} milliseconds", elapsed.TotalMilliseconds, p.TotalProcessorTime.TotalMilliseconds);    MessageBox.Show(msg); }

Sam Hobbs · Answer

jayakrishnan, do you need the processor time or the elapsed time? Those are two different values, so if the previous replies don't help, please clarify what you need.

Suthish Nair · Answer

If the query got resolved, then mark the post that helped you as Answer so will be helpful for others.
Otherwise if you got the solution please share with us.

Vulpes · Answer

You could do it asynchronously, like this:
// create private field
private DateTime  start;
// ...
Process p = new Process();
p.StartInfo.FileName = @"C:\Program Files\Microsoft SQL Server\90\Tools\Publishing\sqlpubwiz";
p.StartInfo.Arguments = "script -S server -U sa -P sys123 -d  Newone " c:\Newone.sql ";
p.EnableRaisingEvents = true;
p.Exited += Process_Exited;
start = DateTime.Now;
p.Start();
private void Process_Exited(object sender, System.EventArgs e)
{
Process p = (Process)sender;
TimeSpan elapsed  = p.ExitTime - start;
MessageBox.Show("The process ran for {0} milliseconds", elapsed.TotalMilliseconds);
}

Manikavelu Velayutham · Answer

Stopwatch timer = new Stopwatch();
timer.Start();
...
...
timer.Stop(); MessageBox.Show("Elapsed: "+ timer.Elapsed);
MessageBox.Show("In milliseconds: "+ timer.ElapsedMilliseconds);
MessageBox.Show("In timer ticks: "+ timer.ElapsedTicks);
The above code is used to find out the execution time in .NET