Posts

Showing posts from January, 2017

What is 'User LookUp' and how it affects performance.

‘User Lookup’ means query is looking for more data than it is present in the NON CLUSTERED index. And this index(NON CLUSTERED) uses clustered index as look ups.Now whether it is good or bad we cannot come up with sold answers as we usually don’t know the other users systems. To avoid we can add the columns to NON CLUSTERED index which is being used. Bu the good part is we can reduce the ‘User Lookup’, bad part is NON CLUSTERED index will be heavy

Error codes of SQL Backups

Whenever a Full,Differential and Transaction log backups which are handled through SQL Server Agent those logs also stored at eventviewer of Windows. You can check the information with the below EventID's The below Event id's trigger when backup jobs got successes. 18270--Differential Backup 18265--Log backup 18264--Full Backup If job fails the below even id's will get trigger. 995 means third party tool backups have been used. 18210-operating system 995 third party backups or disk space. 18204- Access denied