As far as I concern, 70-228 is horrible. High passing score and just 40s questions. It is included almost every administering task that you can perform using SQL Server, at...

I see. So the only way is to add the domain user account to domain admin group and add domain admin group to local administrators group on my database machine.

I...

Thanks Bryan. I add the domain user account to domain admins group, and it works very well.

But the policy in my company doesn't allowed this condition. Can I make that...

I just want to share mine. Try to create a profile to find a worst performing queries. Capture event SQL:BatchComplete and RPC:Complete and set the duration to greater than time...