Database Troubleshooting
Resources
Following are blog entries or other resources related to this subject.
General DB Troubleshooting Resources
- Spying on ORM database interactions: Hibernate, Transfer, etc. on any CFML engine (blog entry, Charlie Arehart, 2009)
- Client Variable Database and Reserved Word Alias (blog entry, Mark Kruger, 2009)
- New for CF9 (and 9.0.1): a query timeout that really works, with a caveat (blog entry, Charlie Arehart, 2010)
- Cached Plans and Static Variables (blog entry, Mark Kruger, 2008)
- Can Performance Suffer With Cfqueryparam? (blog entry, Mark Kruger, 2008)
- What is the FusionReactor datasource monitoring feature? Why would I use it? Powerful stuff! (blog entry, Charlie Arehart, 2008)
- The Dreaded Mismatched Column or Data Type Error Revisited (blog entry, Mark Kruger, 2008)
- Bug with Query of Query: using LIKE incorrectly finds records with null values (blog entry, Charlie Arehart, 2008)
- Datasource Timeouts and Support for CFQUERY Timeout Attribute (blog entry, Steven Erat, 2006)
- Why You should worry about your execution plan (blog entry, Mark Kruger, 2005)
- Connection Pooling Deadlocks with User-based Security Models (blog entry, Steven Erat, 2005)
- Changing Database Schemas may require a restart of CFMX (blog entry, Mark Kruger, 2005)
- Connection Pooling and User-based Security Models (blog entry, Steven Erat, 2005)
SQL Server-specific DB Troubleshooting Resources
Resources from CF-oriented authors
- Hanging JRUN Threads, MSSQL and Parallelism (blog entry, Mark Kruger, 2011)
- Processor Usage in MSSQL (blog entry, Mark Kruger, 2010)
- How To Get The SQL Server SPID Out Of SeeFusion (blog entry, Brad Wood, 2009)
- Data Truncation Error: Migrating MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Migrating Between MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- SQL Server Gotcha: Implicit Unicode Conversion (blog entry, Brad Wood, 2009)
- Got problems with SQL Server tempdb? Here are some resources (blog entry, Charlie Arehart, 2008)
- Migrating to MSSQL 2005 and UNION Queries (blog entry, Mark Kruger, 2008)
- Having problems with SQL Server/Oracle/DB2/Sybase? Check out Confio Ignite (blog entry, Charlie Arehart, 2008)
- Several SQL Server Performance Tuning how to's (blog entry, Charlie Arehart, 2008)
- Helpful info on SQL Server Diagnostics: Part II (blog entry, Charlie Arehart, 2008)
- Helpful info on SQL Server Diagnostics (blog entry, Charlie Arehart, 2008)
- Resources for getting a much greater understanding of the SQL Server query plan/procedure cache (blog entry, Charlie Arehart, 2007)
- New (free) Performance Dashboard for SQL Server 2005 SP2 (blog entry, Charlie Arehart, 2007)
- MS SQL's Casting Causes Consternation (blog entry, Mark Kruger, 2006)
- More CF and DTS Troubleshooting (blog entry, Mark Kruger, 2006)
- DTS Over Coldfusion - Revisited (blog entry, Mark Kruger, 2006)
- Solving error connecting to SQL Server 2005 from CFMX 6.1/7 on Localhost (blog entry, Charlie Arehart, 2006)
Resources from other than CF-oriented authors
- Concurrency Series: My application was running fine yesterday but why is it blocking today? (blog entry, Sunil Agarwal, 2011)
- Concurrency Series: Minimizing blocking between updaters (blog entry, Sunil Agarwal, 2011)
- Concurrency Series: Why do I get blocked when no one has locked the row(s) being queried? (blog entry, Sunil Agarwal, 2011)
- Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint? (blog entry, Sunil Agarwal, 2011)
- Concurrency Series: Basics of Transaction Isolation Levels (blog entry, Sunil Agarwal, 2011)
- Concurrency Series: Common Concurrency Issues with Applications (blog entry, Sunil Agarwal, 2010)
MySQL-specific DB Troubleshooting Resources
- Validation Query for MySQL communications link failure (blog entry, Steven Erat, 2011)
- Data Truncation Error: Migrating MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Migrating Between MySQL to MSSQL (blog entry, Mark Kruger, 2009)
- Having problems with SQL Server/Oracle/DB2/Sybase? Check out Confio Ignite (blog entry, Charlie Arehart, 2008)
Oracle-specific DB Troubleshooting Resources
- Coldfusion and Oracle 8i Performance (blog entry, Mark Kruger, 2008)
- Having problems with SQL Server/Oracle/DB2/Sybase? Check out Confio Ignite (blog entry, Charlie Arehart, 2008)
MS Access-specific DB Troubleshooting Resources
- Access on 64bit ColdFusion? Yes we Can!! (blog entry, Mark Kruger, 2010)
Related Wiki Pages
See also: