.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

TypePerf, Buffer Cache Hit Ratio, Page Life expectancy and some other counters....

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
Hello, I 've scheduled a Task on a Windows 2008 R2 Server (a Blade with 2 Processors (6 core HT) and 18 GB RAM) to check some SQL Server 2008 Performance Counters. The task runs TypePerf that checks the Counters every 15 seconds for 10 minutes. The task is scheduled every hour. The strange result is that Buffer Cache Hit Ratio, Page Life expectancy and some other Counters are ALWAYS = 0 but if I run PerfMon, Buffer Cache Hit Ratio is 100 and  Page Life expectancy >>>> 300. Any Idea? Thank youLuca Bovo MCTS - MCITP SQL Server 2005 (Database Administrator and Database Developer)

View Complete Post

More Related Resource Links

SQL Server 2005 buffer cache

Hello! I try to find out what objects use buffer cache. As example, in Oracle there is fixed table x$bh. This table gives us infomation about buffer cache on per block basis. Is there similar view or table in SQL Server 2005? How can I find out what table uses most of buffer cache?

Log Cache Page size

Hello: trying to get more details about Log Cache. i am aware that Data page size is 8KB. want to know the size of page in Log Cache, as i am not able to see that inofrmation in BOL & at MSDN. Any link or pointer is highly appreciated. Thanking in advance. Thanks

Don't Understand Checkpoint / Buffer Cache Explanation in BOL

Checkpoints and the Active Portion of the Log     ? Checkpoints flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion of the log that must be processed during a full recovery of a database. During a full recovery, the following types of actions are performed: The log records of modifications not flushed to disk before the system stopped are rolled forward. All modifications associated with incomplete transactions, such as transactions for which there is no COMMIT or ROLLBACK log record, are rolled back.   I don't understand this BOL page... From what I read in the first sentence above, the following must be true: I understand that SQL Server apparently doesn't save updated data directly to disk but stores it in RAM (the so-called Buffer Cache) until either this RAM buffer is full or until a checkpoint operation is executed.   If this is tue, Isn't this quite dangerous? What happens if the server is powered off? Are all updates that had been stored in the Buffer Cache / Log Cache lost? After a server restart, how can "The log records of modifications not flushed to disk before the system stopped" possibly be "rolled forward" if they had been stored in the Buffer Cache? After a server restart the Buffer Cache and the Log Cache must be empty! So there are no unsaved l

strange Cache and GridView bug after googlebot crawls a page


I have a strange ui bug in GridView !

GridView adds <font color="#000FFF"> after a page is accessed by a Google crawler and then when the page is views from the cache created by the bot  !!!

It is happening in the HeaderText "th" and TemplateField's and HyperLinkField's

I never set the color to <font color="#000FFF"> and i have CSS class's and ForeColor with all different colors

When a user enters a page it doesn't happens and no font tag is added !!!

please help...

ASP.NET Page Life Cycle question


Hi folks,

I have a doubt about when javascript (from markup and .js files) is read and executed in ASP.NET Page Life Cycle

In this article is not clear:


Please may you help me?

Thanks a lot

Very Low Procedure Cache Hit Ratio and High CPU Utilization


I have a SQL Server 2005 32 bit instance that occassionally has issues with the Procedure Cache.  This instances 200+ databases and is configured with 4 processors and 12 GB of memory.

The Procedure Cache Hit Ratio drops to 25% for an extended period of time.  The size of the procedure cache during this time is very small.  I am able to tell this by quering the DMVs.  Also, DBCC Memory status shows a small procedure cache area.

Using tools such as vmstat.exe or sqbmemory (from Red-Gate) I see that the Commited memory value drops from around 1900 MB to 600 MB and the Reserved memory value increases from 50 MB to 1350 MB.  The memory is being stolen from the Committed bucket and is being reserved by some other SQL process such as XML or CLR.

After we restart the instance, the memory pressure issues go away.

Do any of you know if there is a DMV or a tool that I

How to cache MVC page with sign in info?



[OutputCache (Duration=20, VaryByParam="None" )]
public ActionResult  display()

This code cache whole page.

But, my site has user infomation on top like this ASP.net. The user info "Signed as userid | Edit Profile | ..." section should be changed when user sign in/out. But rest of the page is always same and it's good to Cache.

If the above code is used, the user info on top also cached and give wrong info to user.

So, what is the best solution for this?

Any idea?

Thank you,

How to increase Log Cache Hit Ratio for tempdb ?


How to increase Log Cache Hit Ratio for tempdb ?

Log Cache Hit Ratio=58%

Page Life Cycle and custom composite server control life cycle



We are creating a composite server control. It will have few other controls. I am confused where exactly to write the code ie in which event. Is page life cycle and control life cycle follow the same event order?

Could any one please suggest or post articles on this.

Thank You

Cache Authenticated Page



How to cache authenticated page?

Stephen Walther suggests not to cache authorize page (http://stephenwalther.com/blog/archive/2008/08/29/asp-net-mvc-tip-40-don-t-cache-pages-that-require-authentication.aspx) , but every page I have need the built-in Authorize() filter for easy integration. Sad

I have tested both Authorize() and the CacheFilter in the same controller and indeed I can see the other users role account . How can I have the Authorize() and the Cachefilter in the same controller then?

The Cachefilter can be found here (http://weblogs.asp.net/rashid/archive/2008/03/28/asp-net-mvc-action-filter-caching-and-compression.aspx).

Thank You,


What is difference in Page Life cycle in general postback and postback due to child control of updat



Since both general postback and postback due  to child control of update panel causes a postback and all events of page are loaded then what is the actual difference between  general postback and postback due to child controls of update panel.

Also, it is said that childern of update panel do a partial postback .Then how it is a partial postback ?? I am seeing that whole page life cycle is  happening even in partial postback ?

Can anyone explain this ?

What happens to a page's cache when a user logs in?


When you cache a page I assume you are saving the rendered html that gets sent to the user who requested the page. What happens when the person who requests the page is logged in and their user name is displayed at the top of the page. This I assume will change the html that is rendered and thus mean the cache is rebuilt?

If so is there any point caching pages in such a scenario as I assume there will be a performance penalty rebuilding and storing the cache all the time?

I am not sure if this makes any difference but all the pages have a master page and this is where the login is displayed.



SharePoint WebPart Page Life Cycle

This Links explians in details the SharePoint WebPart page Life cycle

Changing the graphics on the home page of a SharePoint site

When you create a site in Microsoft Windows SharePoint Services by using the default Team Site template, the home page includes two default graphics. A Windows SharePoint Services graphic appears in the body of the page, and a picture of a house in a circle appears near the site title. You can change these graphics to customize your site. Changing the smaller graphic requires a Windows SharePoint Services compatible Web page editor

Using jQuery to directly call ASP.NET AJAX page methods

Here I am looking to explain how to call page methods using jQuery. Using jQuery to directly call ASP.NET AJAX page methods

Software Development Life Cycle (SDLC)

This is also known as Classic Life Cycle Model (or) Linear Sequential Model (or) Waterfall Method. This model has the following activities.

SDLC Approach or Software Development Life Cycle

SDLC process stats from conception to completion of any software project. According to this approach the software development team is responsible for the whole project development life cycle. After doing SRS and requirements analysis; developers follow different models of Software development Life Cycle (SDLC) available, while the most common model is SDLC waterfall model. They divide project in different stages & phases and the output of each stage or phase becomes the input for next stage.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend