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, March 19, 2014 6:30 AM
Points: 250, Visits: 743
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: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
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, March 19, 2014 6:30 AM
Points: 250, Visits: 743
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