Viewing 11 posts - 1 through 11 (of 11 total)
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...
March 9, 2012 at 3:20 pm
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...
March 7, 2012 at 12:42 pm
dbcc sqlperf (logspace)
Database Name Log Size (MB) Log Space Used (%) Status
master 19.99219 2.027159 0
tempdb 15359.99 0.07528944 0
model 19.99219 12.75889 0
msdb 49.99219 5.037897 0
330506 5075.117 14.1479 0
390530 8806.18 2.485581 0
Distrib 542.2422 2.072197 0
340510 18755.68 5.619746 0
350514 2587.742 35.16321 0
360518 5075.117 25.75978 0
390528 19999.99 0.2016114 0
390529 16268.3 4.830208 0
390531 1916.055 37.13316 0
You guys think it hardware almost everythings been changed by other techs including lots of drives
I'll start replacing erverything again Storage (HP...
March 7, 2012 at 10:15 am
Log backups run every 30 minutes
Full backups daily
March 5, 2012 at 9:58 am
No we are use the standard SQL 2008 Log backups
transation logs are large 1 is 50GB the rested are about 20GB
March 5, 2012 at 9:44 am
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...
March 5, 2012 at 9:23 am
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...
March 5, 2012 at 9:01 am
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...
March 3, 2012 at 5:47 pm
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...
March 3, 2012 at 5:07 pm
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...
March 3, 2012 at 1:20 pm
Drives are SAS attached
Server HP SE326M1 attached storage HP MSA50
March 2, 2012 at 1:39 pm
Viewing 11 posts - 1 through 11 (of 11 total)