{}

Onze merken

Welkom op de website van Schneider Electric

Welkom op onze website.
Populaire vragen (FAQ's) zoeken
Database Maintenance Progress
Issue
How to determine the progress of a database maintenance operation.

Product Line
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x, 8.x, 9.x, 2020
ION Enterprise 6.0. x
ION EEM

Environment
SQL Server 2005, SQL Server 2008 R 2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017

Cause
Maintenance operations on larger database make take some time to complete and can also become 'stuck'.  Monitoring
the progress of these operations can be useful when troubleshooting and/or estimating the time to completion for what may be system
impacting maintenance procedures.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

To retrieve the database maintenance progress information from the current SQL Server installation, log into SQL Server Management Studio
and run the attached SQL script (Mnt_Progress.sql).
Alternatively, execute the query(s) below :
SELECT command, percent_complete, start_time 
FROM sys.dm_exec_requests
where percent_complete <> 0;

Schneider Electric Belgium

bijlage(n)
Mnt_Progress.sql [102 Bytes]
Database Maintenance Progress
Issue
How to determine the progress of a database maintenance operation.

Product Line
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x, 8.x, 9.x, 2020
ION Enterprise 6.0. x
ION EEM 

Environment
SQL Server 2005, SQL Server 2008 R 2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017

Cause
Maintenance operations on larger database make take some time to complete and can also become 'stuck'.  Monitoring
the progress of these operations can be useful when troubleshooting and/or estimating the time to completion for what may be system
impacting maintenance procedures.

Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

To retrieve the database maintenance progress information from the current SQL Server installation, log into SQL Server Management Studio
and run the attached SQL script (Mnt_Progress.sql). 
Alternatively, execute the query(s) below :
SELECT command, percent_complete, start_time 
FROM sys.dm_exec_requests
where percent_complete <> 0;

Schneider Electric Belgium

bijlage(n)
Mnt_Progress.sql [102 Bytes]
Ontdek meer
Productfamilie
Ontdek meer
Productfamilie
Ontdek meer
Productfamilie
Ontdek meer
Productfamilie
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.
Your browser is out of date and has known security issues.

It also may not display all features of this website or other websites.

Please upgrade your browser to access all of the features of this website.

Latest version for Google Chrome, Mozilla Firefox or Microsoft Edgeis recommended for optimal functionality.