Hey, been getting the page of DOOM on our development server over the last couple of weeks, I am properly locking all queries and stored proc calls but still it creeps in, averaging 2 a day.
error desc: [Microsoft][ODBC SQL Server Driver][SQL Server]Your transaction (process ID #20) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction. Our devserver is connected to the same SQL server as our Production server, I know, I know but budget is an issue here, which is getting a lot of transactions / "INSERT" / per day averaging 44,100 transactions, this is excluding GET transactions, thses transactions a set to get bigger also, which makes me think of Clustering SQL server, has anyone done this? The reason for clustering SQL and not CF is because about 2 thirds of these are done by Exchange, I know there is things that should be looked into at SQL server side, currently looking at this, but, any direct advice on this matter would be appreciated, Respectfully, j ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
