Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: Identifying long running queries SQL server

    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

    ...


    James E Bothamley
    Sr DBA
    Supreme Court of Wyoming
    JBothamley@Courts.State.WY.US
    JamesBothamley@Wyoming.Com

    "Once in a while you can get shown the light
    in the strangest of places if you look at it right"

    JG 1942-1995 RIP

    January 30, 2014 at 4:50 pm

    #1684888

  • RE: Microsoft SQL Server Error Log Scanning

    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)...


    James E Bothamley
    Sr DBA
    Supreme Court of Wyoming
    JBothamley@Courts.State.WY.US
    JamesBothamley@Wyoming.Com

    "Once in a while you can get shown the light
    in the strangest of places if you look at it right"

    JG 1942-1995 RIP

    September 6, 2013 at 8:30 am

    #1648115

Viewing 2 posts - 1 through 3 (of 3 total)