October 22, 2009 at 7:12 am
I am updating 46 million records in the table and it is running for 15 hours. How can I check if it is running still, if my transaction logs are not full. How can I check if updated records already. Thank you
October 22, 2009 at 7:25 am
Krasavita (10/22/2009)
I am updating 46 million records in the table and it is running for 15 hours. How can I check if it is running still, if my transaction logs are not full. How can I check if updated records already. Thank you
ok..., you say update, is this an update statement which is running, or how is the update being applied. you can monitor the spid, using activity monitor or sp_who2.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 22, 2009 at 7:35 am
Yes, this is update running from query analyzer.Do you have other suggestions how I can run qyicker?How can I check if my logs are not full?Thank you
October 22, 2009 at 7:37 am
This what it showing:
SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIOLastBatchProgramNameSPID
55 sleeping my user nameMyname 55 dbNameUPDATE 3365161079663110/21 17:36:10Microsoft SQL Server Management Studio - Query55
Is sleeping mean it is running?
October 22, 2009 at 7:42 am
Silverfox (10/22/2009)
Krasavita (10/22/2009)
I am updating 46 million records in the table and it is running for 15 hours. How can I check if it is running still, if my transaction logs are not full. How can I check if updated records already. Thank youok..., you say update, is this an update statement which is running, or how is the update being applied. you can monitor the spid, using activity monitor or sp_who2.
when you check the log file size, is the physical file size increasing.
you can use
dbcc sqlperf(logspace)
to see the percentage of the log space used.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 22, 2009 at 7:49 am
Krasavita (10/22/2009)
This what it showing:SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIOLastBatchProgramNameSPID
55 sleeping my user nameMyname 55 dbNameUPDATE 3365161079663110/21 17:36:10Microsoft SQL Server Management Studio - Query55
Is sleeping mean it is running?
sleeping can just means it is awaiting for a command, it isnt a problem. as long as the CPUTime and/or DiskIO are increasing everytime you are refreshing, you are ok.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 22, 2009 at 8:04 am
Log Size (MB)Log Space Used (%)
21595.39.264401
Thia is what I have, is this ok?
October 22, 2009 at 8:06 am
How can I check if some of my records were updated, do I need to wait until it finish?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply