🙁 It now adds up to more than what SSMS is displaying, its over by about 30MB now :s

I have however tried this calculation on other dbs and it...

Wow that was quick, I was just editing the...

Hi again

How do I check whats allotted, this isn't the max server memory setting is it? Here are the settings from sp_configure anyway:

name ...

Ok thanks for this, as you requested the complete set of stats are here.

Database NameLog Size (MB)Log Space Used (%)Status

xxxx ...

Ok, I wil make sure I review the recommendations that come out of DTA carefully.

SQLRunner what kind of stats you require? This is a 4 disk RAID 5 configuration...

Hi there thankyou to all for your replies.

SQLRunner - the SQL Buffer cache is %99 and above for the same period.

Marcin Gol - I will set up a new counter...

OK thanks to you both.

HI there thanks for the reply. Yes I agree with you and I am undertaking an database growth monitoring exercise currently to determine what size I should set my...

Hi thanks for the replies

Running that script I have 36 autogrows for the last day which seems a little excessive. I have also going to monitor the database size...

Ok a little more - I can see the package jobs are all configured to run packages stored either in the package store or in the file system, but when...

Hi again - can anyone answer my above post?

I have been looking at the server where the current job is running from and connected to Integration Services but...