A Maintenance plan is any variety of scheduled maintenance to an object or item of equipment. In SQL Server a maintenance plan creates a workflow of the tasks required to make sure that the database is optimized, regularly backed up and free of inconsistencies.
Questions tagged [maintenance-plan]
105 questions
0
votes
0 answers
Code reusability issue when creating API with Flask
I have code reusability issue in my code, this is one of example of routes folder file, it's users.py:
from models import User, ApiResponse
from mongoengine import ValidationError
from flask import request
from utils import get_timestamp
from copy…
Muhammad Ikhwan Perwira
- 548
- 3
- 16
0
votes
0 answers
Which method should be used for Predictive Maintenance for Bearings? I tried Naive-Bayes but i think its not effective enough
I have multiple system and they all have high speed bearings. It is not wanted that the bearing failure happening during the production. So i tried to write a program that tries to predict bearings life.
I tried to use Naive Bayes method but i…
Andumir
- 11
- 2
0
votes
0 answers
Improving the edges of my savgol filtered data in python
I am currently making a machine learning model to predict the Remaining Useful Lifetime (RUL) of Turbofan engines. I was not happy with my previous noise defiltering method. So I decided to try a Savgol filter. I implemented the filter with (enough)…
0
votes
0 answers
Way to ensure maintenance plan attempts every stored procedure?
I have a stored procedure that is run based on plant name.
I have a maintenance plan that calls the stored procedures for all plants in a timezone like
execute dbo.runPlantSP('plant1')
execute dbo.runPlantSP('plant3')
execute…
Brian Karabinchak
- 207
- 1
- 9
0
votes
0 answers
SQL rebuild Index Maintenance Plan is missing the Index Stat Option to set fragmentation percentages?
My maintenance plan is missing the section in the config window that allows you to set the fragmentation > a percentage. Does anyone know how to get this option or is it maybe I'm on too old a version of SQL? I'm on SQL 2014.
Robert Weatherman
- 65
- 7
0
votes
1 answer
SQL Server Maintenance Plans Missing After Creation
When I create new maintenance plans on an instance of SQL 2005 SP2, they are all successfully created (e.g. they are in the Package Store and jobs are created for each step) but they do not show up in the Maintenance Plans folder under…
PseudoToad
- 1,504
- 1
- 16
- 34
0
votes
1 answer
Getting a 503 for the resources as well while setting up for a maintenance page in NGINX
I'm trying to set up a maintenance page for an application, hosted via NGINX web server.
Currently I have this set up.
location ^~/maintenance/ {
root /path/to/the/maintenance/maintenance.html;
}
set $maintenance 0;
if (-f…
Emir
- 47
- 6
0
votes
1 answer
Maintenance tasks on Azure SQL Managed instance
I have 4 SQL managed instances and have some custom task defined on SQL Managment Studio. On azure I found that the managed instance have a Maintenance Window:
My question is.. What kind of tasks are performed in the Azure maintenance window?
I…
Van Darth Vadden
- 561
- 1
- 5
- 11
0
votes
1 answer
How do I maintain zabbix for MongoDB backup? with ansible
I have to implement zabbix maintenance for Mongodb backup with ansible
the tasks are as…
King Snow
- 13
- 2
0
votes
1 answer
Azure Used Vs Allocted Vs Maximum in elastic pool
I'm currently doing some cleanup on an Azure environment and just wanted to check calculations. I have about 55 Databases on an elastic server, which is currently sitting at 3.64TB of the maximum 4TB. Having a look at each of the databases within…
Robert Brand
- 3
- 1
0
votes
1 answer
SQL Server 2016 Maintenance Plan Editor - Add Annotation Not Working
I'm using: -
Microsoft SQL Server 2016 (SP2-CU15-GDR) (KB4583461) - 13.0.5865.1 (X64)
SQL Server Management Studio 15.0.18384.0
I have created a brand new Maintenance Plan for a Daily Backup.
The Maintenance Plan works fine…
andyabel
- 335
- 4
- 15
0
votes
0 answers
calculating MTBF in Excel
I'm trying to Calculate MTFB with what I have, which isn't much, using Excel.
Date
Full Plate Number
Vehicle Type
Status
1/2/2021
1234 ABC
TRAILER
OUT OF SERVICE
1/3/2021
1234 ABC
TRAILER
OUT OF SERVICE
1/4/2021
1234 ABC
TRAILER
OUT OF…
Majid Alashari
- 43
- 8
0
votes
1 answer
Do re-indexing of database runs automatically with CRM app?
It's my first time using CRM as an app. I have been using SQL Server for quite a while now. Our company is experiencing issues with emails, thus having warnings in event viewer
Query execution time of 17.3 seconds exceeded the threshold of 10…
Dwightqwerty
- 3
- 1
0
votes
1 answer
SQL Maintenance Plan - Determining Duration of Steps
I'm trying to keep a maintenance plan under 30 minutes. The duration of each step indicates this should be the case, but the plan is running over 1 hour.
The check database integrity ends at 20:04:16 and the next step, update statistics starts at…
0
votes
0 answers
SQL server backup issue - locked file
We have standart maintenance BACKUP plan
Task of backup has verifyonly option enabled.
During perfroming of backup we have failed job because VERIFYONLY task failed because of backup file was holded by another process. If I grub code from…
Alexandr
- 25
- 7