Solved

Will DB Backup's  cleanup job will cause Paging ?

Posted on 2014-10-24
6
50 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 33

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
This article summaries thoughts and ideas from two years of sustained use. It provides good reasoning to make the jump to Windows 10.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

740 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