Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Last executed query total duration Expand / Collapse
Author
Message
Posted Monday, September 20, 2010 3:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 7:00 PM
Points: 251, Visits: 760
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
Posted Monday, September 20, 2010 5:09 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 10:57 AM
Points: 10,387, Visits: 13,454
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
Posted Monday, September 20, 2010 11:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 7:00 PM
Points: 251, Visits: 760
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 »

Add to briefcase

Permissions Expand / Collapse