working with SAN guys now to dig deeper.

WaitType Wait_S Resource_S Signal_S WaitCount Percentage AvgWait_S AvgRes_S AvgSig_S

PAGEIOLATCH_SH 93277.24 93264.14 13.10 3999995 16.97 0.0233 0.0233 0.0000

MSQL_XP 68382.95 68382.95 0.00 317797 12.44 0.2152 0.2152 0.0000

PREEMPTIVE_OS_GETPROCADDRESS 68380.77 68380.77 0.00 317797 12.44 0.2152 0.2152 0.0000

BACKUPIO 64827.20 64814.35 12.85 1156271 11.80 0.0561 0.0561 0.0000

ASYNC_IO_COMPLETION 62775.38 62775.37 0.01 188 11.42 333.9116 333.9116 0.0000

BACKUPBUFFER 61542.37 61414.42 127.95 2368895 11.20 0.0260 0.0259 0.0001

PAGEIOLATCH_EX 43050.09 43045.39 4.70 1856576 7.83 0.0232 0.0232 0.0000

LCK_M_S 36037.16 36036.83 0.33 2871 6.56 12.5521 12.5520 0.0001

LCK_M_U 17102.27 17102.27 0.01 55 3.11 310.9504 310.9503 0.0001

WRITELOG 12215.12 12188.00 27.13 646740 2.22 0.0189 0.0188 0.0000

Robert Davis (8/23/2012)

---

Is the SAN shared with other servers? I've experienced issues like this running backups to a shared SAN because everyone else was backing up their databases at the...

I get nothing.. since it...

anyone? This is baffling to me!

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...

I was the only process running at that time. and CPU was < 5 % utilized

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...

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....

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...