After celebrating the success of the last October meet up for two months, the first SS SLUG meet up for 2012 was held on the 18th. Last meet up had a significant turn out, where the place seemed too small to accommodate the attendees. But disappointingly, this time there was a lesser crowd.
Getting down to real business, the meet up was lined up with two sessions.
- Session 1 – Using Resource Governor to Manage workload and resources by Dinesh Asanka (MVP)
- Session 2 – Eliminating roundtrips: MERGE and the TABLE data type by Dinesh Priyankara (MVP)
Before hitting off with his session, Dinesh A. mentioned that the content of his presentation was taken from msdn. According to which, Resource Governor, is a feature available in SQL Server, where it allows you to set limits on the resource consumption of SQL Server workloads and in turn help you manage your workload. Then he elaborated on the main concepts of Resource Governor,
- Resource Pools
- Workload Groups
What was to be noted was the mentioning of the creation of two resource pools and mapping of workload groups when SQL Server is installed.
- Internal resource pool and Internal workload group
- Default resource pool and Default workload group
The interesting part is that, the Internal group and resource pool act as the highly privileged or reserved. You cannot or should not try to modify it, because the basic commands are specified for those and are not accessible for modifications. The session ended with a comprehensive demo of how to assign a maximum and minimum CPU usage percentage for an SQL Server workload and there by monitor the CPU usage as well.
Next on stage was Dinesh P. whose session was a bit overhead for a newbie like me, but still was worthwhile for those who are well grounded in the arena. Initially he planned of getting an audience involvement by starting off an open discussion on what everyone has done to eliminate round trips. But as usual it took a fortune to get the people talking 🙂 Moving on, he spoke of the various difficulties faced and then came to the point on how to solve the issue. What I picked up was, which I wasn’t aware of, a data type called the “Table Data Type“. Dinesh did a demo on how to use the data type and Merge technique to eliminate roundtrips.
Overall rating of the session was GOOD 🙂 Am I looking forward for the next meet up?? YES, let’s see what they’ve got next time 😉
- SQL Server 2008 For Developers (slideshare.net)