mattiaswolff

SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time / 1000/60 AS Total_Elapsed_Time_Min
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
order by 6 desc 

mattiaswolff

input {
  udp {
    type => "backend"
    port => 5000
    codec => multiline {
   	pattern => "^\w+\s+\w+\s+[0-9]{4}-[0-9]{2}-[0-9]{2}\s[0-9]{2}:[0-9]{2}:[0-9]{2}.*$"
   	negate => "true"
      	what => "previous"
    }
  }

mattiaswolff

input {
 file {
   	type => "backend"
    path => "C:/Users/mattiasw/Desktop/logs/backend/*.txt"
    start_position => "beginning" 
	codec => multiline {
      pattern => "^\w+\s+[0-9]{4}-[0-9]{2}-[0-9]{2}\s[0-9]{2}:[0-9]{2}:[0-9]{2}.*$"
	  negate => "true"
      what => "previous"
    }

mattiaswolff

SELECT
session_id,status,
command,sql_handle,database_id
,(SELECT text FROM sys.dm_exec_sql_text(sql_handle)) AS query_text 
FROM sys.dm_exec_requests r
WHERE session_id >= 51

For more detail about was has been running, try:

select s.session_id, s.login_name, s.host_name, s.status,

mattiaswolff

<?xml version="1.0" encoding="utf-8"?><!-- Copyright (c) 2008-2014 New Relic, Inc.  All rights reserved. --><!--
    When you edit this file, please use an XML aware editor (such as Visual Studio),
    and pair with the companion file extension.xsd to minimize the
    chance of introducing typos that may confuse the agent when it is run.
--><extension xmlns="urn:newrelic-extension">
	<instrumentation>
		<tracerFactory>
			<match assemblyName="Medius.Core.Platform" className="Medius.Core.Platform.Services.TaskManager">
				<exactMethodMatcher methodName="CompleteTask" />
				<exactMethodMatcher methodName="ShouldSaveTask" />

mattiaswolff

D:\SQLData\MSSQL10.MSSQLSERVER\MSSQL\Log\ClearLogTable_$(ESCAPE_SQUOTE(JOBID))_$(ESCAPE_SQUOTE(STEPID))_$(ESCAPE_SQUOTE(STRTDT))_$(ESCAPE_SQUOTE(STRTTM)).txt

mattiaswolff

<system.webServer>
	<urlCompression doDynamicCompression="true" />
</system.webServer>

mattiaswolff

DECLARE @TableName VARCHAR(100)    --For storing values in the cursor

--Cursor to get the name of all user tables from the sysobjects listing
DECLARE tableCursor CURSOR
FOR 
select [name]
from dbo.sysobjects 
where  OBJECTPROPERTY(id, N'IsUserTable') = 1
FOR READ ONLY

mattiaswolff

DECLARE @intErrandId integer 
DECLARE @intPaymenttransferred integer 
DECLARE @strVerificationIdentity nvarchar (20)

SET @intErrandId = [[Errand Id]]
SET @strVerificationIdentity = '[[Verification Identity]]' 

-- Get payment transsferred status based on statusId

SELECT @intPaymenttransferred = CASE (e.statusid)

mattiaswolff

USE [msdb]
GO

/****** Object:  Job [MediusFlow optimization job]    Script Date: 09/12/2012 18:24:14 ******/
BEGIN TRANSACTION
DECLARE @ReturnCode INT
SELECT @ReturnCode = 0
/****** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 09/12/2012 18:24:14 ******/
IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N'[Uncategorized (Local)]' AND category_class=1)
BEGIN