SELECT TOP 100 qs.total_elapsed_time / qs.execution_count / 1000000.0 AS average_seconds

, qs.total_elapsed_time / 1000000.0 AS total_seconds

, qs.execution_count

...

Good article. Updating the SQLServerName column could just as easily be updated in real-time through a default constraint:

CREATE TABLE [dbo].[ErrLogData](

[LogId] [int] IDENTITY(1,1) NOT NULL,

[LogDate] [datetime] NULL,

[ProcessInfo] [nvarchar](50)...