Server is sluggish after BackupExec/SQL Server 2005 "lite" install

[irbk]

I've had several servers that ran fine, until we installed BackupExec software, which includes the "lite" version of SQL Server 2005. After the install, all of the server functions become very sluggish. Has anyone else noticed this issue and found a fix?

Thanks in advance.

 

[chipk]

Please provide info about your hardware configuration including memory, hardware, and performance settings.

Also check out this article which points out a specific driver that sometimes gets installed with BackupExec:

http://support.microsoft.com/kb/822219/en-us

 

[irbk]

Dell PowerEdge running Server 2003
Dual 2.8 GHz proc
2 Gig Ram
Mirrored Sata HD's
Never had a lick of problems with them until after the BackupExec install, and then it was only after BackupExec went to the SQL Server 2005 that it started acting sluggish.

 

[chipk]

Check that link to see if the particular driver applies to your situation.

 

[irbk]

I wandered down that path a long time ago. Didn't help.

 

[chipk]

Have you used Performance Monitor to find out exactly what is eating up your resources? If you simply stop the BackupExec and SQL services, does server speed return to normal?

 

[mofusjtf]

Take a loot at task manager and see what SQL is doing. You might need to throttle SQL's memory. I typically give BE's SQL instance 200 MB or RAM MAX. Modify this command to fit your needs.

USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
USE master
EXEC sp_configure 'max server memory (MB)', 100
RECONFIGURE WITH OVERRIDE
USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE

Save this into a .sql file. Then create a batch file with the following

osql -E -S SERVERNAME\SQLInstancename -i c:\filename.sql

The above command will throttle your SQL memory useage to 100 MB. Obviously you can adjust as you see fit.

Also look at your BE services. Any program by Symantec takes a lot of resources to run. It might not be a bad idea to up your RAM to 4 GB.