Troubleshooting PREEMPTIVE_OS_LOOKUPACCOUNTSID wait type

17 March,2014 by Jack Vamvas

Step 1 : In the SQL Server context ,  Preemptive  means priority. In other words, a higher priority task will interrupt (preempt) a lower priority SQL Server task and takeover the Quantum to allow running on CPU. When the higher priority Windows task completes , the lower priority SQL Server task continues executing the task  on the CPU.

Step 2 : A good piece of advice on this blog   is to use the suffix as a clue for the PREEMPTIVE wait types . The MSDN docs  defines theThe LookupAccountSid function as  accepting a security identifier (SID) as input. It retrieves the name of the account for this SID and the name of the first domain on which this SID is found

Combining Step 1 and Step 2 leads us to consider what sort of activity could preempt a SQL Server task and how do we go about troubleshooting this wait type.

Based on this information areas of investigation include:

1) Have you checked that the DNS/AD settings are correct.

2) Is the SQL Server use current and relevant DNS server reference?

3) The function suser _sname function returns the login name associated with a SID. The SID  is checked against the Active Directory. Running these two queries – highlights any Active Directory responsiveness issues. It is possible the SUSER_SNAME function may respond slowly.If so, start an investigation

SELECT sid FROM sys.database_principals  
SELECT SUSER_SNAME(sid) FROM sys.database_principals 


Read More

How to create a SQL Server Security Audit - SQL Server DBA

Powershell sql server security audit - SQL Server DBA

SQL Server - Database Server Security Audit Process - SQL Server ...


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Troubleshooting PREEMPTIVE_OS_LOOKUPACCOUNTSID wait type


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer