Wednesday, May 8, 2013

SQL Server Performance issue

When our main dayend procedure executes it stores start time and end time of procedure.For exapmle if main dayend procedure calls first procedure it will maintain a log in table dayend_log.In this table it will record start time of that procedure and end time of that procedure.In this way we are able to find out whcih procedure has taken maximum time.


No comments:

Post a Comment