Chicago Suburban SQL Server User Group

MEMBERSHIP

If you have not done so already, please register on PASS.  Then update your PASS Profile & Join our Chapter there. All future mailings will be sent out via your SQLPass account:

http://www.sqlpass.org/PASSChapters/LocalChapters.aspx

Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

Next Meeting

Tuesday,

July

21

ChiSub SSUG July Meeting

  • In-Person @ 3005 Highland Parkway #100 Downers Grove, Illinois, United States (map)
  • 17:30 - 20:00 Central Daylight Time
  • Language: English

TOPIC:  What is Causing My Database to Grow?


ABSTRACT:
Have you ever received a call that an application is throwing errors about the database being out of space? This session will help you learn how to proactively deal with those calls! Sometimes it isn’t practical to limit the growth of our databases.  As DBAs, it is our responsibility to make sure that we know the disk space that is used and free, the size of our databases, when they grew, and why they grew so that we can prepare for it or reduce it. We can also track the size and growth over time to be able to predict future trends.

In this beginner session, Jared Karney will show you how you can track the size of your disks, databases, and database files using DMVs. He will show you how to structure tables and indexes for storing this data, demonstrate the Extended Events to track when a data or log file grows and what caused the growth to occur, and how you can automate the whole process using SQL Agent.
 

AGENDA:
5:30PM - Doors Open
6:00PM - Meeting Start. Announcements.
6:15PM - Dinner w. Networking/Open Q&A (bring your questions!)
6:45PM - Main Presentation

Featured Presentation:

What is Causing My Database to Grow?

Have you ever received a call that an application is throwing errors about the database being out of space? This session will help you learn how to proactively deal with those calls! Sometimes it isn’t practical to limit the growth of our databases. As DBAs, it is our responsibility to make sure that we know the disk space that is used and free, the size of our databases, when they grew, and why they grew so that we can prepare for it or reduce it. We can also track the size and growth over time to be able to predict future trends. In this beginner session, Jared Karney will show you how you can track the size of your disks, databases, and database files using DMVs. He will show you how to structure tables and indexes for storing this data, demonstrate the Extended Events to track when a data or log file grows and what caused the growth to occur, and how you can automate the whole process using SQL Agent.

Jared Karney, PFE Microsoft

About Jared:
Jared Karney has been a SQL Server DBA since 2007 and was a Business Analyst and SQL Developer before that. He currently works as a Premier Field Engineer for Microsoft. His interests include performance tuning, automation, internals, and overall architecture.

REGISTER:

https://www.eventbrite.com/e/chicago-suburban-ssug-july-2015-meeting-tickets-17675840916




PASSChapterLogo100.jpg


sql_micro_sm.gif







Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: 
chisuburbanssug@sqlpass.org

 

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