Pau Lo
asked on
remaing space view
We identified a SQL server whereby user databases and logfiles are on the systems F drive. This is a tiny drive with only 30GB capacity. Worse still there is just over 1.5GB free space. The DBA says the databases are pretty stale and hardly grow at all in size. My question is there anything that can happen to the database and logfiles that could consume that 1.5GB at any given point? The system DB are on the systems C drive these are all user DB. They seem remarkably relaxed about what to me looks a big issue. Whats your view? Is this a disaster waiting to happen or if they monitor the growth trends is that sufficient? Or can other things aside from new db records consume that space at any given point?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Anything is POSSIBLE.
Without knowing your application data flows etc, I'm in no position to say. Talk to your DBA's ... or the application owners. They would be the ones to know.
I trend my data growth so I tend to know (or can lookup) how a database has behaved over the last year. I just don't see spikes like that.
But if you allow users direct access to the DB, instead of through some form of application layer, who knows ? Anything is possible. Someone runs something without a parameter and huge amounts of transactions logs could be generated. You're operating under a huge what if with that question.
Without knowing your application data flows etc, I'm in no position to say. Talk to your DBA's ... or the application owners. They would be the ones to know.
I trend my data growth so I tend to know (or can lookup) how a database has behaved over the last year. I just don't see spikes like that.
But if you allow users direct access to the DB, instead of through some form of application layer, who knows ? Anything is possible. Someone runs something without a parameter and huge amounts of transactions logs could be generated. You're operating under a huge what if with that question.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can check, can they consume disk space quickly?
If there is a lot of traffic, and logs are not being backed up regularly, then yes, that could happen.
ASKER