Monday, September 21, 2009

Upcoming SQL Lunch (Live Meeting) – Historical DMV Information

The next SQL Lunch is scheduled for Monday, September 28.  See below for details

Date: 9/28/2009

Time: 11:30 AM

Meeting URL:

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:  Also, if you would like to speak at a SQL Lunch please email me at  Remember these are short meetings designed to help new speakers improve their skills.

Talk to you soon

Patrick LeBlanc, founder SQL Lunch and

SQL Down South

No comments:

Post a Comment