Are you using stored procs and bind variables in your SQL?

[Shazam]

Just curious... With the beating that this forum gets, are you using CFQUERY or stored procedures? How about bind variables to keep an execution path for your SQL within SQL Server?

 

[Jason Clark]

There is barely any different between using stored procs or cfquery, the query times aren't the problem here at all. Its a dead scsi drive and a motherboard or memory issue in the db server. As it will shut itself off once and awhile, and sometimes just crash SQL server. Query speed has absolutely nothing to do with it

 

[Shazam]

Ouch, you're telling me you only have one DB server?

 

[Jason Clark]

Sure, and it will handle it just fine. The db server has some hardware issues that are going to be fixed this week with a new server. You do not need multiple sql servers for this load, maybe in a year or two but not right now. The cost associated with a proper transactional based sql cluster is astronomical.