Thursday, June 13, 2013

Free Pages removed from Buffer Manager counterset in SQL 2012 Performance Counters

While creating some PowerShell to collect performance counters against servers for some performance analysis I am doing (more on that to come), I noticed that the script was throwing an error when trying to retrieve the SQLServer:Buffer Manager\Free Pages counter in my lab against my SQL 2012 instance. Yet it was working on site today against some earlier releases of SQL.

While there is no official guidance on this the counter is certainly no longer listed on the Buffer Manager Object definition http://technet.microsoft.com/en-us/library/ms189628.aspx.

So word of warning if you are migrating any performance collector sets to SQL 2012. Or if you are using PSSDiag/SQLDiag and PAL and you wonder why that counter is no longer reporting data.

I'd suggest focusing on Page Life Expectancy as your indication of buffer pool usage. Honestly I never really worried about Free Pages only to make sure that if it dropped that PLE also reported changes so that I knew it was normal behavior.

4 comments:

  1. Copying Moncler clothes are very nice and very temperate. cheap moncler jackets I really like this replica Moncler dress. The store service is very good,cheap moncler overcoats the quality of the clothes is very good, and the price is very good. I think I am very cheap and cheap.

    ReplyDelete
  2. The quality of this replica Louboutin shoe is perfect, high quality cheap Louboutin Shoes Uk Online it is very comfortable to wear, wear this shoe when you travel, it will not be tired.cheap Louboutin casual shoes I recommended this site to my good friends, they are very happy, can buy such cheap Louboutin shoes

    ReplyDelete
  3. When you think of the ray ban original word Retro-Wingtip, you don’t think of a traveler on foot, but rather as one of the most enduring fashion icons of the ray ban sunglasses men 20th century – the Ray-Ban sunglasses. From Matthew McConaughey on the red carpet to Tom Cruise in the film Risky Business, Ray-Ban sunglasses have been donned by some of the biggest stars in Hollywood. Combined with a denim jacket over a plain white T-shirt, the Retro-Wingtip gives you that classic-cool trademark look of the 1950’s.

    ReplyDelete
  4. I have been paying attention to replica watches.réplique montres à vendre After receiving the goods, I was very surprised, the leather strap is comfortable, the watch is light weight, high quality and the price is good. If you are looking for a watch that suits your everyday wear, copier rolex yacht master montres this replica watch is definitely the perfect outfit. I will buy again!

    ReplyDelete