Answer the question
In order to leave comments, you need to log in
MS SQL timeout on UPDATE?
Comrades help:
Yesterday a message arrived:
"Could not allocate space for object 'dbo.SysProcessElementLog'.'PKZS0dNOq9t7kBhMEHFPHVq74Vuc0' in database 'CRM' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup , adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. "
Made by:
USE master;
GO
ALTER DATABASE CRM
MODIFY FILE
(NAME=TSOnline_Data,
MAXSIZE=15000MB);
GO
Everything seems to be working, except for queries like UPDATE and only to one table, here is an example of a query:
UPDATE Lead SET OpportunityId='166c3d02-b55b-445c-930d-aa8642377955' WHERE Id='1843c919-4be6-49dc-a2ca-000095f5170e'
Answer the question
In order to leave comments, you need to log in
Rebuilding table indexes Lead
can help.
If the table Lead
is in a group of files PRIMARY
, try defragmenting it.
If the table Lead
is in a different file group, make it expandable.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question