Andrew J. Kelly

SQL Server Consultant, Senior Technology Subject Matter Expert with Octo.

[Andrew J. Kelly @GunneyK]

@DesertDBA Welcome to the area.

[Andrew J. Kelly @GunneyK]

@DesertDBA So sorry to hear that Jeff.

[Andrew J. Kelly @GunneyK]

@kekline @jdanton @NedOtter If you need short down time why not do log shipping or Full / Diff restores. Then down time should be minutes.

[Andrew J. Kelly @GunneyK]

@GlennAlanBerry That is what happens when you get up too early on a holiday :). I was thinking QAT cards not ARC. Once we upgrade to SQL 2022 I want to put them in all the larger servers.

[Andrew J. Kelly @GunneyK]

@Mike_WalshNH Some of us know what we want. Some don't

[Andrew J. Kelly @GunneyK]

@GlennAlanBerry I definitely don't miss those days. Sounds like a good time for one of those home brews

[Andrew J. Kelly @GunneyK]

@GFritchey Its a little bit of MA for your holiday adventures

[Andrew J. Kelly @GunneyK]

@nicharsh Or just don't lay on the couch so much :)

[Andrew J. Kelly @GunneyK]

@GlennAlanBerry That's a lot of fans Glenn. And like I said a lot of air. Enjoy that blowing in the wind feeling :)

[Andrew J. Kelly @GunneyK]

@DesertIsleSQL I wish I could make it but have something else at that time. Good luck. It will be good to get back in person soon.

[Andrew J. Kelly @GunneyK]

@jdanton Never mind. I found another CSV object group that had Sec/Write and it confirmed my suspicions that the CSV Latency is indeed in Seconds and is indeed very bad :). Thanks Joey. #sqlhelp

[Andrew J. Kelly @GunneyK]

Can anyone point me to documentation that states clearly if the IO Write Latency for a CSV File System perfmon object (Win 2019) is in ms or micoseconds. I just can't find any docs that actually state the metric interval. #sqlhelp

[Andrew J. Kelly @GunneyK]

@jdanton For some reason the Physical disk perfmon counters are not showing write data includign disk sec/write (reads are just fine) and these are CSV's anyway. But the CSV write counters are either really good or really bad depending on if the latency is in Secs or ms :). #sqlhelp

[Andrew J. Kelly @GunneyK]

Sorry, I meant Seconds or ms,

[Andrew J. Kelly @GunneyK]

@erinstellato Change is inevitable. Friendships can endure. I am sure you will excel at whatever you do. Good luck

[Andrew J. Kelly @GunneyK]

@loriedwards Congrats. Enjoy

[Andrew J. Kelly @GunneyK]

@GlennAlanBerry The only reason I can think of is if you knew for sure all of your calls were already done correctly to take advantage of plan reuse. But that would have to be one controlled environment.