Last executed query total duration

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Last executed query total duration

Last executed query total duration

Rate Topic

Display Mode

Topic Options

Author

Message

ravisamigo

Posted Monday, September 20, 2010 3:21 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Dear All,

I have created index on table in user database through SSMS wizard 2days back,on that time it was executing and it was finished in next day.
Now my question is, I want to know the total duration i.e, how much time that query was taken to be finished?

From this, I want to estimate the time and have to apply the same on production environment.

Thanks and Regards,
Ravichandra.

Post #989188

Jack Corbett

Posted Monday, September 20, 2010 5:09 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Are you saying that you created an index in SQL Server and it took a full day to finish?

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #989842

ravisamigo

Posted Monday, September 20, 2010 11:51 PM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 22, 2013 11:11 PM
Points: 250, Visits: 706

Thanks Jack Corbett.

Yes, Now, I want to know how I can find the duration of that query ? i.e start time and end time.

Is there any script or query or Stored procedure to find this.

Regards,
Ravichandra.

Post #989958

« Prev Topic | Next Topic »

Permissions