I am going to try and truncate the transaction logs and resize them

can someone suggest a size to start with for these DB's

I was think 5 or 10MB

need to...

I just finished replacing Controller HP p800 flashed to 7.50 with new cache

also MSA 50 IO mod has been changed

during non back up times

IO is between 50 and 200MB...

dbcc sqlperf (logspace)

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

master19.992192.0271590

tempdb15359.990.075289440

model19.9921912.758890

msdb49.992195.0378970

3305065075.11714.14790

3905308806.182.4855810

Distrib542.24222.0721970

34051018755.685.6197460

3505142587.74235.163210

3605185075.11725.759780

39052819999.990.20161140

39052916268.34.8302080

3905311916.05537.133160

You guys think it hardware almost everythings been changed by other techs including lots of drives

I'll start replacing erverything again Storage (HP...

Log backups run every 30 minutes

Full backups daily

No we are use the standard SQL 2008 Log backups

transation logs are large 1 is 50GB the rested are about 20GB

We have hundreds of these servers they all manage a slice of a very large DB only difference I noticed is this server DB's are 10X larger then the DB's...

I tested a coping 100GB backup folder after log backup finished

I copied the back up folder (100 GB) to log disk response time about 10MS

IO 150 MB a second

then...

1 is almost 50GB

the rest are just over 20GB

I just updated the post I am just a break fix tech.

This admin thinks I am an expert and know how to...

sorry those first 3 digits are DB numbers (DB name)

read article

rows are between 113 and 153 Rows

thats not to many right?

I am just a hardware guy ( Break Fix Tech)

I...

Rows returned from DBCC LOGINFO

DB528: 116 rows

DB529: 116 rows

DB530: 116 rows

DB531: 113 rows

db506: 116 rows

DB510: 116 rows

DB514: 153 rows

DB518: 153 rows

let me know if you want me to post the...

Drives are SAS attached

Server HP SE326M1 attached storage HP MSA50