First - thanks so much for replying - big help.

Cool. Thats how I designed it. The CName has been reworked...

• This reply was modified 8 months, 4 weeks ago by  bukester.
• This reply was modified 8 months, 4 weeks ago by  bukester.

Logins are present always - been running Mirrored dbs for a decade. The dbs are on the "dedicated Mirror" instance for a day or so on the weekend and I...

Ran into this problem on Friday afternoon. Very similar - WriteLog waits, then TM Request. I am using Ola's PerformanceStore and the spids associated with a slow query etc. would...

Ok, thanks. I have never hunted for a millisecond before, so I am overanalyzing what I have always dismissed or never noticed. Its a trading system and those milliseconds add...

I am just showing SP:Completed, so no. If a proc calls other procs (child procs) then the sum of the child proc duration, reads and writes should be the same...

Yes, that was poorly posed on my part. The RPC call using sp_executesql takes place - so RPC Started and RPC Completed will return metrics (Reads, Duration eg) for ALL...

One more consideration is connection pooling. SQL Logins via IIS are pooled better than WA. Therefore, resources like memory are better managed.