1

Topic: MS SQL - record lock

Good afternoon. At once I will tell, to work with MS SQL earlier it was not necessary, I ask not to judge strictly and  a nose in the correct direction. So a question)
There is a software which interrogates the certain equipment and data retrieveds are written down in one of tables, but periodically record stops. Thus the software continues to interrogate the equipment, obtains new given, but new records do not get to the table.
By practical consideration clarified that if from the table to delete for example 10 records at following inquiry of the equipment in the table 10 new records register and all again stops. I delete 100 old, I receive 100 new and again we stand!
Such impression at a DB that there is a certain memory size on which achievement to add new records there is no place more.
Prompt please in what direction to dig? Can what  properties of a DB it is necessary change?
Thankful in advance for councils.

2

Re: MS SQL - record lock

What at you sequel edition?

3

Re: MS SQL - record lock

The grandfather, Microsoft SQL Server 2014 - 12.0.2000.8

4

Re: MS SQL - record lock

serega.pte;
Triggers on the table?

5

Re: MS SQL - record lock

felix_ff, triggers miss.

6

Re: MS SQL - record lock

serega.pte;
To look that in a server broad gull, the place can ended, or basis without an autogain

7

Re: MS SQL - record lock

serega.pte wrote:

the Grandfather, Microsoft SQL Server 2014 - 12.0.2000.8

express, enterprise, standard?

8

Re: MS SQL - record lock

serega.pte, stop it can at the initiative of a software... For example - license restriction... You would look at what activity shows your software though SQL Server Profiler ' an ohm during time when records do not get... Well or to "hands" try to interpose how to deceive its (software) you teach.

9

Re: MS SQL - record lock

wrote:

it is passed...
express, enterprise, standard?

It is improbable that the edition type influences... smile

10

Re: MS SQL - record lock

In a software there can be any restriction. - a demoversion.

11

Re: MS SQL - record lock

TaPaK wrote:

serega.pte;
To look that in a server broad gull, the place can ended, or basis without an autogain

, interesting, in broad gulls here the such found:
[spoiler Log] CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.45 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.45 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.45 spid54 Error: 1105, Severity: 17, State: 2.
2018-02-22 17:33:05.45 spid54 Could not allocate space for object ' mbus.tblMBusTelegramsLog '.'PK_tblMBusTelegramsLog ' in database ' EncoBase ' 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.
2018-02-22 17:33:05.46 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.46 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.46 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.46 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.46 spid54 Error: 1105, Severity: 17, State: 2.
2018-02-22 17:33:05.46 spid54 Could not allocate space for object ' mbus.tblMBusTelegramsLog '.'PK_tblMBusTelegramsLog ' in database ' EncoBase ' 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.
2018-02-22 17:33:05.69 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.69 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.69 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.69 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.69 spid54 Error: 1105, Severity: 17, State: 2.
2018-02-22 17:33:05.69 spid54 Could not allocate space for object ' mbus.tblMBusTelegramsLog '.'PK_tblMBusTelegramsLog ' in database ' EncoBase ' 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.
2018-02-22 17:33:05.69 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.69 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.69 spid54 Error: 1827, Severity: 16, State: 1.
2018-02-22 17:33:05.69 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.
2018-02-22 17:33:05.69 spid54 Error: 1105, Severity: 17, State: 2.
2018-02-22 17:33:05.69 spid54 Could not allocate space for object ' mbus.tblMBusTelegramsLog '.'PK_tblMBusTelegramsLog ' in database ' EncoBase ' 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. [/spoiler]

wrote:

it is passed...
express, enterprise, standard?

Express

buser wrote:

serega.pte stops it can at the initiative of a software... For example - license restriction... You would look at what activity shows your software though SQL Server Profiler ' an ohm during time when records do not get... Well or to "hands" try to interpose how to deceive its (software) you teach.

I will try.

12

Re: MS SQL - record lock

Judging by broad gulls it is exceeded  licenses which is restricted 10. At present the basis occupies From us 14.
I will clean.

13

Re: MS SQL - record lock

serega.pte;
Well so 10 it also is restriction ...