December, 2014

Featured

| |

|

No blog posts have yet been created.

| |

|

How It Works: sp_server_diagnostics – spinlock backoffs

Posted 18 days ago

by SQL Server Support Content
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
What is SSAS error "An unexpected exception occurred" or 0xC1000016

Posted 14 days ago

by SQL Server Support Content
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
Capture successful logins: You may see many entries(high volume) when you create Audit for SUCCESSFUL_LOGIN_GROUP action group

Posted 23 days ago

by SQL Server Support Content
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
Common issues faced while configuring AlwaysOn listener on Azure VM cluster

Posted 8 days ago

by SQL Server Support Content
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