Easy questions gotta be there too 😀

Became a bit wiser today, thanks for the question.

Always nice to see this kind of question about the basics.

The question covers some interesting aspects of transactions and serversettings.

On the other hand, the answers are formulated in a way in which you can glean the right answer from the...

Fun way to pose a question, and gets me learning a new fact every time 😉

Reading the post raises the question for me why you choose for ServiceBroker.

I am much more inclined to suggest AuditTracing

http://technet.microsoft.com/en-us/library/cc280386.aspx

Serverside tracing is recommended over the SQL Profiler GUI.

In the profiler you can go to "Export" -> "trace definition". With that script, and a few minor adjustments, you can...

This article explains the virtual accounts

http://msdn.microsoft.com/en-us/library/ms143504.aspx

It recommends using MSA (Managed Service Accounts), with specific privileges.

As per paragraph "Windows Privileges and Rights", you should use the "NT Service\SQLAGENT$InstanceName" for...

With an operation already running it's not the best thing to do (makes no difference).

Also it's a Windows policy, definitely one to check out as it disables the 'zeroing out'...

Looking at the size of the files, the instant file initialization will probably also shave off some time. Ofcourse there could be considerations to not enable that option.

If...

You could also take a look at Windowstooling, like perfmon and the typeperf tooling.