Programming, SQL Server, SQL Server Sri Lanka User Group, SS SLUG

SS SLUG Kaleidoscope – January 2012 Action

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.

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
  • Classification

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.

  1. Internal resource pool and Internal workload group
  2. 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 πŸ˜‰

Advertisements