sql-speed.com
SQL Server Performance Tuning: ASPNet SessionDB Problem with LCK_M_U locks and Excessive Calls to TempGetStateItemExclusive3
http://www.sql-speed.com/2010/01/aspnet-sessiondb-problem-with-lckmu_27.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Wednesday, January 27, 2010. ASPNet SessionDB Problem with LCK M U locks and Excessive Calls to TempGetStateItemExclusive3. Attempts to Google for the issue would almost always lead to articles that addressed the DeleteExpiredSessions stored proc. In this case, however, all indications where that DeleteExpiredSessions was not contibuting to this problem. A coworker pointed out this MSDN blog entry. LCK M U lock.
sql-speed.com
SQL Server Performance Tuning: August 2010
http://www.sql-speed.com/2010_08_01_archive.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Monday, August 16, 2010. Sql handle vs. plan handle. The terms sql handle and plan handle appear throughout the documentation for the SQL Server Data Management Views (DMVs). It may help to understand how they are created and the relationship between them. Dm exec query stats. Dm exec sql text. This results in one sql handle (click image to enlarge):. Dm exec query stats. Dm exec sql text. Dm exec plan attributes.
sql-speed.com
SQL Server Performance Tuning: New website
http://www.sql-speed.com/2010/03/new-website.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Friday, March 12, 2010. I have added a new website describing services I can provide in troubleshooting Sql Server performance issues: WoodworthConsulting.com. Subscribe to: Post Comments (Atom). Subscribe to RSS Feed. An IBM Trained and Certified DBA with 2 decades of experience optimizing databases and database applications. View my complete profile. ASPNet Session State Database. Dm exec plan attributes.
sql-speed.com
SQL Server Performance Tuning: Parameter Sniffing
http://www.sql-speed.com/2014/01/parameter-sniffing.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Tuesday, January 14, 2014. I've heard beginning developers say Parameter Sniffing is a bad thing. Quite the opposite. It is a critical part of SQL Server's Optimization Engine. I ran across another example today where a developer tripped up the Parameter Sniffing. I could have made the developer change the calling code to pass companyId instead of catalogId. As it turns out, there's an easier way. The rec...This ...
sql-speed.com
SQL Server Performance Tuning: Currently Executing SQL Queries
http://www.sql-speed.com/2009/11/currently-executing-sql-queries_11.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Wednesday, November 11, 2009. Currently Executing SQL Queries. Dm exec sql text. Labels: dm exec requests. Subscribe to: Post Comments (Atom). Subscribe to RSS Feed. An IBM Trained and Certified DBA with 2 decades of experience optimizing databases and database applications. View my complete profile. ASPNet Session State Database. Dm exec plan attributes. Dm exec query stats. LCK M U lock.
sql-speed.com
SQL Server Performance Tuning: Why Does SQL Server Management Studio Run Queries So Much Faster Than My Application
http://www.sql-speed.com/2009/12/why-does-sql-server-management-studio_07.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Monday, December 7, 2009. Why Does SQL Server Management Studio Run Queries So Much Faster Than My Application. As pointed out by Delaney, "Executing the same batches from these two different clients will result in multiple plans in cache" (Delaney 2008, p. 305). Executing the query for Kentucky from within Management Studio with different Set Options results in a new Query Plan, this time optimized for Kentucky.
sql-speed.com
SQL Server Performance Tuning: December 2009
http://www.sql-speed.com/2009_12_01_archive.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Monday, December 7, 2009. Why Does SQL Server Management Studio Run Queries So Much Faster Than My Application. As pointed out by Delaney, "Executing the same batches from these two different clients will result in multiple plans in cache" (Delaney 2008, p. 305). Executing the query for Kentucky from within Management Studio with different Set Options results in a new Query Plan, this time optimized for Kentucky.
sql-speed.com
SQL Server Performance Tuning: January 2010
http://www.sql-speed.com/2010_01_01_archive.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Wednesday, January 27, 2010. ASPNet SessionDB Problem with LCK M U locks and Excessive Calls to TempGetStateItemExclusive3. Attempts to Google for the issue would almost always lead to articles that addressed the DeleteExpiredSessions stored proc. In this case, however, all indications where that DeleteExpiredSessions was not contibuting to this problem. A coworker pointed out this MSDN blog entry. LCK M U lock.
sql-speed.com
SQL Server Performance Tuning: January 2014
http://www.sql-speed.com/2014_01_01_archive.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Tuesday, January 14, 2014. I've heard beginning developers say Parameter Sniffing is a bad thing. Quite the opposite. It is a critical part of SQL Server's Optimization Engine. I ran across another example today where a developer tripped up the Parameter Sniffing. I could have made the developer change the calling code to pass companyId instead of catalogId. As it turns out, there's an easier way. The rec...This ...
sql-speed.com
SQL Server Performance Tuning: March 2010
http://www.sql-speed.com/2010_03_01_archive.html
SQL Server Performance Tuning. Tips for diagnosing and fixing SQL Server performance issues. Friday, March 12, 2010. I have added a new website describing services I can provide in troubleshooting Sql Server performance issues: WoodworthConsulting.com. Subscribe to: Posts (Atom). Subscribe to RSS Feed. An IBM Trained and Certified DBA with 2 decades of experience optimizing databases and database applications. View my complete profile. ASPNet Session State Database. Dm exec plan attributes. LCK M U lock.