Wait Stats over Time

Looking at Wait Stats over time while a specific piece of work is taking place can be a very helpful method for troubleshooting performance issues. SQL Server exposes wait stats so you can see what…

Identify S-1-9-3 logins in sys.dm_exec_sessions

When looking at sys.dm_exec_sessions to see who is logged into a SQL Server instance, you may notice the login_name column contains a SID such as S-1-9-3-1474169822-1205489898-2971455952-561433448. This can happen as a result of using EXECUTE…