Example #1
0
            public ActiveOperation(WhoIsActiveRow row)
            {
                SessionId            = row.session_id;
                SqlText              = row.sql_text;
                SqlCommand           = row.sql_command;
                LoginName            = row.login_name;
                WaitInfo             = row.wait_info;
                Tasks                = row.tasks;
                TransactionLogWrites = row.tran_log_writes;
                CPU = row.CPU;

                TempDBAllocations = row.tempdb_allocations;
                TempDBCurrent     = row.tempdb_current;
                BlockingSessionId = row.blocking_session_id;

                Reads         = row.reads;
                Writes        = row.writes;
                PhysicalReads = row.physical_reads;
                QueryPlan     = row.query_plan;
                UsedMemory    = row.used_memory;

                Status = row.status;
                TransactionStartTime = row.tran_start_time;
                OpenTransactionCount = row.open_tran_count;
                HostName             = row.host_name;
                DatabaseName         = row.database_name;

                ProgramName    = row.program_name;
                StartTime      = row.start_time;
                LoginTime      = row.login_time;
                CollectionTime = row.collection_time;
            }
            public ActiveOperation(WhoIsActiveRow row)
            {
                SessionId = row.session_id;
                SqlText = row.sql_text;
                SqlCommand = row.sql_command;
                LoginName = row.login_name;
                WaitInfo = row.wait_info;
                Tasks = row.tasks;
                TransactionLogWrites = row.tran_log_writes;
                CPU = row.CPU;

                TempDBAllocations = row.tempdb_allocations;
                TempDBCurrent = row.tempdb_current;
                BlockingSessionId = row.blocking_session_id;

                Reads = row.reads;
                Writes = row.writes;
                PhysicalReads = row.physical_reads;
                QueryPlan = row.query_plan;
                UsedMemory = row.used_memory;

                Status = row.status;
                TransactionStartTime = row.tran_start_time;
                OpenTransactionCount = row.open_tran_count;
                HostName = row.host_name;
                DatabaseName = row.database_name;

                ProgramName = row.program_name;
                StartTime = row.start_time;
                LoginTime = row.login_time;
                CollectionTime = row.collection_time;
            }