The next SQL Lunch is scheduled for Monday, September 28. See below for details
Time: 11:30 AM
Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and even some .Net(C#). Designing and developing normalized databases has become his passion. Full-time DBA work started about 8 years ago for Thomas while working at a Paper Mill in St. Francisville, LA continuing with IEM, then Amedisys. Current activity at Amedisys involves 4 other DBAs
Topic: Historical DMV Information
DMV are great to find information about performance without running a trace. But there information is lost once the SQL Server service is restarted. After finding some useful scripts online (Thanks SQL Server community!!!) , I decided to schedule a job to run the night before to store Index Usage, Least Used Indexes, SP Usage, Missing Index and Expensive CPU Usage. We will review the scripts and historical data captured.
As always, if you would like to receive notifications about upcoming SQL Lunch Live Meetings please register here: http://www.tsqlscripts.com/sqllunch.aspx. Also, if you would like to speak at a SQL Lunch please email me at firstname.lastname@example.org. Remember these are short meetings designed to help new speakers improve their skills.
Talk to you soon
Patrick LeBlanc, founder SQL Lunch and TSQLScripts.com
SQL Down South