Questions tagged [maintenance]
In the context of a database, maintenance describes routine operational tasks around a database system, such as monitoring, tuning and backup procedures.
27
questions with no upvoted or accepted answers
9
votes
0
answers
950
views
How to minimize access exclusive table locks while reducing bloat or ALTER (ing) a table?
In some circumstances, I've been told not to do a VACUUM FULL (or CLUSTER) of a table that is in production, because that will exclusively lock it for longer than wished. The same might apply to ...
3
votes
0
answers
181
views
Database Maintenance Planner greyed out (disabled)
I have to look into some SQL Server 2000 maintenance plans, but Database Maintenance Planner option is greyed out in Tools menu of Enterprise Manager. SQL Server Agent seems enabled and running, ...
2
votes
2
answers
2k
views
MySQL db optimization error on innodb tables
I have a database named 'mysql' which is being used on RHEL 8 server running MySQL 8.0.32.
When trying to optimize the entire database using the mysqlcheck command 'mysqlcheck -o mysql' the below ...
2
votes
0
answers
315
views
DBCC Inconsistency
I can run
DBCC CHECKDB ([vsc]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY
I get:
Msg 8928, Level 16, State 1, Line 5
Object ID 1993058136, index ID 1, partition ID 72057594058964992, alloc ...
2
votes
0
answers
300
views
Disable/Remove Table Index for INSERT Performance
I am doing a database maintenance where I have to add new fields to a table with over 10GB of data about (20 million rows). To solve that I renamed tableA to be old_tableA and created a new table ...
2
votes
0
answers
2k
views
How to do automated archiving for a SQL Server database based on interpretation of database metadata?
I am looking for a solution giving me automated archiving of SQL Server databases based on a smart interpretation of table relationships that is able to archive records from related tables minimizing (...
1
vote
0
answers
63
views
How to select specific databases in a backup retention policy maintenance plan cleanup task?
I have full backups of three different databases. Right now all of their backups follow the same retention policy, but I need to setup the retention to a different amount of time for each database.
...
1
vote
1
answer
2k
views
Reset all sequences so that they continue after max(id) + 1?
It looks like I messed up a database migration and while all sequences are there, they would start at 1, which triggers errors like:
django.db.utils.IntegrityError: duplicate key value violates ...
1
vote
0
answers
469
views
OLA Output File Cleanup - Better Options
Does anyone have a way to change the Ola Hallengren "Output File Cleanup" job that doesn't require CmdExec? My company is trying to eliminate CmdExec where ever possible. I was thinking a PowerShell ...
1
vote
0
answers
317
views
Postgres VACUUM , REINDEX, ANALYSE
How do I know if I need to run any of VACUUM, REINDEX, ANALYSE? Because I don't want to run this every day even if it is not needed.
For example, is it a good option to run all of above after 100 ...
1
vote
0
answers
586
views
HowTo: [Output File Cleanup] workaround for UNC targets
Hallengren job [Output File Cleanup] silently fails when the output file directory is a network file share.
Question: Is there a better, cleaner way to resolve the issue detailed below when the job ...
1
vote
0
answers
387
views
SQL Server Maintenance Cleanup Task
Question on what actually the "Maintenance Cleanup Task" does. When the process executes I see xp_delete removing files but does the task also remove any entries from tables within MSDB?
The reason ...
1
vote
0
answers
841
views
Dropping old and creating a new clustered index
I am wondering what is the best approach for dropping and creating a new clustered index on a table within SQL Server 2008. My primary concern is the length of time it will take to perform this ...
1
vote
0
answers
2k
views
Unable to view "Maintenance Plan" folder under Maintenance in SQL Server 2008 R2 Standard Edition
SQL Server version is as follows :
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
Copyright (c) Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service ...
1
vote
0
answers
1k
views
Update Statistics Maintenance Plan - Ambiguous column name error
Microsoft SQL Server 2008 R2 Web Edition (RTM) - 10.50.1600.1 (Intel X86)
Windows 2003 R2 SP2
I am in the process of setting up a maintenance plan to update statistics on a daily basis for all user ...
0
votes
0
answers
26
views
Statistics update - worthwhile on a high activity table or not?
I have a table with 1.5 billion records which is sampled at 1%. Said table receives over 200-300k insert/update/deletes per hour. Within a couple of hours, the statistics are auto updated as it ...
0
votes
1
answer
104
views
Error message when running a SQL maintenance plan backup
I'm receiving the following error message when my daily maintenance backup plans execute:
Error Message 1:
[298] SQLServer Error: 407, Internal error. The string routine in file e:\sql11_main_t\sql\...
0
votes
1
answer
59
views
Partitioning using column from different table
I have a table ActionValues with the following columns:
AccountID
Action
ActionValue
This table is related with a second table called Actions that has the following columns:
AccountID
Action
...
0
votes
0
answers
185
views
How to temporarily switch PostgreSQL to logical replication to allow major version upgrade without downtime?
We have a PostgreSQL cluster running on one master (db1) and two async hot-standby servers (db2 and db3) replicating from it. All the servers are working as a backend for a web service and all the ...
0
votes
1
answer
121
views
SQL Server - Maintenance - How to obtain duration per database from the commandlog table
Attempting to obtain the duration for individual maintenance operations per database in the commandlog table which is available in Ola Hallengren's maintenance scripts
If anyone has a better solution ...
0
votes
2
answers
2k
views
How to reduce the size of a SQL Server-Database?
Context
We have a Backup DB, where we normally store BackUps of tables from production DB before doing any updates/deletes. If anything goes wrong, we can restore the data from that table created in ...
0
votes
1
answer
176
views
Oracle gather stats autotask being interrupted before maintenance window ends
a few months ago I managed to enlarge the maintenance windows for autotask on a pluggable database, this way:
BEGIN
dbms_scheduler.disable(
name => 'WINDOW_NAME');
dbms_scheduler....
0
votes
4
answers
206
views
Index Maintenance on busy OLTP database
I have a database where constant read writes happening all the time. Searches are being done with wild card entries. The server is on SQL 2016 standard edition.
There is no budget for enterprise nor ...
0
votes
1
answer
86
views
ORA--07445 error during online Re-org process in 10.2.0.4 database
I was doing re-org of fragmented tables in an Oracle 10.2.0.4 production database:
sys@CLARITY> ALTER TABLE SOP_QUEUE ENABLE ROW MOVEMENT;
Table altered
sys@CLARITY> ALTER TABLE SOP_QUEUE ...
0
votes
1
answer
95
views
Existing maintenance plan backup causing 3rd party SQL backup to fail
I have a problem with SQL Server backup on the MS SQL Server 2008R2 (SP1) 10.50.2500.
Basically there is a maintenance plan backing up SQL databases into the physical_device_id which is showing up as ...
0
votes
0
answers
160
views
Folder permissions changing when running Ola Hallengren maintenance scripts
We use a centralized backup location on a network share. Each instance uses the Ola Hallengren scripts to perform nightly backups.
I have a team that requires folder permissions to the same location ...
0
votes
0
answers
234
views
DBCC CheckDB result sent to OSQL poses confusion
Reformulated the Question
I have a .BAT script that runs the DBCC CheckDB and repairs the database if needed. The result of the DBCC CheckDB is sent to OSQL through the -b flag and the .BAT ...