We have a VB app. that is sending parameters to a Stored Procedure in SQL Server 7.0. The problem we can't figure out is the stored procedure keeps timing out and thus not completing it's task. The SP has worked for 4 years now and has only started messing up in the last month or two. We've tried to set the timeout to larger and larger values, but this doesn't help. We're not even close to using our SQL Server system to it's full potential. But yet it doesn't seem to have time to run a simple Stored Procedure. We've noticed that the CPU is running at around 40-50%. Is that normal? We just don't know where to start. We were running a lot of DB backups that was using a lot of system resources, but have since canceled them and we're still having the same problems with this SP not completing it's job. HELP!!