Reputation
404
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 21
Newest
 Yearling
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Apr
3
awarded  Yearling
Apr
3
awarded  Necromancer
Feb
18
awarded  Popular Question
Jan
12
awarded  Popular Question
Oct
20
awarded  Notable Question
Aug
14
awarded  Popular Question
Jul
7
accepted Mirror failure after windows updates - possible cause?
Jul
7
answered Mirror failure after windows updates - possible cause?
Jul
2
awarded  Curious
Jun
17
comment Mirror failure after windows updates - possible cause?
Disk usage is a few bytes per second, certainly < 1MB/S
Jun
17
comment Mirror failure after windows updates - possible cause?
@Kin Already tried that im afraid, They just confirm that sqlservr.exe is using 30% cpu & when i look into the threads of that process i can see 1 thread within sqlservr.exe is using 28% of the CPU whilst at the same time there are no user transactions running on the server, I'm starting to think this is going to need a paid support call to M$ - sigh
Jun
17
comment Mirror failure after windows updates - possible cause?
It drops to 0% - also, it takes nearly 5 minutes to stop the service (used to stop pretty much instantly).
Jun
17
comment Mirror failure after windows updates - possible cause?
@MaxVernon No, we usually install updates on mirrors only initially, only once things have been working OK for a week or so will we install the updates on the primary (done this for years with no problems). the strange CPU usage remains constant at 30% even if we remove mirroring completely (SET PARTNER OFF) - even more confusing!
Jun
17
comment Mirror failure after windows updates - possible cause?
@Kin Please see edit 4 - just confirms its something internal to SQL really :( session_id that you can see there has command "BRKR TASK" - again, could be anything.
Jun
17
revised Mirror failure after windows updates - possible cause?
Added sp_WhoIsActive info
Jun
17
revised Mirror failure after windows updates - possible cause?
added 272 characters in body
Jun
17
revised Mirror failure after windows updates - possible cause?
added 463 characters in body
Jun
17
asked Mirror failure after windows updates - possible cause?
May
19
awarded  Popular Question
Mar
7
asked SQL Script to Drop old AD logins, Inactive SQL Logins and all related Users