R Meyyappan is a SQL Server specialist with expertise in Performance Tuning. Ramesh worked at Microsoft Corporation from 1994 to 2004. Nearly half of that time he worked in Redmond in the development teams - specifically as Program Manager in the SQL Server Development Team responsible for optimizing SQL Server product for SAP.
Ramesh now offers onsite and offsite consulting and workshops independently as well as by partnering with various Microsoft Subsidiaries.
Ramesh has delivered the "3 Day Level 400 Microsoft SQL Server 2008 / 2005 Performance Monitoring & Tuning” Workshop in various countries in Europe including for Microsoft Austria / Microsoft Austria TechNet, Microsoft Belgium, Microsoft Czech Republic, Microsoft Denmark, Finland / Microsoft Finland TechNet, Microsoft Germany, Microsoft Netherlands, Microsoft Norway, Microsoft Poland, Microsoft Russia, Microsoft Slovakia, Microsoft Slovenia, Microsoft Sweden, Microsoft Switzerland and United Kingdom / Microsoft UK TechNet.
Best Practice Guidelines for optimal performance while using the new SQL Server 2008 features: Filtered Index/Statistics, Resource Governor, Row Compression , Page Compression, Server Configuration Option: 'optimize for ad hoc workloads', Plan Freezing, Table-Valued Parameters, Disabling Table Lock Escalation, Transparent Data Encryption and more.
In this session we will analyze and resolve a real world SQL Server Performance issue. We will first identify a customer’s query performance issue and understand the reason for the non optimal performance of their application. After understanding the limitations it will of course be natural to invent and perform non TCO increasing magic to make SQL Server really fly. We will also provide few words of caution for those who might abuse the newly acquired magical powers.
This deep dive, no fancy power point show is equally designed for developers and administrators. If you are one of those who would rather perform the magic on your own laptop than just observe it being demonstrated, send me an email so I can send you the demo scripts to prepare yourself for the adventure.
In this session with examples we will cover how to identify inefficiencies in parallel query execution. We will also investigate some invisible symptoms!
Keywords: MAXDOP, CXPACKET, SLEEP_TASK & SOS_SCHEDULER_YIELD.
I don’t have a quad core laptop yet, so I will do the best with my dual core!
With examples we will discuss tips and tricks that will be useful for Developers, DBAs and Consultants.
In this session with examples we will continue to cover how to identify inefficiencies in parallel query execution.
Part I was presented during SQLBits VI in London, if you missed it, view the Webcasts @ http://webcast.sqlworkshops.com.
In this session we will discuss ways to maximize existing hardware utilization to speed up queries. We will analyze cases of performance issue and tune them for better CPU, Storage and Memory utilization resulting in higher performance and lower TCO.