How to create Log and improve performance in Store procedure

Question

How to create Log and improve perfromance in Store procedure in SQL Server 2008.I have complex store procedure having too much loops which i want in log so that I can trace various problems .I cant minimize loops as it depends on user data entry as no of User entry added then this loop takes long time . I want to reduce this loop time.How should i minimize time with performance ?Thanks in advance....

Khan Abrar Ahmed · Answer

Hi please go through this links http://www.c-sharpcorner.com/UploadFile/raj1979/how-to-use-sql-server-profiler-and-tuning-advisor/ http://technet.microsoft.com/en-us/library/ms172984%28v=sql.110%29.aspx http://msdn.microsoft.com/en-us/library/ff647793.aspx http://technet.microsoft.com/en-us/library/ms190610%28v=sql.105%29.aspx http://sqlmag.com/database-performance-tuning/query-performance-tuning

Anupam Singh · Answer

if you are using select queries in this poc. try using with(nolock). ex : select top(10) * from employee with(nolock). will reduce time to retrieve records. Other things depends on how you wrote proc.