The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
27 views

Why is Log File Auto Grow sometimes performed by my application user and sometimes by sa?

Many database tasks (including Data File Auto Grow, Log File Auto Shrink, and Data File Auto Shrink) are completed only by the sa user, but Log File Auto Grow seems to be associated with both sa and ...
3
votes
2answers
70 views

SQL 2012 Autogrow and file extension problem

I had my data and log files set to auto grow by 10%. This has caused the transaction logfile to grow to an astronomical 600 GB in size and led to the error Autogrow of file PFMultilinguaklPOO_log in ...
3
votes
1answer
106 views

SQL Server 2008 R2 DB grows overnight and slow

I am running a SQL Server 2008 R2 SP2 DB. I have a DB that was running around 19 GB in size and three days ago grew to 34 for no good reason. We typically have about 100 MB growth in the DB every ...
1
vote
0answers
214 views

OrientDB distributed architecture

Technically this question could relate to any database that performs in a similar distribute manner but given that I am specifically working with OrientDB I thought the question should be target as ...
3
votes
2answers
1k views

Performance hickups after Postgres 9.4 upgrade

After upgrading our database from 9.3.5 to 9.4.1 last night, the server suffers from high CPU spikes. The upgrade was done with pg_dump. So the database was converted to SQL and then imported into ...
0
votes
2answers
172 views

What causes disk space growth from Informatica load onto SQL Server?

We've been dealing with huge disk growth on SQL Server from Informatica. After the load, the database grows to 2.4TB. After the database shrink, it goes to 1.05TB. What could likely cause this to ...
1
vote
1answer
430 views

Tempdb growing, however it has a lot of free space

On a sql server dedicated to a Dynamics CRM database, I've been seeing some odd behavior. While monitoring growth using the following query as basis, I've noticed tempdb has grown quite frequently ...
3
votes
2answers
2k views

MS SQL Server autogrow configuration with heavy loaded database

I have a database its size around 200G and it is heavy loaded with many inserts happens every day (it is grow around 3 to 4 GB every day), but the Auto-Grow setting is set to 1 MB. I think this is a ...
1
vote
2answers
4k views

SQL Server 2008 R2 – Track Database Growth (Production Database)

My requirement is to get the database size information collected daily, I did not find any option to get database growth over a period of time. Someone please advise what the correct method for this ...
1
vote
0answers
106 views

MDF/TempDB Growth, SQL Server 2005 Enterprise

Here's my scenario: SQL Server 2005 Enterprise Records from Database A being added to Database B Size of Database A MDF file: 3.15 GB I have separate drives for Data, Logs, and System. I ran a ...
-6
votes
1answer
446 views

Postgresql create database with size & resize?

My question regards PostgreSQL database size. How can I create new database with fixed size? (e.g. 5 GB) Once I have created fixed sized PostgreSQL database, how can I resize it ?
2
votes
5answers
6k views

Autogrowth - Percentage Use?

Is it best not to use Percentage file growth for autogrowth settings? The below recommends using percent value growth for databases under 500GB but is this recommended? ...
2
votes
1answer
200 views

Transaction log autogrowth duration

I am using event notifications to capture data and log file autogrowth events for all databases on my servers. I'm using the data to for analysis of database storage configuration. In looking at the ...
2
votes
1answer
1k views

Msg 5145: Autogrow of database log file took 1010871 milliseconds

In the past, I had an update query that ran for 7 days. I couldn't find a solution, so I created a new database with indexes. The update query has now been running for 26 hours. I am seeing messages ...