Guys,
I am sure we all are aware of www.SQLWORKSHOPS.com and Mr. R Meyyappan.
SQL Bits VI recorded sessions are available at: http://www.sqlbits.com/information/event6/PublicSessions.aspx and we especially recommend you to watch 'Performance Monitoring & Tuning - Documented Tips & Tricks', the content is not part of our previous webcasts.
Monitoring and Tuning Parallel Query Execution: http://videos.sqlbits.com/event6/Monitoring%20and%20Tuning%20Parallel%20Query%20Execution_w.wmv
Performance Monitoring and Tuning - Documented Tips and Tricks: http://videos.sqlbits.com/event6/Performance%20Monitoring%20and%20Tuning_w.wmv
All my past SQL Bits sessions are available at: http://www.sqlbits.com/Speakers/R_Meyyappan/Default.aspx
These are very helpful sessions, please spare some time and watch the same.
Happy SQL Coding.
Sudhir
Friday, October 29, 2010
Friday, October 22, 2010
Southeast Asia SharePoint Conference 2010
Event Name: Southeast Asia SharePoint Conference 2010
Location: Waterfront Conference Centre at Grand Copthorne
392 Havelock Road, Singapore - 169663
+65 6733 0880
Event Date: 26th & 27th Oct 2010
Keynote Announced! - Join Mike Fitzmaurice to hear about "The Evolution of SharePoint from Two Pet Projects to a Multi-Company Ecosystem"
Organiser: The Southeast Asia SharePoint Conference is organised by a group of dedicated SharePoint MVPs and Community Leaders from the Asia Pacific Region who participate and support the community through organising and sharing their knowledge at user group events.
How did SharePoint start and how did it become the centre of the universe in under a decade? Mike Fitzmaurice was there at the beginning, has worked on every product with the word “SharePoint” in it, and continues to work on SharePoint technology today, in a former position for Microsoft and now for a SharePoint partner ISV. He will share with you the motivations behind SharePoint’s creation and evolution, the realities behind how the products ship, why SharePoint caught on so completely, and how SharePoint has grown into something far beyond a single product from a single company.
Fees: Regular Registration fee is $SGD400.00.
This is is the conference to learn about SharePoint 2010 with expert local and international speakers presenting on topics that will help you understand and succeed with your SharePoint implementations and add real value to your organisation and businesses.
In addition to the session content you'll have ample opportunities to network with your peers in the community and technical and industry experts including local and international Microsoft Most Valued Professionals and Southeast Asia's top Certified Partners.
The wider Southeast Asian SharePoint Community (MVPs, User Group Leaders, Partners and Customers) are also valued contributors to the event.
The SharePoint Conference is intended for a wide audience and has content to cover roles such as:
Business Roles like End Users, Business Champions, Power Users and Business Managers
Information Architects, Record and Information Managers IT Managers, CIO and Decision Makers
Technical Roles including Developers, IT Pro, Systems Administration and DBA's Microsoft
Technologies covered during the conference include:
SharePoint Foundation 2010 SharePoint Server 2010
SharePoint Designer 2010
Integration with Microsoft Office, InfoPath, Excel, Access and Visio
Integration with 3rd Party products enhancing SharePoint functionality
Hope you can attend this.
Enjoy
Sudhir
Location: Waterfront Conference Centre at Grand Copthorne
392 Havelock Road, Singapore - 169663
+65 6733 0880
Event Date: 26th & 27th Oct 2010
Keynote Announced! - Join Mike Fitzmaurice to hear about "The Evolution of SharePoint from Two Pet Projects to a Multi-Company Ecosystem"
Organiser: The Southeast Asia SharePoint Conference is organised by a group of dedicated SharePoint MVPs and Community Leaders from the Asia Pacific Region who participate and support the community through organising and sharing their knowledge at user group events.
How did SharePoint start and how did it become the centre of the universe in under a decade? Mike Fitzmaurice was there at the beginning, has worked on every product with the word “SharePoint” in it, and continues to work on SharePoint technology today, in a former position for Microsoft and now for a SharePoint partner ISV. He will share with you the motivations behind SharePoint’s creation and evolution, the realities behind how the products ship, why SharePoint caught on so completely, and how SharePoint has grown into something far beyond a single product from a single company.
Fees: Regular Registration fee is $SGD400.00.
This is is the conference to learn about SharePoint 2010 with expert local and international speakers presenting on topics that will help you understand and succeed with your SharePoint implementations and add real value to your organisation and businesses.
In addition to the session content you'll have ample opportunities to network with your peers in the community and technical and industry experts including local and international Microsoft Most Valued Professionals and Southeast Asia's top Certified Partners.
The wider Southeast Asian SharePoint Community (MVPs, User Group Leaders, Partners and Customers) are also valued contributors to the event.
The SharePoint Conference is intended for a wide audience and has content to cover roles such as:
Technologies covered during the conference include:
Hope you can attend this.
Enjoy
Sudhir
7 Free .NET Development and Architecture E-books »
Guys,
Here are some links to download Free .Net Development and Architecure E-books.
Foundations Of Programming: The Foundation Of Programming Series Free e-book By Karl Seguin is one of the best book. It is simple, short and sweet. It gives a better thought process – that’ll definitely enable to code better and think better. This book covers the ALT.NET Philosophy, Domain Driven Development concepts, DI, TDD etc in a nice way. Download it
Microsoft Application Architecture Guide, 2nd Edition: An essential read for any Microsoft.NET developer or Architect to understand the underlying architecture and design principles and patterns for developing successful solutions on the Microsoft platform and the .NET Framework. This guide neatly covers popular architecture patterns, best practices and common challenges you need to understand for developing .NET applications. Get a good grip on developing enterprise applications in .NET. Download it
Rob Miles C# Yellow Book 2010: A nice action packed book that takes you through C# and .NET concepts. This book explains C# language and .NET library in general – with a clear focus on implementation thought process and best practices.
Rob Miles CSharp Yellow Book 2008.pdf
Rob Miles CSharp Yellow Book 2009.pdf
Rob Miles CSharp Yellow Book 2010.pdf
Threading in C#: A short, neatly written book from Joe Albahari about Threading in C#. This is a must read for any .NET programmer to understand more about threading in general, thread pooling, synchronization, Non blocking synchronization, etc. In this book, Joe even covers the Parallel Framework Extensions and Parallel programming in .NET.
http://www.albahari.com/threading/threading.pdf
Improving .NET Application Performance and Scalability: Microsoft guide, which focuses on designing your applications with Performance and scalability in mind. It has sections relevant to architects, developers, testers, and administrators. Following the checklists and guidance in this book will ensure that there won’t be any unpleasant surprises in the end. Read this guide if you develop Enterprise applications in .NET.
Download it
Applying Design Patterns: A quick introduction towards the thought process of applying design patterns. The objective of the book is to introduce design patterns in a simple way, so that developers can understand some common patterns and how to apply them.
http://amazedsaint.net/patterns.pdf
RefCardz from DZone: DZone has a number of awesome Quick reference sheets on various technologies. Registration is required to get these reference sheets.
Getting started with WCF 4.0
Getting Started With Silverlight + Expression Blend
Essential F#
Enjoy & Happy Coding
Sudhir
Here are some links to download Free .Net Development and Architecure E-books.
Foundations Of Programming: The Foundation Of Programming Series Free e-book By Karl Seguin is one of the best book. It is simple, short and sweet. It gives a better thought process – that’ll definitely enable to code better and think better. This book covers the ALT.NET Philosophy, Domain Driven Development concepts, DI, TDD etc in a nice way. Download it
Microsoft Application Architecture Guide, 2nd Edition: An essential read for any Microsoft.NET developer or Architect to understand the underlying architecture and design principles and patterns for developing successful solutions on the Microsoft platform and the .NET Framework. This guide neatly covers popular architecture patterns, best practices and common challenges you need to understand for developing .NET applications. Get a good grip on developing enterprise applications in .NET. Download it
Rob Miles C# Yellow Book 2010: A nice action packed book that takes you through C# and .NET concepts. This book explains C# language and .NET library in general – with a clear focus on implementation thought process and best practices.
Rob Miles CSharp Yellow Book 2008.pdf
Rob Miles CSharp Yellow Book 2009.pdf
Rob Miles CSharp Yellow Book 2010.pdf
Threading in C#: A short, neatly written book from Joe Albahari about Threading in C#. This is a must read for any .NET programmer to understand more about threading in general, thread pooling, synchronization, Non blocking synchronization, etc. In this book, Joe even covers the Parallel Framework Extensions and Parallel programming in .NET.
http://www.albahari.com/threading/threading.pdf
Improving .NET Application Performance and Scalability: Microsoft guide, which focuses on designing your applications with Performance and scalability in mind. It has sections relevant to architects, developers, testers, and administrators. Following the checklists and guidance in this book will ensure that there won’t be any unpleasant surprises in the end. Read this guide if you develop Enterprise applications in .NET.
Download it
Applying Design Patterns: A quick introduction towards the thought process of applying design patterns. The objective of the book is to introduce design patterns in a simple way, so that developers can understand some common patterns and how to apply them.
http://amazedsaint.net/patterns.pdf
RefCardz from DZone: DZone has a number of awesome Quick reference sheets on various technologies. Registration is required to get these reference sheets.
Getting started with WCF 4.0
Getting Started With Silverlight + Expression Blend
Essential F#
Enjoy & Happy Coding
Sudhir
Thursday, September 2, 2010
Register for Level 300-400 Microsoft SQL Server 2008 Performance Monitoring and Tuning Seminar
Hello Friends,
SQLWORKSHOP is organizing a free Level 300-400 Microsoft SQL Server 2008 Performance Monitoring and Tuning Seminar on Sept 9th.
Click here to register for the Seminar.
Event Overview
Registration as of 08:30h, Start of Seminar 09:00h, End 16:15h.
Goal of the Seminar: To provide the database developers and administrators with knowledge on how to monitor and tune performance of Microsoft SQL Server 2008 and SQL Server 2005. The seminar addresses CPU, Memory, Disk, Query and Lock monitoring and tuning techniques.
Target Group
Developers, Database Administrators and Database Architects. This seminar is equally designed for application developers and database administrators.
Prerequisite
Some experience administering or developing applications with SQL Server.
Instructor
Ramesh Meyyappan (www.sqlworkshops.com) with more than 15 years of SQL Server expertise including working in the past as a Program Manager in the SQL Server Development Team at Microsoft Corporation. He is specialized in SQL Server Performance Monitoring, Tuning & Troubleshooting and SQL Server Administration and Tuning for SAP installations.
Agenda
08.30 – 09.00 Registration
09.00 – 10.15 Monitoring and Tuning Queries and Configuration to better utilize CPU, Memory and Disk and to reduce Total Cost of Ownership
10.15 – 10.45 Break
10.45 – 12.00 Monitoring and Tuning Queries and Configuration to better utilize CPU, Memory and Disk and to reduce Total Cost of Ownership
12.00 – 13.00 Lunch
13.00 – 14.15 Monitoring and Tuning Query Execution and Locking issues
14.15 - 14.45 Break
14.45 – 16.00 Monitoring and Tuning Query Execution and Locking issues
16.00 – 16:15 Q and A
Happy Coding
Sudhir
SQLWORKSHOP is organizing a free Level 300-400 Microsoft SQL Server 2008 Performance Monitoring and Tuning Seminar on Sept 9th.
Click here to register for the Seminar.
Event Overview
Registration as of 08:30h, Start of Seminar 09:00h, End 16:15h.
Goal of the Seminar: To provide the database developers and administrators with knowledge on how to monitor and tune performance of Microsoft SQL Server 2008 and SQL Server 2005. The seminar addresses CPU, Memory, Disk, Query and Lock monitoring and tuning techniques.
Target Group
Developers, Database Administrators and Database Architects. This seminar is equally designed for application developers and database administrators.
Prerequisite
Some experience administering or developing applications with SQL Server.
Instructor
Ramesh Meyyappan (www.sqlworkshops.com) with more than 15 years of SQL Server expertise including working in the past as a Program Manager in the SQL Server Development Team at Microsoft Corporation. He is specialized in SQL Server Performance Monitoring, Tuning & Troubleshooting and SQL Server Administration and Tuning for SAP installations.
Agenda
08.30 – 09.00 Registration
09.00 – 10.15 Monitoring and Tuning Queries and Configuration to better utilize CPU, Memory and Disk and to reduce Total Cost of Ownership
10.15 – 10.45 Break
10.45 – 12.00 Monitoring and Tuning Queries and Configuration to better utilize CPU, Memory and Disk and to reduce Total Cost of Ownership
12.00 – 13.00 Lunch
13.00 – 14.15 Monitoring and Tuning Query Execution and Locking issues
14.15 - 14.45 Break
14.45 – 16.00 Monitoring and Tuning Query Execution and Locking issues
16.00 – 16:15 Q and A
Happy Coding
Sudhir
Level 400 Performance Monitoring and Tuning Webcast
Hello,
Recently SQLWORKSHOPS organized Level 400 Performance Monitoring and Tuning Webcast. Here is the link to download the webcast.
The agenda for the Webcast is:
Webcast 1: Explains Memory allocation issues with sort. Demonstrates ways to identify sort spills to tempdb. Provides query rewrite procedure to avoid sort spills to tempdb. Demonstrates cases where 1 tempdb date file per core might not be ideal for all implementations.
Webcast 2: Explains high CXPACKET waits are NOT a direct result of delays associated with inefficiencies of parallel processing. Provides example to scale queries over many CPU cores without reducing MAXDOP settings.
Webcast 3: Recommends not using stored procedure or other plan caching mechanism like using sp_executesql and Prepared Statement using ADO.NET or OLEDB based executions for memory allocating queries. Common memory allocating queries are that perform Sort and do Hash Match operations like Hash Join or Hash Aggregation or Hash Union.
With examples provides ways to identify queries performing Hash match operations that spill to tempdb. Using SQL Profiler: Hash Warnings (Hash Recursion and Hash Bailout). Using sys.dm_exec_query_memory_grants: Granted Memory, Used Memory and Maximum Used memory. Explains how SLEEP_TASK wait type is associated with Hash Warnings.
Explains with examples how sp_recompile can block and bring an application to a standstill and recommends using DBCC FREEPROCCACHE (plan_handle) instead.
Explains with examples how stored procedure or other plan caching mechanism affects queries that sort (perform order by). Explains how IO_COMPLETION wait type is associated with Sort Warnings.
Demonstrates why rollbacks and database restore could wait on IO_COMPLETION wait type and if needed how this wait can be reduced.
Explains how parallel query performance is significantly affected by a CPU intensive query executing on one of the CPU cores. Explains the reason for the performance issue and how to identify the issue with SLEEP_TASK wait type. With example explains the reason for the observed query execution time when the child thread executes on the CPU core where the CPU intensive query executes and also when the coordinator executes on the CPU core where the CPU intensive query executes. Recommends ways to avoid this parallel sort query performance issue and also demonstrates that only certain queries will be affected by this and not all parallel queries.
Explains sys.dm_os_waits_stats.signal_wait_time_ms does not indicate system wide CPU pressure, just at a CPU core level.
Explains the prefetch mechanism and how it can affect query performance. Provides ways to force prefecth. Demonstrates cases where Avg. Disk Sec / read, the disk latency, PAGEIOLATCH_SH, Avg. disk queue length is very high and the query executes fast.
Explains why Plan Guides (Plan Freezing!) cannot help with prefetch or in few other cases.
The Goal of these webcasts is to help reduce Total Cost of Ownership (TCO), by efficiently utilizing existing investment.
Do let me know if you face any problem downloading the files.
Happy Coding
Sudhir
Recently SQLWORKSHOPS organized Level 400 Performance Monitoring and Tuning Webcast. Here is the link to download the webcast.
The agenda for the Webcast is:
Webcast 1: Explains Memory allocation issues with sort. Demonstrates ways to identify sort spills to tempdb. Provides query rewrite procedure to avoid sort spills to tempdb. Demonstrates cases where 1 tempdb date file per core might not be ideal for all implementations.
Webcast 2: Explains high CXPACKET waits are NOT a direct result of delays associated with inefficiencies of parallel processing. Provides example to scale queries over many CPU cores without reducing MAXDOP settings.
Webcast 3: Recommends not using stored procedure or other plan caching mechanism like using sp_executesql and Prepared Statement using ADO.NET or OLEDB based executions for memory allocating queries. Common memory allocating queries are that perform Sort and do Hash Match operations like Hash Join or Hash Aggregation or Hash Union.
With examples provides ways to identify queries performing Hash match operations that spill to tempdb. Using SQL Profiler: Hash Warnings (Hash Recursion and Hash Bailout). Using sys.dm_exec_query_memory_grants: Granted Memory, Used Memory and Maximum Used memory. Explains how SLEEP_TASK wait type is associated with Hash Warnings.
Explains with examples how sp_recompile can block and bring an application to a standstill and recommends using DBCC FREEPROCCACHE (plan_handle) instead.
Explains with examples how stored procedure or other plan caching mechanism affects queries that sort (perform order by). Explains how IO_COMPLETION wait type is associated with Sort Warnings.
Demonstrates why rollbacks and database restore could wait on IO_COMPLETION wait type and if needed how this wait can be reduced.
Explains how parallel query performance is significantly affected by a CPU intensive query executing on one of the CPU cores. Explains the reason for the performance issue and how to identify the issue with SLEEP_TASK wait type. With example explains the reason for the observed query execution time when the child thread executes on the CPU core where the CPU intensive query executes and also when the coordinator executes on the CPU core where the CPU intensive query executes. Recommends ways to avoid this parallel sort query performance issue and also demonstrates that only certain queries will be affected by this and not all parallel queries.
Explains sys.dm_os_waits_stats.signal_wait_time_ms does not indicate system wide CPU pressure, just at a CPU core level.
Explains the prefetch mechanism and how it can affect query performance. Provides ways to force prefecth. Demonstrates cases where Avg. Disk Sec / read, the disk latency, PAGEIOLATCH_SH, Avg. disk queue length is very high and the query executes fast.
Explains why Plan Guides (Plan Freezing!) cannot help with prefetch or in few other cases.
The Goal of these webcasts is to help reduce Total Cost of Ownership (TCO), by efficiently utilizing existing investment.
Do let me know if you face any problem downloading the files.
Happy Coding
Sudhir
Subscribe to:
Posts (Atom)
