Rob

My problem with the DB shrink is this : The Solarwinds DB maintenance performs a shrink on the database if there is excessive space in the DB. It will then perform a grow if there is not enough space in the DB. The DB grow fails because it takes too long for the DB grow to complete because of the size of the DB (25GB). The…

I am aware that the database is huge. I'm keeping a lot of history. Hence my problem that the DB maintenance is not very good at maintaining my DB and I would like to turn off the bit which performs the shrink. Does anyone know if this is possible?

I have had a similar issue where my graphs would have gaps in them and restarting the server would fix the problem. Unfortunatly a couple of days later exactly the same would happen again. Eventually we found the SQL server (Enterprise on seperate server) was running out of space as the DB grow function was not working…

Anybody know a way of doing this but also passing the login information?

I have had a similar issue where my graphs would have gaps in them and restarting the server would fix the problem. Unfortunatly a couple of days later exactly the same would happen again. Eventually we found the SQL server (Enterprise on seperate server) was running out of space as the DB grow function was not working…

My experience was that this was caused by a +COM instability. Upgrading to Ver7.2 fixed the problem. The instability fix is documented in the new features for 7.2 details.

I had a similar problem and my DBA's spotted the cause. Apparently SQl will allocate (to itself) all available memory, therefore leaving very little for the server to use itself. If your problem is similar you will notice that after a reboot the SQL server performs ok for a while and then starts to slow up as the SQL…