Service accounts should be changed via config manager not services.msc.

Open up config manager switch the account back to the original account, then switch it back to domain account. This...

0x5 is an access denied error.

When you changed the service account did you use services.msc or SQL Server Config Manager?

Also if backing up to a network share, does the accounts...

Use the IFCode IMG and past a URL to an image inbetween the [ I M G ] and [ / I M G ] tags (remove spaces from the...

Think that still reads the default trace

Announcement

Unless you have some form of monitoring to log when it happened, you could have a go at looking in the default trace, but note the default trace only keeps...

Taken from the following url https://gallery.technet.microsoft.com/scriptcenter/List-datasets-with-command-ddffefde

And changed to fit your sample script and namespaces.

;WITH

XMLNAMESPACES

(DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition'

...

77% of your total wait time is on WRITELOG, yes that maybe high for your workload, it might not be, depends on the workload.

I have a heavy write syslog server...

It might be high, it might not be high, you cant just go off a one time select of the value, you need to monitor over time.

Adding another file wont...

Depends on your disks, might be normal, might not be.

How are you determining that...

Maybe this will help

http://blog.sqlauthority.com/2011/02/17/sql-server-writelog-wait-type-day-17-of-28/

Sorry I can't understand the question, what is it your after?

I never rebuild heaps, in fact we don't even allow them to be created.

Every table change has to be reviewed, in the off chance one slips past us there is...

No

Index ID 0 means the tables a heap, rebuilding a heap can be done, but all the nonclustered indexes also get rebuild to change the RID pointer.

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2930-fixing-heap-fragmentation/