Backup Status / Current process and all processes - Historique des versions

Lli : Remplacement de texte : « Database » par « Databases »

2023-03-24T18:44:22Z

Remplacement de texte : « Database » par « Databases »

← Version précédente		Version du 24 mars 2023 à 20:44
Ligne 2 :		Ligne 2 :
	SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED		SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	SELECT		SELECT
	DB_NAME(er.[database_id]) [~~DatabaseName~~]		DB_NAME(er.[database_id]) [DatabasesName]
	,er.[session_id] AS [SessionID]		,er.[session_id] AS [SessionID]
	,er.[command] AS [CommandType]		,er.[command] AS [CommandType]

Lli le 23 mars 2023 à 12:55

2023-03-23T12:55:03Z

← Version précédente		Version du 23 mars 2023 à 14:55
Ligne 1 :		Ligne 1 :
	<SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED		<syntaxhighlight lang="sql">
			SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	SELECT		SELECT
	DB_NAME(er.[database_id]) [DatabaseName]		DB_NAME(er.[database_id]) [DatabaseName]
Ligne 15 :		Ligne 16 :
	CROSS APPLY sys.dm_exec_sql_text(er.[sql_handle]) est		CROSS APPLY sys.dm_exec_sql_text(er.[sql_handle]) est
	WHERE er.[command] in ('RESTORE DATABASE','BACKUP DATABASE','RESTORE HEADERON')		WHERE er.[command] in ('RESTORE DATABASE','BACKUP DATABASE','RESTORE HEADERON')
			<syntaxhighlight lang="sql">

	SELECT FORMAT( GETDATE(), 'hh.mm tt dddd, dd MMMM, yyyy');~~</code>~~
	~~<syntaxhighlight lang="sql">~~		<syntaxhighlight lang="sql">
	~~test~~		SELECT FORMAT( GETDATE(), 'hh.mm tt dddd, dd MMMM, yyyy');

	</syntaxhighlight>		</syntaxhighlight>

	== all process status ==		== all process status ==
	<select		<syntaxhighlight lang="sql">
			select
	a.session_id		a.session_id
	, command		, command
Ligne 31 :		Ligne 34 :
	from sys.dm_exec_requests a		from sys.dm_exec_requests a
	CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) b</code>		CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) b</code>
			</syntaxhighlight>
	== link pid and spid ==		== link pid and spid ==

	<SELECT osTask.session_id, osThreads.os_thread_id,		<syntaxhighlight lang="sql">
			SELECT osTask.session_id, osThreads.os_thread_id,
	osTask.scheduler_id, osTask.task_state		osTask.scheduler_id, osTask.task_state
	FROM sys.dm_os_tasks AS osTask		FROM sys.dm_os_tasks AS osTask
Ligne 41 :		Ligne 45 :
	WHERE osTask.session_id IS NOT NULL		WHERE osTask.session_id IS NOT NULL
	ORDER BY osTask.session_id;		ORDER BY osTask.session_id;
	GO		GO</syntaxhighlight>
	GO</~~code~~>
	[[Catégorie:Mssql]]		[[Catégorie:Mssql]]

Lli le 23 mars 2023 à 12:52

2023-03-23T12:52:20Z

← Version précédente		Version du 23 mars 2023 à 14:52
Ligne 1 :		Ligne 1 :
	<~~code>~~SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED		<SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	SELECT		SELECT
	DB_NAME(er.[database_id]) [DatabaseName]		DB_NAME(er.[database_id]) [DatabaseName]
Ligne 18 :		Ligne 18 :

	SELECT FORMAT( GETDATE(), 'hh.mm tt dddd, dd MMMM, yyyy');</code>		SELECT FORMAT( GETDATE(), 'hh.mm tt dddd, dd MMMM, yyyy');</code>
			<syntaxhighlight lang="sql">
			test
			</syntaxhighlight>

	== all process status ==		== all process status ==
	<~~code>~~select		<select
	a.session_id		a.session_id
	, command		, command
Ligne 31 :		Ligne 34 :
	== link pid and spid ==		== link pid and spid ==

	<~~code>~~SELECT osTask.session_id, osThreads.os_thread_id,		<SELECT osTask.session_id, osThreads.os_thread_id,
	osTask.scheduler_id, osTask.task_state		osTask.scheduler_id, osTask.task_state
	FROM sys.dm_os_tasks AS osTask		FROM sys.dm_os_tasks AS osTask

Lli : Page créée avec «  `SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT DB_NAME(er.[database_id]) [DatabaseName] ,er.[session_id] AS [SessionID] ,er.[command] AS [CommandType] ,est.[text] [StatementText] ,er.[status] AS [Status] ,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent] ,CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m] ,CONVERT(DECIMAL(38, 2), er.[estimated_completion_time] / 60000.00) AS [EstimatedComple... »`


2023-03-23T12:50:42Z
Page créée avec «  <code>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED   SELECT   DB_NAME(er.[database_id]) [DatabaseName]  ,er.[session_id] AS [SessionID]  ,er.[command] AS [CommandType]  ,est.[text] [StatementText]  ,er.[status] AS [Status]  ,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent]  ,CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m]  ,CONVERT(DECIMAL(38, 2), er.[estimated_completion_time] / 60000.00) AS [EstimatedComple... »
Nouvelle page
 <code>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 

 SELECT 

 DB_NAME(er.[database_id]) [DatabaseName]

 ,er.[session_id] AS [SessionID]

 ,er.[command] AS [CommandType]

 ,est.[text] [StatementText]

 ,er.[status] AS [Status]

 ,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent]

 ,CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m]

 ,CONVERT(DECIMAL(38, 2), er.[estimated_completion_time] / 60000.00) AS [EstimatedCompletionTime_m]

 ,er.[last_wait_type] [LastWait]

 ,er.[wait_resource] [CurrentWait]

 FROM sys.dm_exec_requests AS er 

 INNER JOIN sys.dm_exec_sessions AS es ON er.[session_id] = es.[session_id]

 CROSS APPLY sys.dm_exec_sql_text(er.[sql_handle]) est

 WHERE er.[command] in ('RESTORE DATABASE','BACKUP DATABASE','RESTORE HEADERON')

 

 

 SELECT FORMAT( GETDATE(), 'hh.mm tt dddd, dd MMMM, yyyy');</code>



== all process status ==

 <code>select

 a.session_id

 , command

 

 , a.start_time

 , estimated_completion_time = DATEADD(ms, a.estimated_completion_time, GETDATE() )

 from sys.dm_exec_requests a

 CROSS APPLY sys.dm_exec_sql_text(a.sql_handle) b</code>



== link pid and spid ==

 

 <code>SELECT osTask.session_id, osThreads.os_thread_id,

 osTask.scheduler_id, osTask.task_state

 FROM sys.dm_os_tasks AS osTask

 INNER JOIN sys.dm_os_threads AS osThreads

 ON osTask.worker_address = osThreads.worker_address

 WHERE osTask.session_id IS NOT NULL

 ORDER BY osTask.session_id;

 GO  

 GO</code>

[[Catégorie:Mssql]]

Backup Status / Current process and all processes - Historique des versions

Lli : Remplacement de texte : « Database » par « Databases »

Lli le 23 mars 2023 à 12:55

Lli le 23 mars 2023 à 12:52

Lli : Remplacement de texte : « Database » par « Databases »