We have been using SharePoint 2010 for various applications since last 3 years but since last two days users are unable to delete items from the list. The delete operation just does not return back and the list keep showing 'Deleting...' text.
I tried doing the same on a list as small as two columns and 4 items and the result is the same. Now, most of the time I am unable to even add or edit an item in the list. The request just does not return back. I am, however, able to view all lists and individual items in them.
What could be the issue?
Updated (After Gaurravs and Steven response): On checking the SharePoint database server, it was found that disk has enough space but RAM utilization is 15.8 GB of total 16 GB RAM and almost all of 5.8 GB was eaten up by SQL server service. After restarting the server it went down to 1.6 GB. We, then, Added and Updated a list item successfully with no difference in memory utilization. However, when we tried to delete a list item, it got stuck.
Looking at Resource Waits in SQL Server Activity Monitor, it was determined that an INSERT request was in SUSPENDED state. After this, we tried to Add and Edit an item but all got stuck with SUSPENDED state and memory consumption started to increase to the maximum limit. Then, we killed the suspended requests and tried adding and editing item and it went well. But again item deletion got stuck.
Futher more, the content DB data file size is 54 GB and log file size is 2 GB. Total records in AllUserData table are approx. 14200000.
More Details I have recreated the site through attaching content database files on a different SharePoint server and the issue is still the same. I ran "Test-SPContentDatabase" and SQL Server's DBCC CHECKDB with REPAIR_REBUILD on content database but of no use. Running SharePoint Products Configuration Wizard did not solve the problem either. It is discovered that delete works well on a new list and if an existing list is exported and then imported in a different site on the same server.
Appreciate if anyone can provide solution to this deletion issue. Thank You