11/04/2010 9:44:03 PM
Having a well planned monitoring & benchmarking strategy is crucial for sustaining high levels of SQL Server performance and trouble-shooting problems when they arise.
If you haven't measured what level of query activity & resource consumption is considered "normal" for your application, you can only guess when your system is operating outside of expected performance parameters (translated: "we're just waiting for users to complain!").
Without this crucial information, trouble-shooting efforts are hampered by inability to measure what has "changed". Capacity estimation & measuring consolidation requirements are also essentially reduced to guesswork.
In this session, Greg Linwood discusses which metrics you should collect and practical methods to go about collecting + storing + reporting on them. The impact of monitoring will also be discussed, including how to minimise this whilst balancing the need to collect crucial performance KPIs.
Greg Linwood is the Managing Director of MyDBA - a dedicated SQL Server support & consulting business. Greg has worked in a range of developer & DBA capacities with SQL Server since 1993 and was the first Australian to receive Microsoft's SQL Server MVP award in 2003. He has gained significant expertise in SQL Server tuning and most of his professional time is currently spent tuning customer SQL Server systems. Greg is passionate about building high quality SQL Server community events in Australia and is one of the founders of the Australian SQL Server User Group, leading the Melbourne SQL Server User Group.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:45pm finish |
On: Tuesday, 20 April 2010