Requesting your input on Resource Governor
I am writing a whitepaper, and planning more presentations, on using Resource Governor in SQL Server 2008, and am looking for your feedback on making both of these more complete and relevant to real-world implementations — since 99% of my usage of the feature so far has been mostly academic. So, I have some questions I'd like you to consider.
Are you using Resource Governor today? Are you planning to use it in the near future? If you answer yes to either question, can you provide some details about how you are going to use it (beyond the Resource Governor de facto mission statement)? If you answer no to both questions, can you explain why? And yes, it's okay to say, Enterprise Edition costs too much, or you have no short-term plans to upgrade to 2008 regardless of edition. 🙂
Whether or not you are using or planning to use Resource Governor, you might still be able to help me. If you are familiar with Resource Governor, do you have any outstanding questions about the feature, things you don't understand or specific items that aren't covered by the documentation? Did you stumble across any cool factoids or potential gotchas while using the feature that you would not have learned about in Books Online?
If you have interesting answers to any of the above questions, I'd love to hear about them. And if you don't feel comfortable posting here, you can e-mail me privately at aaron.bertrand @ gmail.
Thanks in advance; I am looking forward to reading about your opinions and experiences.