Thanks for your suggestions Guru!!

I have already put forward my recommendations to get a sql professional to my senior management and waiting for the reply.

Thanks Jeff!!

I will check that and come back to u with the updates

Thanks for your reply Alex!!

I thought too. But in our organization we have two diff. networks, one for production and another for non-production.

Mysql is being used for an...

Thanks for your reply Jeff.

I have checked the database properties, both Auto shrink and auto close are unchecked.

Daily differential and bi-monthly full-backup is the backup plan that we...

Thanks for the reply steve.

our transaction logs are running in the same disk where our data files are residing as we don't have separate partition for that.

we have analysed...

I do agree 4 MB is too less for a log file. But its been working fine without issues for years. Our DBAs changed the size of one of the...

Database size is 133 GB

Data file size is 140GB and log file size is 4MB (2 log files).

our organization is a BPO. Hope now you can imagine...