Database Server Connectivity and Database Setup Question

[katekis]

We have an application that regularly connects to one of our database servers. Over the last few months for some reason they are consistently been losing connectivity a few times a day. at least once a day We restart the SQl services and all seems to be good again.

Below is information on the properties. I am not sure that the database was originally setup properly or if should update something to make it better.

Database General properties
Size: 4045.94
Space Available: 0.0mb
Number of Users: 6

Database File Properties
The Data file initial Size 3804, is set to Autogrow By 1MB, unrestricted growth.
The Log File initial 243, is set to autogrow by 10%, restricted File Growth 2,097,152mb.

Does this database setup seem ok?

The application is sending a batch file to our database with updates to the tables.

We have a SQL Log backup Job that runs every hour scheduled. Often when we are experiencing connection issues it occurs during our log backup times?

Are there any specific database properties I should look for may be causing our problems?

There are many other databases on the server so I am not exactly sure that the problems lies in the one database I gave property specifications for above.

 

[mutley1]

Kate,

if the database is currently 4GB and only set to grow 1MB at a time, then if a sizeable batch comes in it will hog a lot of resource as it will need to grow 1MB, realise it is full again, grow another 1MB etc.etc. Depending on the disk space available (i.e. it's not just 200MB left free on the disk the data file resides on), I'd set it to 10% growth for a start. If that doesn't help much, come back and will point in the right direction of further info required.

HTH,

M.

 

[katekis]

Should I set it to 10% Restricted or Unrestricted Growth? If restricted file growth what MB to you recommend and why?

Thanks,

 

[mutley1]

I would say unrestricted. If it is restricted then it will not grow past that point, even if there is plenty of space that could be used. You will need to get an idea of how much / often the data size grows in relation to free disk space.