Join us this moth with our speaker Carlos Chacon.
Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings. This information is available via Dynamic Management View and functions and officially they "return internal, implementation-specific state data." This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment. We also open up the floor for ideas of how you are using these views/functions.
In addition to being the regional mentor for the Pittsburgh SQL Server USers Group, Carlos Chacon is the managing partner of SQL Data Partners LLC a business dedicated to helping companies feel more secure about their SQL Server environments. A regular community speaker, he brings a very conversational approach to his sessions. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia and is the host of the SQL Data Partners Podcast.