364 reputation
219
bio website heavencore.co.uk
location England
age 29
visits member for 2 years, 7 months
seen 2 days ago

Software Engineer & Database Administrator.

Cohens Chemist Group (UK)

HeavenCore - Personal Site

Cohens Chemist - Work Site


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
Sep
26
awarded  Popular Question
May
28
accepted Working Linked Server Query fails in sp_send_dbmail
May
28
answered Working Linked Server Query fails in sp_send_dbmail
May
20
awarded  Caucus
May
20
awarded  Constituent