Viewing 10 posts - 16 through 25 (of 25 total)
working with SAN guys now to dig deeper.
August 24, 2012 at 9:36 am
WaitTypeWait_SResource_SSignal_SWaitCountPercentageAvgWait_SAvgRes_SAvgSig_S
PAGEIOLATCH_SH93277.2493264.1413.10399999516.970.02330.02330.0000
MSQL_XP68382.9568382.950.0031779712.440.21520.21520.0000
PREEMPTIVE_OS_GETPROCADDRESS68380.7768380.770.0031779712.440.21520.21520.0000
BACKUPIO64827.2064814.3512.85115627111.800.05610.05610.0000
ASYNC_IO_COMPLETION62775.3862775.370.0118811.42333.9116333.91160.0000
BACKUPBUFFER61542.3761414.42127.95236889511.200.02600.02590.0001
PAGEIOLATCH_EX43050.0943045.394.7018565767.830.02320.02320.0000
LCK_M_S36037.1636036.830.3328716.5612.552112.55200.0001
LCK_M_U17102.2717102.270.01553.11310.9504310.95030.0001
WRITELOG12215.1212188.0027.136467402.220.01890.01880.0000
August 23, 2012 at 12:57 pm
Robert Davis (8/23/2012)
August 23, 2012 at 12:45 pm
Edward Dortland (8/23/2012)
what does this say:SELECTdb.name,
er.percent_complete,
er.total_elapsed_time/60000 AS ElapsedMinutes,
er.estimated_completion_time/60000 AS remaining_minutes
FROM
sys.sysdatabases db
INNER JOIN sys.dm_exec_requests er
ON db.DBID=er.database_id
AND er.command LIKE '%BACKUP%'
and does the output change over time?
Edward
I get nothing.. since it...
August 23, 2012 at 12:42 pm
anyone? This is baffling to me!
August 23, 2012 at 11:36 am
max during that run:
for 10 min Physical IO was 440 page writes per second.. otherwise is was 40 max over the other the 77 min
average disk ms/write was 120 for...
August 23, 2012 at 10:51 am
I was the only process running at that time. and CPU was < 5 % utilized
August 23, 2012 at 10:32 am
Not to say that this was not a good article, which it was, it seems we are not covering the killer scalar UDF issue. a scalar function is reasonably...
August 1, 2012 at 7:05 am
somehow I think its on my end in my cursor. Not sure why. If I run the proc manually on a lot of files it is very quick....
May 31, 2012 at 7:24 am
all you have to do is change the version check from
IF @OSVersion = '5.2'
to IF @OSVersion >= '5.2'
umm yeah thats easy.
also I know this is an old thread but...
May 30, 2012 at 6:54 am
Viewing 10 posts - 16 through 25 (of 25 total)