Welcome to Chi-SSUG!

Please click here for general group information.  Also follow us on twitter at @ChiSQL or our hashtag #ChiSQL.  We look forward to seeing you at our next meeting!



What is causing my database to grow?



Thursday, July 9th, 2015 @ 5:30 PM
(You must RSVP by 9:00 AM, the Wednesday prior to the meeting to attend)



Microsoft Technology Center, 200 East Randolph Drive, Suite 200 Chicago, IL 60601



Jared Karney



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 has been a SQL Server DBA since 2007 and was a Business Analyst and SQL Developer before that. He recently joined Coyote Logistics as a Sr. SQL Server DBA. His interests include performance tuning, automation, and overall architecture.




Availability Groups versus Clustered Instances of SQL Server

Availability Groups versus Clustered Instances of SQL Server