(605) SQL Server User Group

Meeting: Tue, Mar 08 2016

Tips and Tricks for Performance Troubleshooting

“The application is too slow”...”reports are taking too long to load”…“my queries are running slow”. These are complaints we have all heard from our end users, and as we know, it is always the database that is the issue. In this session we will talk about different things to look for when assessing performance of queries. We will examine execution plans to see where problems may lie. We will talk about indexes and statistics – what are they, what to index, and how they can help query performance. We will also look at some few different “gotchas” that can affect query performance.

When:

Tue, Mar 08 2016 Event Time: 17:30 - 19:00 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Tue, Mar 08 2016 23:30 - 01:00
iCal


RSVP: https://www.surveymonkey.com/r/9MF2R6M


Where:

2300 W 57th St - Sioux Falls, South Dakota (map)

None



Featured Presentation

Tips and Tricks for Performance Troubleshooting

Speaker: Phillip Podhradsky, DBA\Data Architect First Bank & Trust

Summary: “The application is too slow”...”reports are taking too long to load”…“my queries are running slow”. These are complaints we have all heard from our end users, and as we know, it is always the database that is the issue. In this session we will talk about different things to look for when assessing performance of queries. We will examine execution plans to see where problems may lie. We will talk about indexes and statistics – what are they, what to index, and how they can help query performance. We will also look at some few different “gotchas” that can affect query performance.

 

About Phillip: SQL Server DBA at Fishback Financial Corporation. Phil has 8 years of experience with SSRS, SSAS, SSIS, and the SQL server database engine from SQL 2005 to SQL 2012. He started his career as a report writer and has been in a database role for about 7 years. Some of Phil’s main focuses in his current position are to troubleshoot performance issues, make sure backups are in place and working correctly, and support various application development initiatives.


Back to Top cage-aids
cage-aids
cage-aids
cage-aids