October 31, 2005 at 12:20 am
Hi guys,
I've tried to delete some records. It took x-amount of times, yet not complete.
When I looked into current activity (Lock/process ID).
It showed that other processes blocked that process.
So, i decided to cancel query.
After that I stopped and start SQL SERVER.
But at this time, It cannot startup database. It was hang.
When I check in task manager @ proceess tab, one process sqlservr.exe Memory usage is increasing untill out of memory usage.
can anyone help?
TIA,
Lux
October 31, 2005 at 8:33 am
If it was a long running query it may have an extensive rollback period.
Are there any entries in the OS event-viewer?
Can you connect to the database using queryanalyzer? If so you can review the current activity with
sp_who2 and sp_lock.
It is perfectly normal that SQL Server tries to consume all memory minus some for the OS (depending on min max memory configuration of sql server)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply