aspx Tutorial

.NET Articles,jQuery demo, asp.net with jQuery, online tutorial,Jquery, SilverLight, Javascript, asp.net,JSON, MVC,.NET Articles,demo, Web Services, .NET articles, Sharepoint 2010, visual studio 2010,Aamir Hasan,IT
Advertise Here

Advertize

wwwSW

Monitoring Resource Usage of MS SQL 2008

Posted by Aamir Hasan   on Friday, December 3, 2010 Total Views:  

In this example, i have told you how you can use to view and monitor your Resource Governor configuration
There are three dynamic management views are:

  1. sys.dm_resource_governor_workload_groups
  2. sys.dm_resource_governor_resource_pools
  3. sys.dm_resource_governor_configuration


sys.dm_resource_governor_workload_groups
This table provide you workload statistic with current in-memory configuration.

sys.dm_resource_governor_resource_pools
This table provide you current resource pools and statics pools

sys.dm_resource_governor_configuration
This table provide you in-memory configuration state.

Figure 1.1 shows the output.

Figure 1.1

Tags: , ,
Category: All | MS SQL | SQL 2008
Permalink | Comments (10)
nullAuthor: Aamir Hasan ...
Protected by Copyscape Online Plagiarism Tool

Comments (10) -

fretless bass guitar
fretless bass guitar United States
12/5/2010 1:49:18 PM #

In most cases I do not make a comment on blogs, but I have to say that this post really forced me to do so. Really nice post!

find server
find server United States
12/28/2010 11:29:07 PM #

Can you message me with a few hints & tips on how you made your blog look this awesome, I would be appreciative!

tv over internet
tv over internet United States
1/28/2011 2:13:34 AM #

Thanks a lot for giving everyone an extraordinarily pleasant opportunity to read critical reviews from this web site. It really is so awesome and jam-packed with a great time for me and my office acquaintances to visit the blog more than 3 times in one week to study the fresh stuff you have got. And definitely, I'm so actually fulfilled with your extraordinary pointers you serve. Some 3 tips in this article are ultimately the most impressive I've had.

china-nfl jerseys wholesale
china-nfl jerseys wholesale United States
3/2/2011 7:37:26 PM #

nice posts at this site, i have read a couple of other blogs at this site and they always stand out in my memory

WATCH tv on my pc
WATCH tv on my pc United States
3/3/2011 1:00:01 AM #

Well , to be honest , I am very slow to do  feedback on site and only  some times, I do so .But man your  tough work on this  original post ,affected me to  do a reply comment for you . I must  much much thankful to you for a  crucial web site .Instantly I am your bigger fan since of only this post. How considerably you  demonstrate the matters with the  using off yoursite?   One of my close friend named your internet site to  discover it out n she was okay about  you.

garrett pd6500i
garrett pd6500i United States
3/6/2011 8:15:37 PM #

Very interesting idea, i need some time to think about this. I have just got interested in blogging and hopefully i am able to do so

garrett pd6500i
garrett pd6500i United States
3/6/2011 8:18:06 PM #

chronograph watches from Oris or Hamilton for men for you to know then better if you want to buy one

cheaperseys
cheaperseys People's Republic of China
5/4/2011 9:28:53 PM #

you have a good post

p90x
p90x People's Republic of China
6/12/2011 8:50:57 PM #

The P90X Workout Schedule is comprised of three separate routines. You choose where you want to start based on your physical conditioning and then just push play. The three options are broken down into Classic, Lean, and Doubles. I will give you a breakdown of each P90X Workout Schedule for those that don't understand.

fddf
fddf People's Republic of China
3/31/2012 10:05:26 PM #

http://burberryoutlet-burberryscarf.com

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5