Solved

Will DB Backup's  cleanup job will cause Paging ?

Posted on 2014-10-24
6
54 Views
Last Modified: 2016-06-15
Hi All,

Will Database backup  cleanup job (maintenance plan)  cause paging issue in Server ?

Server: Windows server 2008R2
DB:SQL Server 2008R2

Regards,
0
Comment
Question by:GK GK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
6 Comments
 
LVL 34

Expert Comment

by:ste5an
ID: 40401271
Maybe.
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40401715
Only if you have an huge history of backups but in generally should not.
0
 

Author Comment

by:GK GK
ID: 40418957
Thanks for update,

Please let me know how to clean backup history.

Regards
0
 
LVL 50

Expert Comment

by:Vitor Montalvão
ID: 40419104
If you are using native maintenance plan then you should have a History Cleanup Task. Otherwise you can delete the backup history by running the following command:
EXEC msdb.dbo.sp_delete_backuphistory  @oldest_date

Open in new window

0
 

Accepted Solution

by:
GK GK earned 0 total points
ID: 40432544
Dear All,

We found the issue, There are two Server monitoring services are running in the server, One of monitoring service causing the paging issue.

Regards
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This article shows how to use a free utility called 'Parkdale' to easily test the performance and benchmark any Hard Drive(s) installed in your computer. We also look at RAM Disks and their speed comparisons.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question