Quoting Hatton Humphrey <[EMAIL PROTECTED]>: > > Hi folks, I've had my head buried in what we refer to as a "HOT" > issue... one of our applicaitons just moved from CF 4.5/SQL 7 to CF > 5/SQL 2000 and is now having extreme problems. Basically what I'm > getting back from the server guys is, "the SQL Statements being > generated by the application are all locking each other out". This > application runs fine most of the time but now it's getting a HUGE > jump in usage and it's turning into a massive issue.
Need... more... information :) > My questions: > - Does this sound like a setting issue in CF? What things should I > look for on that regard? What settings are different? Connection pooling? Connection timeouts? > - Does this sound like a setting issue in SQL Server? What things > should I look for there? The one thing that jumps to mind is the default transaction isolation level. But without knowing if you use transacions at all, stored procedures, pass-through-queries or prepared statements I don't know. > - Does this sound like a setting issue in IIS? No. > I know it's not a hardware issue... the new webserver is a > quad-processor machine with 4Gb of ram! But if you told SQL Server it can only use 1 processor and 250 MB of ram it could very well be the problem. What is the load on all processors, what is the memory usage, how big is the total database (including indexes etc.), is our I/O not yet saturated etc.? jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
