Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gattaca2K
Starting Member
1 Post |
 Posted - 2009-06-23 : 18:43:10
|
| Hi,I'm having a problem with a cold fusion web application using SQL as a back end. Performance is really dragging under a load of approximately 200+ users (its an exam section of the application and it takes a full minute to move from page/question to page/question. Hardware is good (Server runs 16 Xeon 3 GHz processors (quad, quad core) with 32 GB RAM. Indexes and SQLStatements/Stored Procs have been tuned and are performing optimally (they've all been checked via various tuning tools, SQL Profiler, etc.). What other places might I look to try to troubleshoot performance? I'm wondering if there is some MSSQL cache or Cold Fusion Cache somewhere?Many Thanks in advance,Rick |
|
|
|
|
|
Cold Fusion/MSSQL 2005 poor load performance.