Hi,
I had a Application running for 2 hours which does run SSIS Packages , Inserts, Updates, Deletes on few databases and i have a Symantec log backup job which runs every 3 hours ...
We had huge performance problems Disk I/O , CPU , MEMORY everything was high , so
Naresh
06/11/2013
I had a Application running for 2 hours which does run SSIS Packages , Inserts, Updates, Deletes on few databases and i have a Symantec log backup job which runs every 3 hours ...
We had huge performance problems Disk I/O , CPU , MEMORY everything was high , so
I added few indexes, constantly monitored with Activity
monitor , the last step of Application is to delete from history database tables
and then insert in History database tables which  is taking long time to
complete  also at the same time in parallel Symantec was doing a log 
backing up history database log file(LDF) and doing a constancy check.
So I was positive that when backups are running mainly when
Symantec starts backup of History database doing a consistency check and at the same time when the
Application is trying to access History, Process database tables the process is
taking longer than expected.
So after lot of research I  suggested to take  out Consistency check from backups  and then  log backups ran in 1 min and also the application ran good, with no huge DISK I/O and CPU hikes ..
Tip here is: 
do not run Constancy check during normal business hours .its high Disk I/O and CPU operation ,...
Thanks
06/11/2013
No comments:
Post a Comment