Christina E. Leo
Christina Leo has been working in the information technology industry since 1998. She began her career in the I.T. world as a VB6 developer and has been working almost exclusively with SQL Server for the past three years. A puzzle solver, by nature, her favorite part of database work is performance tuning.
She works as a database developer for ProfitStars, a Jack Henry Company, supporting three development teams that create software for the banking industry.
She actively participates in the SQL Server community, is part of the leadership team for the Nashville SQL Server User Group in the United States, volunteers with PASS (Professional Association for SQL Server), and holds a double MCITP for SQL Server 2005 in Development and Administration.
Sessions
Learn to create and customise TSQL scripts for capturing SQL Profiler data in a server side trace. Examine methods for stopping, starting and storing these traces, and finally look at free tools available for analysing the captured data.
In this session, we'll examine the query plan cache to see what plans are saved, what plans are reused, when plans are recreated, methods for observing the contents of the plan cache, and finally,
methods for manipulating plan reuse and recreation.