R
R
Romario212018-12-28 13:07:51
SQL Server
Romario21, 2018-12-28 13:07:51

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'

A message about timeout is thrown, both from C# code and in MS Studio

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2018-12-28
@Romario21

Rebuilding table indexes Leadcan help.
If the table Leadis in a group of files PRIMARY, try defragmenting it.
If the table Leadis in a different file group, make it expandable.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question