Bacukp Exec 10d - SQL performance decreased by 50% overnight.
Posted on 2006-10-31
For over a year, I was getting an average rate of 2700-2800 MB/Min to my backup server from my SQL 2000 server (Windows 2003 Enterprise server). Then almost overnight, it dropped to 1200-1450 MB/Min, making my backups which used to take about 7 hours take 15-17 hours now. I have 9 other servers backed up by the same machine, and none of them really changed.
Well, actually it happened 1 night, then returned to regular speed, then 2 nights later, when I removed older Trend Micro Antivirus software it started again every night since, for a month now. I did not get the new Trend Micro installed for over a week because of problems installing it, so the new Antivirus is not the problem, as for that week when it was running without, it ran at the same speed. I have perfromed Bitdefender, Kaspersky, and Panda scans to make sure it did not get infected during that time. Also, this was a month ago. I THINK I also installed the World Wide Web Publishing service on this machine as it was required by the new Antivirus for management. I then reinstalled SP1 and any Windows updates. I have since also applied the latest SQL service pack, and all Backup Exec patches, and reinstalled the Backup Exec client for Windows Servers on the SQL server.
- Dell Poweredge 6650, 4 x Intel Xeon 2.8 processors, 8 Gig of memory
- 2 x Broadcom NetXtreme Gigabit Ethernet Adapters, teamed with the Broadcom Advanced Control Suite v 6.03.1, driver date 10/31/05 v18.104.22.168
- DELL PERC 3/DCL RAID Controller - 2 x 34 Gig Drives Mirrored, 2 partitions, OS on C:, SQL Server on D:
- 2 x Qlogic QLA2340 Fibre Channel Adapter, connected to Dell EMC2 storage array, Driver date 3/16/06 v 22.214.171.124, RAID 5, 1656.65 Gigabyte, containing all of the SQL data and analasys, etc...
The C: and D: drives still back up at the same speed it seams, the F:, G:, and H: drives on the Fibre adapter that contain all of the Data are showing 1/2 the throuput they used to. I updated the NIC drivers, and the Fibre adapter drivers.
And now I just don't know what else to do....
Any ideas please?