SQLSACT (11/10/2012)
Are these clean pages or clean buffers?
Thanks
these are clean pages. SQL Server only drops pages from the buffer if there is not enough memory (or the server is restarted or you manually drop the cache). otherwise SQL Server holds the pages in memory for the next time they are accessed. that way the next query that is run the server wont have to read those pages from disk again. if the database is smaller than the ram on the system eventually the entire database may sit in memory and there is very little reading from disk. if the database is larger than the amount of ram on the system SQL Server has a very well designed algorithm for figuring out which pages have not been accessed in a while.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]