Geek Speak: Debugging and Tweaking Week (Part 4 of 5): How Optimized is Your Data? - Follow - U
Debugging and Tweaking Week (Part 4 of 5): How Optimized is Your Data?
Registration: https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032267713&Culture=en-US
Abstract:
This session examines proven strategies to help you design and develop scalable data access solutions. Learn valuable techniques you can use to optimize stored procedure calls, reduce dataset serialization cost, manage transactions, and page through large result sets. We will also demonstrate effective ways to improve the performance and scalability of SQL Server
WebCast Slides: Click Here
Resources
Code: Click Here
Patterns and Practices Guidance
Articles
- ADO Performance Best Practices
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/BestPrac.asp - How To: Use SQL Profiler
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto15.asp - Performance Comparison: Security Design Choices
https://msdn.microsoft.com/library/en-us/dnbda/html/bdadotnetarch15.asp - PRB: ThreadAbortException Occurs If You Use Response.End, Response.Redirect, or Server.Transfer
https://support.microsoft.com/default.aspx?scid=kb;en-us;312629 - PRB: Contention, Poor Performance, and Deadlocks When You Make Web Service Requests from ASP.NET Applications
https://support.microsoft.com/default.aspx?scid=kb;en-us;821268 - How To: Use CLR Profiler
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto13.asp - HOW TO: Use Base Classes to Reduce Code Forking with Managed Providers in Visual C# .NET
https://support.microsoft.com/default.aspx?scid=kb;en-us;313304 - Building Secure ASP.NET Applications: Authentication, Authorization and Secure Communication
https://msdn.microsoft.com/library/en-us/dnnetsec/html/SecNetch03.asp - INFO: Roadmap for .NET Data Providers
https://support.microsoft.com/default.aspx?scid=kb;en-us;313480 - Connection Pooling for the .NET Framework Data Provider for SQL Server" in .NET Framework Developer's Guide
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconConnectionPoolingForSQLServerNETDataProvider.asp - HOW TO: Handle Multiple Results by Using the DataReader in Visual C# .NET
https://support.microsoft.com/default.aspx?scid=kb;en-us;311274 - Obtaining BLOB Values from a Database" in .NET Framework Developer's Guide
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconobtainingblobvaluesfromdatabase.asp - Stored Procedure and Trigger Execution" in Microsoft SQL Server 2000: SQL Server Architecture
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_7cmm.asp - INF: Troubleshooting Stored Procedure Recompilation
https://support.microsoft.com/default.aspx?scid=kb;en-us;243586 - Query Recompilation in SQL Server 2000
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_queryrecompilation.asp - Optimistic Concurrency
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconOptimisticConcurrency.asp - HOW TO: Optimize SQL Indexes
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenethowto03.asp
Performance CheckList
- ADO.NET
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenetcheck01.asp - ASP.NET
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenetcheck03.asp - Managed Code
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenetcheck06.asp - SQL Server
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag/html/scalenetcheck08.asp