July 17, 2012 at 7:43 am
Dear All,
I run a stored procedure and it executes “infinite”. Stopped it and then I decided to update the statistics, because I’ve noticed for some tables they had never been updated.
I run a simple ssis package only to update the statistics for the database and the run is "infinite". It was advancing up to 37% and then froze.
Then I thought something is wrong with the database, and run DBCC CHECKDB and it runs “infinte” also.
The database size is 202GB
Available space is 2GB
So I don’t know what to do next?
Can anyone suggest something?
Regards,
IgorMi
Igor Micev,My blog: www.igormicev.com
July 17, 2012 at 7:44 am
July 17, 2012 at 7:57 am
calvo (7/17/2012)
Is there an open transaction on which these processes are waiting?
select @@trancount
@@trancount = 0
Igor Micev,My blog: www.igormicev.com
July 17, 2012 at 8:05 am
@@trancount won't tell you anything other than if there's an open tran from that specifc session. It's of no use in this situation
Check what the processes are waiting for (sys.dm_exec_requests, sys.dm_exec_sessions), post wait type and wait resource.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply