Tagged Questions

The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
3answers
39 views

Sql server transaction timeout

Is there any parameter to prevent long transactions? I would like to automatically rollback all transaction that takes more than 5 minutes. Is it possibile? I'm working on a Microsoft SQL server 2008 ...
1
vote
1answer
18 views

Changing ModSecurity Logging on a Per Transaction Basis

I am trying to trace all requests being made to a website on a shared hosting server. Packet capture is just going to be too cumbersome. We use Mod Security (2.8) with good effect, although due to ...
2
votes
1answer
48 views

Xeon Processors and large transactions

A little background: We have a windows service which gets data from an external server and stores them on a local DB (SQL server 2012). The external server sends more than 1500 “messages” per ...
0
votes
1answer
105 views

PostgreSQL Page-level locking

I'm fairly new to postgresql. I've checked out the documentation and I can't find anything about how to do page-level locking. I understand that I can set a table into a locking mode like this: LOCK ...
1
vote
1answer
69 views

Seeking Opinions - Is it a good idea to rely SQL backup 100% on transaction logs? [closed]

I'm in the midst of changing my company's SQL Server backup practice. We use to create full backups weekly and daily differential backups overnight. The issue is that as these full backups grow, it ...
1
vote
3answers
140 views

How frequent can we do SQL transaction log backups?

I'm installing a highly critical system. If the system fails, the users wants data up to the last minute. To achieve this, I was thinking of running Transaction Log Backups + FTP every minute. Has ...
1
vote
2answers
803 views

Transaction log full issue with SQL Server 2008 R2

I am running into 'transaction log full' issue with SQL Server 2008 R2. My database includes 80,000 tables which contains up to 5 columns of BIGINT and there is an index for each columns. The ...
0
votes
1answer
694 views

Yum Transaction Check Error on install

# yum install subversion subversion-devel neon neon-devel While trying to install some packages with yum – as shown above – I get the following error Transaction Check Error: file ...
1
vote
2answers
288 views

How much memory does one Postgresql savepoint take up?

How much memory does a single savepoint (within a transaction) take up in postgresql? I'm developing an application which might create a significant amount of savepoints (100k+) and was wondering ...
1
vote
2answers
109 views

need scalable, highly available transactional log server

My requirements: 1) must be able to continue operating after node failure 2) logs must be recoverable after node failure - no data loss 3) must be able to scale out 4) must be transactional - when a ...
2
votes
5answers
551 views

SQL Server transaction log backups,

I have a question regarding the transaction log backups in sql server 2008. I am currently taking full backups once a week (Sunday) and transaction log backups daily. I put full backup in folder1 on ...
2
votes
1answer
157 views

Snapshot transaction Isolation levels: it really works as advertised?

Have you any problems using it on high concurrency environment? It's really works as advertised by MS? I'm using SQL Server 2005 and would like to hear the experiences of those who are/was using it on ...