I have ColdFusion MX and SQL Server 2000 running on the same WIN 2003 Server. We run a pretty query intensive site, and we've had problems with SQL Server memory leaks for a long time which I'd really like to clean up so we don't have to stop and restart SQL Server every 24 hours...Stopping and restarting SQL Server reset it, but looking at the performance monitor over the course of 24 hours, you can watch the total SQL server server memory creeping up toward the target server memory until it maxes out and the site slows waaay down
I've been told that this has to do with our site's code, specifically SQL queries, and I'm trying to educate myself on what the best coding practices are to prevent these leaks. I'm not sure where to start - I've always tried to build efficient queries, and follow proper cflocking practices, but I inherited this site, and I'm not even sure what kinds of bad coding would cause SQL server leaks. Can anyone give me some tips, or point me in the right direction? Thanks... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197553 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
