sys.dm_os_performance_counters Data Pivoted
        Posted  
        
            by NeilHambly
        on SQL Blogcasts
        
        See other posts from SQL Blogcasts
        
            or by NeilHambly
        
        
        
        Published on Sun, 19 Aug 2012 21:15:00 GMT
        Indexed on 
            2012/08/27
            21:47 UTC
        
        
        Read the original article
        Hit count: 214
        
Filed under: 
        At times I often want to know what is happening inside my SQL Servers, there are of course a multitude of ways I could "peek" into the activity that has been happening, Sometimes I just need to get a quick summary of those facts, maybe just to know if anything unusal has happened I'm not yet aware of, an easy way I can do that is to query the DMV sys.dm_os_performance_counters, As t here are tons of blog posts already out there on using the data from this DMV, I'm not going to focus...(read more)
        
        © SQL Blogcasts or respective owner