• Common issues faced while configuring AlwaysOn listener on Azure VM cluster

    We have MSDN article [Tutorial: Listener Configuration for AlwaysOn Availability Groups ( http://msdn.microsoft.com/en-us/library/dn425027.aspx ) which provides detailed steps to configure AlwaysOn listener on Azure VM cluster. This article provides steps ...read more
  • What is SSAS error "An unexpected exception occurred" or 0xC1000016

    When working with SQL Server Analysis Services, it is not uncommon to see this error message "An unexpected exception occurred". This is the most misunderstood message in SSAS. If you try to search this particular error message, you can get ...read more
  • How It Works: sp_server_diagnostics – spinlock backoffs

    There are numerous articles outlining how spinlocks work so I won’t cover the details in this post.   Instead, I want to focus on the spinlockbackoffs value recorded in the sp_server_diagnostics output. Component = System <system spinlockBackoffs ...read more
  • Capture successful logins: You may see many entries(high volume) when you create Audit for SUCCESSFUL_LOGIN_GROUP action group

      When you are auditing successful logins attempts using SUCCESSFUL_LOGIN_GROUP action group through SQL Audit, you will see that there will be too many entries in the audit file. You may see this behavior for successful logins when connections are ...read more