suresh Shewale

suresh Shewale

  • NA
  • 79
  • 14.3k

How to create Log and improve performance in Store procedure

Jul 24 2014 2:57 AM
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....

Answers (2)